Importing a tab-delimited file--How to handle CRs?

  • Follow


I'm constructing a 1-field file to import.

Each field consists of variable-length text. Many have carriage
returns that need to be preserved, but of course, the CR is
exclusively used to terminate the record.

I  read somewhere that changing the CRs (code 13?) to ASCII 11 would
do it, but I am using BBedit on the Mac and cannot figure out how to
accomplish this. I'm willing to use Word if that's what it takes, and
if this is the correct procedure.

Thanks
0
Reply captmarvel 8/5/2004 6:56:51 PM

in article e48d61f.0408051056.60488c02@posting.google.com, CaptMarvel at
captmarvel@notme.com wrote on 8/5/04 11:56 AM:

why not use a "|" (pipe character) for your return and then use the
Substitute Function in FileMaker to replace the "|" with the "�"?

Lee

> I'm constructing a 1-field file to import.
> 
> Each field consists of variable-length text. Many have carriage
> returns that need to be preserved, but of course, the CR is
> exclusively used to terminate the record.
> 
> I  read somewhere that changing the CRs (code 13?) to ASCII 11 would
> do it, but I am using BBedit on the Mac and cannot figure out how to
> accomplish this. I'm willing to use Word if that's what it takes, and
> if this is the correct procedure.
> 
> Thanks

0
Reply Lee 8/5/2004 8:34:04 PM


1 Replies
227 Views

(page loaded in 0.096 seconds)

Similiar Articles:













7/29/2012 6:21:05 AM


Reply: