September 23, 2011 at 8:14 pm #9675
user
Participant
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?