Tab Delimited Issue

  • Thread starter Thread starter GEORGIA
  • Start date Start date
G

GEORGIA

Hi,
I am trying to Link a text file tab delimited, however one of the column
(comment field) has tabs also therefore when I try to link the file, it
seperates the comments.
For Example:
Date: 1/1/2010
Comments: this is a test<tab? purposely only
User: John Doe

so when that is linked it sort of looks like this:
1/1/2010, this is a test, purposely only, john doe.

There are about 36 headers and comment field is in the middle, and when
link, it is throwing the data into next line making impossible to capture
some of the data.

Thank you!


is there anyway to fix this?
 
I am trying to Link a text file tab delimited, however one of the
column (comment field) has tabs also therefore when I try to link
the file, it seperates the comments.
For Example:
Date: 1/1/2010
Comments: this is a test<tab? purposely only
User: John Doe

so when that is linked it sort of looks like this:
1/1/2010, this is a test, purposely only, john doe.

There are about 36 headers and comment field is in the middle, and
when link, it is throwing the data into next line making
impossible to capture some of the data.

Thank you!


is there anyway to fix this?
Click to expand...

If the fields are surrounded by quotes, they should be able to
include tabs inside them, just as with quotes, you can have Cr/Lf
inside a data field even though Cr/Lf is the end-of-record marker.

I haven't tried it, though -- I'm just saying it *should* work.
 
they are not surrounded by quotes :(


David W. Fenton said:
If the fields are surrounded by quotes, they should be able to
include tabs inside them, just as with quotes, you can have Cr/Lf
inside a data field even though Cr/Lf is the end-of-record marker.

I haven't tried it, though -- I'm just saying it *should* work.
Click to expand...
 
Back
Top