Import from variable length text
Hi,
I'm trying to import from a text file but I can't separate in columns correctly.
The data is much like this:
0000 NAME NAME NAME 000 000
0000 NAME NAME 000 000
0000 NAME NAME NAME NAME 000 000
I need the full name on one column.
But using space as separation delimiter gives me:
0000|NAME| NAME| NAME| 000 | 000
0000|NAME| NAME| 000 | 000 |
0000|NAME| NAME| NAME| NAME| 000| 000
can anyone help me?
|