Spliting rows from file

Question

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_namePART_1_ADAMPART_1_ADAMPART_1_TOMPART_1_TOMPART_1_LUCASPART_1_LUCASPART_1_LUCASPART_1_LUCASPART_2_AMANDAPART_2_AMANDAPART_2_ANDREW

Should be:

File_namePartPersonPART_1_ADAMPART_1ADAMPART_1_ADAMPART_1ADAMPART_1_TOMPART_1TOMPART_1_TOMPART_1TOMPART_1_LUCASPART_1LUCASPART_1_LUCASPART_1LUCASPART_1_LUCASPART_1LUCASPART_1_LUCASPART_1LUCASPART_2_AMANDAPART_2AMANDAPART_2_AMANDAPART_2AMANDAPART_2_ANDREWPART_2ANDREW

aatalai · Accepted Answer

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

Krzysiek · Accepted Answer

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 Answer

@Luk88kk

both the methods attached below
hope this help.

jdminton · Accepted Answer

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.