Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
3 posts • Page 1 of 1
Hi,____I am trying convert .dbf file to text file for telephone messaging systems.______My dbf fields :__NAME, SURNAME AND TEL all of FIELD TYPE ARE CHRACTER.__TEL FIELD CONTAINS NUMBERS (eg. 0123456789)____WHEN I WANT TO EXPORT TO TEXT FORMAT OUTPUT IS AS FOLLOWS:____1 - GEORGE,MICHEL,"552345566" COMMA DELIMITED__2 - GEORGE MICHEL "552345566" TAB DELIMITED__3 - GEORGE,MICHEL,"552345566" CHRARACTER DELIMITED__4 - GEORGE MICHEL "552345566" SDF FIXED WITH____PLEASE NOTE THAT TELEPHONE NUMBERS ARE APPEARING WITHIN double Quotation. BUT IF TEL FIELD CONTAINS ANY ALPHA CHRACTERS OUTPUT IS__WITHOUT Quotation.____EXAMPLE : 5 - GEORGE,MICHEL,552X345566____CORRECT ONE SHOULD BE THIS. ?____REGARDS__NEVZAT__________ __________
One way that I found to control the output completely, is to create a calculated field consisting of the character equivalents of your data. So, if you have a record with the information:____FirstName = GEORGE__LastName = MICHEL__Phone = 552932888____You could create a calculated field with the expression being:____RTrim(FirstName ) + "," + RTrim(LastName) + "," + Phone____and your output would be:__GEORGE,MICHEL,552932888____Because it^s mixed alpha-numeric, there won^t be additional quotation marks as with the all numeric phone number.