Spliting rows from file

[Luk88kk]

Hi,

Could you please help me with the split lines in the file.

I have tried using the Text To Columns Tool and RegEx but it still does not work for me.

It is:

File_name

PART_1_ADAM

PART_1_ADAM

PART_1_TOM

PART_1_TOM

PART_1_LUCAS

PART_1_LUCAS

PART_1_LUCAS

PART_1_LUCAS

PART_2_AMANDA

PART_2_AMANDA

PART_2_ANDREW

Should be:

File_name	Part	Person
PART_1_ADAM	PART_1	ADAM
PART_1_ADAM	PART_1	ADAM
PART_1_TOM	PART_1	TOM
PART_1_TOM	PART_1	TOM
PART_1_LUCAS	PART_1	LUCAS
PART_1_LUCAS	PART_1	LUCAS
PART_1_LUCAS	PART_1	LUCAS
PART_1_LUCAS	PART_1	LUCAS
PART_2_AMANDA	PART_2	AMANDA
PART_2_AMANDA	PART_2	AMANDA
PART_2_ANDREW	PART_2	ANDREW

[aatalai · Accepted solution]

@Luk88kk take a look at the attached workflow it should do the trick, let me know how you get on.

[Krzysiek · Accepted solution]

Parse output method in RegEx should be useful:

If you always have got upper case

(\u{4}_\d{1})_(\u+)

and here case non sensitive, same result

([[:alpha:]]{4}_\d{1})_([[:alpha:]]+)

[Raj · Accepted solution]

@Luk88kk 

both the methods attached below
hope this help.

[jdminton · Accepted solution]

I would suggest slightly different RegEx to make it more dynamic. This RegEx will look for a number followed by the underscore to parse and not be too specific about what comes before. This could be important if more underscores or other characters show up in the beginning part of the string. Also, it won't break if a different character aside from uppercase letters appears in the name. 

 

[Luk88kk]

Hello,

thank you very much for your support, everything works great!