Perl RegEx Back References

[slouw]

Please help with a Find and Replace using Perl Regex and back references.
I get the unexpected output as shown in the 2nd screenshot.
I am expecting/wating to get rid of everything after the first 3 CSV entries





Many thanks for nay reply

[DataMystic Support]

\001\002\003 is wrong, needs to be

Code: Select all

$1$$2$$3$

ie $1$ followed by $2$ etc

[slouw]

Fantastic! Thank you. Works a treat. Should I have seen this in the notes/help somewhere? Thanks again

[dfhtextpipe]

But why not use a CSV replace filter?

Simpler to understand & maintain.