exporting chr field in quotes

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Nevzat_(Guest)
Posts: 6
Joined: Tue Oct 10, 2017 12:44 pm

exporting chr field in quotes

Post by Nevzat_(Guest) » Thu Mar 11, 2010 7:34 am

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__________ __________

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: exporting chr field in quotes

Post by kfleming » Sat Mar 13, 2010 7:39 am

This is actually the as designed behavior of R&R.____Kathleen__R&R Support

castrass
Posts: 14
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: exporting chr field in quotes

Post by castrass » Wed Mar 24, 2010 9:41 pm

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.

Post Reply