SOP57307145_1_1 |
SOP57307145_1_1 |
SOP57307145_2_1 |
SOP57307145_2_1 |
SOP57307145_2_2 |
SOP57307145_2_2 |
SOP57307152_1_1 |
SOP57307152_1_1 |
SOP57307152_2_1 |
SOP57307152_2_1 |
i have a multiple lines in a column and i want to separate these out, so in the example above i want to get rid of the first 3 characters "SOP" and then separate the next 3 sets of data into 3 columns so i would get
57307145 | 1 | 1 |
57307145 | 1 | 1 |
with the conditions that all three columns could have a different total number of characters in each string i.e
SOP5730714_12_5 |
SOP573071456_1_15 |
and so on. text to columns is not workable as i want to automate 1000's of lines
cheers