How do import data using | as a delimeter?

S

SteveM

Not sure if you can use that character in an Import Specification but you
could always do a Find & Replace on the text file to convert them to commas.
 
P

Pat Hartman

File/Import - change the file type, select the file you want to import.
When the wizard opens, press the Advanced button to see the option to change
the delimiter. You should be able to type a character in the field if it is
not in the list.
 
M

mrniceguy07

This works perfectly. Thanks for your help!

Pat Hartman said:
File/Import - change the file type, select the file you want to import.
When the wizard opens, press the Advanced button to see the option to change
the delimiter. You should be able to type a character in the field if it is
not in the list.
 
Top