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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data, Text to Columns, has commas in the text, plus as a delimeter 2
csv delimeter 3
Converting excel 2007 to tab delimeter text file 1
Import delimeter file into existing table? 15
how to treat consecutive delimeter as one when importing data? 1
Save Excel file to CSV with quotation mark data delimeter? 2
modify import specs 3
Please help import data 0

Top