Space Delimiter in a flat file

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Liz2
    New Member
    • Mar 2008
    • 2

    Space Delimiter in a flat file

    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,
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    {CR} will read the whole line .

    Try using { }

    Comment

    Working...