hello

I have in an excel file a table like this and I want to make it look like the table below:



anyone know how to do it?

thanks!

Save the excel document as a CSV.

Open file in EmEditor.

Edit -> Separated Values/Sort -> CSV Mode

thanks, but I don't think you understood my question

I know how to create csv files and open then in EmEditor

what I want is to transform the first table into the second (as shown in the picture)

AH! Sorry

Well given the following input:
Quote:

If your file is tab delimited instead of commas, then you will need to replace all commas below with "\t"

Step 1:

Step 2:


Final Output:

thanks for your reply

it would be interesting if it works, but I got the message "Cannot find ^(\d+),([A-Za-z]+),([A-Za-z]+),(\d+),(.*) anywhere in the document"

(regex are enabled)

also, please note that the original text is:

34,George,Clooney,3456346,LDL,356,mg
34,George,Clooney,3456346,HDL,324,ml
34,George,Clooney,3456346,VLDL,635,kg
34,Tom,Cruise,4573456,LDL,463,dl
34,Tom,Cruise,4573456,HDL,746,cm
34,Tom,Cruise,4573456,VLDL,435,dc
35,Al,Pacino,5646464,LDL,467,hg
35,Al,Pacino,5646464,HDL,352,df
35,Al,Pacino,5646464,VLDL,643,rf

and not just:
34,George,Clooney,3456346,LDL,356,mg
34,George,Clooney,3456346,HDL,324,ml
34,George,Clooney,3456346,VLDL,635,kg

any hint?

At the right of the Search field is [>]
Click on that and choose "Multiline"

there is no multiline displayed in your posted search and replace values (probably due to the forum format)

can you paste them as plain text?

Multiline is a regex option. You need to select it.
My Search regex is a multiline regex (it contains multiple newlines). You need to select "Multiline" from the pop-up menu that is available when you click [>]

> My Search regex is a multiline regex (it contains multiple newlines).

I know, but when I copy it and paste it in any text editor (not just in the search field of EmEditor), it shows as a single line

also, have you noted that the original text is:
34,George,Clooney,3456346,LDL,356,mg
34,George,Clooney,3456346,HDL,324,ml
34,George,Clooney,3456346,VLDL,635,kg
34,Tom,Cruise,4573456,LDL,463,dl
34,Tom,Cruise,4573456,HDL,746,cm
34,Tom,Cruise,4573456,VLDL,435,dc
35,Al,Pacino,5646464,LDL,467,hg
35,Al,Pacino,5646464,HDL,352,df
35,Al,Pacino,5646464,VLDL,643,rf

and not just:
34,George,Clooney,3456346,LDL,356,mg
34,George,Clooney,3456346,HDL,324,ml
34,George,Clooney,3456346,VLDL,635,kg

isn't there any problem with that?

EmEditor Home » EmEditor Help » Dialog Boxes

> button

Quote:

In a Regex string, a \n is a newline.
As well as \r\n e.g. CRLF

The fact that my regex is a "single line string" is irrelevant. It contains multiple \n newlines, and if you want it to work as intended ---- which is to look on multiple lines for search matches/input, then you need to select "Multiline" from the dialog, as I mentioned previously.