AnsweredAssumed Answered

Replace()

Question asked by marp on Jan 12, 2016
Latest reply on Jan 12, 2016 by frank.field@nintex.com

My original question was: “I need the IT-Costcenter from a string e.g. ITCOST=1234567; COST=7654321; ACC=0000. The rest should be replaced with " ". How can i achieve that with replace()? I tried it but i didn't get the desired result.”

 

The solution was replace(replace(costcenter,"(ITCOST=)+",""),"([;](.)*)","") and it worked perfectly (thanks for your help!). Now i have the problem, that I need the second value from the string e.g. ITCOST=1234567; COST=7654321; ACC=0000 for a second field. Could someone help me …again.

 

Thanks for your help! I really appreciate it!

 

 

The solution was: replace(replace(_costcenter,"((.)*(; COST=)+)",""),"([;](.)*)","")

Outcomes