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?