Community

how can i delete the everything from "errored" to the end of the path using regluar expression?

\\06_Pmt_scheme__7_aircraft.xls","Errored","Adelphia_1999_2003_180536",""

output=\06_Pmt_scheme__7_aircraft.xls",

Thanks for the help

Find errored.*\\
Replace <nothing>
I have used POSIX regular expression syntax, which can be selected from the Editor page of the Preferences dialog box.
Pls note that for this to work the data must be on a single line, as shown below using the code tag. HTH