View Single Post
 
Old 07-10-2012, 05:13 AM
diouna diouna is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Jul 2012
Posts: 2
diouna is on a distinguished road
Default 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?
Reply With Quote