Solved: Substitute Text Between Two Delimiter - Page 2

Amit_Jain1 · 11-24-2019 08:33 PM

Hello Friends,
I want to SUBSTITUTE Text Column Between Two Delimiter to New Text

Eg. From
HM Nat. 11 X 36 X 230@150@121

To
HM Nat. 11 X 230@150@121

I want To Replace " X 36 X "
With " X "

Any Idea How to Achieve This Desired Result from Expression

Suvrutt_Gurjar

hI @Amit_Jain,

Please use an expression something like below

CONCATENATE (INDEX(SPLIT(“HM Nat. 11 X 36 X 230@150@121”,“X”),1),“X”, INDEX(SPLIT(“HM Nat. 11 X 36 X 230@150@121”,“X”),3))

Or let us say your original text is available in column [Original Text] and let us call delimeter character as “delimeter” (“X”) in your case then the expression will be something like

CONCATENATE(INDEX(SPLIT([Origina Text],“delimeter”),1),“delimeter”, INDEX(SPLIT([Original Text],“delimeter”),3))

Below image shows the expression tested in app editor

View solution in original post