Hi @ravi13 , there are a number of ways it can be done, but the following in String Manipulation should do it if you wish to leave the “/” characters untouched as per your sample output
If you don’t want the // in the middle or the trailing / either, then with your sample data the following would work. replace($Invoice No$,"/"+$Fin Year$ ,"" )
or, if the financial year could also appear at the start, and you wanted to lose the / with it, you could nest two variations: replace( replace( $Invoice No$,"/"+$Fin Year$ ,"" ) ,$Fin Year$+"/","")
@takbb already provided you the right solution (great work)
Just in case you don’t have the first column as reference then you could go with a regex in string manipulation