By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

Space Delimiter in a flat file

P: 2
I am trying to read a flat file as the source file with space as the delimiter. I am using the "SQL Import and Export Wizard", and under the "demilited", there is the following options:
{CR} {LF} {;} {:} {t} {,} {|}

When I tried to use {CR} (carriage return}, it read in the whole line of course. Is there a way I can read in correctly a flat file with spaces as the delimiters?

Thanks,
Mar 24 '08 #1
Share this Question
Share on Google+
1 Reply


debasisdas
Expert 5K+
P: 8,127
{CR} will read the whole line .

Try using { }
Mar 25 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.