avinash09 <avinash.i...@gmail.com> wrote: > Thanks Toke , nice explanation , i have one more concern instead of comma > separated my columns are ^A separated how to deal ^A ??
I am really not proficient with control characters and regexp. If ^A is Start Of Heading, which has ASCII & unicode character 1, my guess is that \u0001 matches it. So something like regexp="^([^\u0001]*)\u0001([^\u0001]*)\u0001([^\u0001]*)\u0001...$"? Untested and all. But why not use the CSV import handler? That seems like the best fit. - Toke Eskildsen