September 23, 2011 at 6:18 pm #9674
CrashNBurn
Member
AH! Sorry :-)
Well given the following input:
34,George,Clooney,123456,LDL,356,mg
34,George,Clooney,123456,HDL,324,ml
34,George,Clooney,123456,VLDL,635,kg
If your file is tab delimited instead of commas, then you will need to replace all commas below with “t”
Step 1:
Search: ^(d+),([A-Za-z]+),([A-Za-z]+),(d+),(.*)
Replace: 1,2,3,4,n5
Step 2:
Search: ^(d+,[A-Za-z]+,[A-Za-z]+,d+,)n[A-Z]+,(d+),([a-z]+)n1n[A-Z]+,(d+),([a-z]+)n1n[A-Z]+,(d+),([a-z]+)n
Replace: 12 3,4 5,6 7n
Final Output:
34,George,Clooney,123456,356 mg,324 ml,635 kg