Page 1 of 1
Tab Delimited Export
Posted: Wed Oct 31, 2007 2:25 pm
by Jeff_Lassell_(Guest)
I am using v11 of R&R.____I need to be able to print TEXT data fields that contain NUMBERS (ie, SSN or DATES like 20070606) to a TAB-delimited file without "" marks around it.____It appears that number fields, character fields that contain characters, and date fields with "/" marks can be written w/o the ""; but text data that contains only numbers is written with "". ____Is there a way to write my "text numbers" w/o the ""^s?____Thanks,
=> RE: Tab Delimited Export
Posted: Wed Oct 31, 2007 2:50 pm
by kfleming
If the text field contains only numbers, you could create a calculated field using the VAL() function to convert it to a number.____Kathleen__R&R Support
==> RE: Tab Delimited Export
Posted: Thu Nov 01, 2007 2:23 am
by Jeff_Lassell_(Guest)
Thank you. That was a consideration, however that leaves me without any leading zero^s which, in the case of a ssn, is actually part of the #. Our data also contains many other ^codes^ that have leading zero^s which we routinely exchange with outside agencies. It seems that the "^s aren^t necessary in a TAB-delimited format and aren^t standard practice.