Hi KNIME Experts & Enthusiastic!!
Trust you are safe.
I am having following problem while working on my workflow.
Want to remove financial year from Invoice no., but it can be any year not specific for 2018-19 or 2019-20 or 2020-21.
I have tried using table row variable & string manipulation, but i am not getting desired result.
Thanks in advance.
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
replace($Invoice No$,$Fin Year$ ,"" )
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$+"/","")
Hi @takbb ,
thanks for solution
@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
Hi @Daniel_Weikert ,
Thanks for attention. I will definitely consider this solution for future workflow.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.