Return to Question

I have a text file (name, surname, phone number) than I would import in excel and the play with column (name, surname...)

The file was previously a docx file. I've converted it on as a text file. But the converted txt file, has a strange format: Repeated 6 lines block, with each field (name, surname, phone, town)

xxx yyy 999 zzz xxx1 yyy1 

repeated more times. I would compact each block in a single line and separete field by space. NOTE that xxx1 and yyy1 are name and surname of next person So I can import it in excel, taking space as a separator column.

How can I do that? I know I can do that in lisp, but I do not know it

Than you

Renato

I have a text file (name, surname, phone number) than I would import in excel and the play with column (name, surname...)

The file was previously a docx file. I've converted it on as a text file. But the converted txt file, has a strange format: Repeated 6 lines block, with each field (name, surname, phone, town)

xxx yyy 999 zzz xxx1 yyy1 

repeated more times. I would compact each block in a single line and separate field by space. NOTE that xxx1 and yyy1 are name and surname of next person So I can import it in Excel, taking space as a separator column.

How can I do that? I know I can do that in Lisp, but I do not know how.

I have a text file (name, surname, phone number) than I would import in excel and the play with column (name. surname...)

The file was previousalya docx file. I've converted it on as a text file. But the converted txt file, has a strange format: Repeated 6 lines block, with each field (name, surname. phone, town)

xxx yyy 999 zzz xxx1 yyy1 

repeated more times. I would compact each block in a single line and separete field by space. NOTE that xxx1 and yyy1 are name and surname of next person So I can import it in excel, taking space as a separator column.

How can I do that? I know I can do that in lisp, but I do not know it

Than you

Renato

I have a text file (name, surname, phone number) than I would import in excel and the play with column (name, surname...)

The file was previously a docx file. I've converted it on as a text file. But the converted txt file, has a strange format: Repeated 6 lines block, with each field (name, surname, phone, town)

xxx yyy 999 zzz xxx1 yyy1 

repeated more times. I would compact each block in a single line and separete field by space. NOTE that xxx1 and yyy1 are name and surname of next person So I can import it in excel, taking space as a separator column.

How can I do that? I know I can do that in lisp, but I do not know it

Than you

Renato

I have a text file (name, surname, phone number) than I would import in excel and the play with column (name. surname...)

The file was previousalya docx file. I've converted it on as a text file. But the converted txt file, has a strange format: Repeated 6 lines block, with each field (name, surname. phone, town)

xxx yyy 999 zzz xxx1 yyy1 

repeated more times. I would compact each block in a single line and separete field by space. So I can import it in excel, taking space as a separator column.

How can I do that? I know I can do that in lisp, but I do not know it

Than you

Renato

I have a text file (name, surname, phone number) than I would import in excel and the play with column (name. surname...)

The file was previousalya docx file. I've converted it on as a text file. But the converted txt file, has a strange format: Repeated 6 lines block, with each field (name, surname. phone, town)

xxx yyy 999 zzz xxx1 yyy1 

repeated more times. I would compact each block in a single line and separete field by space. NOTE that xxx1 and yyy1 are name and surname of next person So I can import it in excel, taking space as a separator column.

How can I do that? I know I can do that in lisp, but I do not know it

Than you

Renato