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
Solved! Go to Solution.
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
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
Thanks @Suvrutt_Gurjar For Your Reply
Your Suggestion Worked
Thank you @Amit_Jain for your update. Good to know the expression was useful to you.
Not sure about your values in generally, but if the string is always like “X 36 X”, you could use…
SUBSTITUTE([ColumnName],“X 36 X”,“X”)
No Sir
Its Variable
Every Time Its Different Value
But Right Left Delimiter are Same
Hi @Aleksi,
You are indeed master. Your expressions are always most compact.
Hi @Suvrutt_Gurjar
@Aleksi is a true ALIEN
Hi @LeventK,
I totally agree. He always has the most compact solutions that we simply fail to think through.
Of course you are also a techie with expertize in many software technologies.
We keep getting insights on a daily basis from all in this great community.
Hi boys,
@Aleksi ,Is the smart boy. I hope one day I can understand all the things you write sometimes, for me it seems badwords but very badwords. 😂
My God, what's is that:🙄
CONCATENATE(INDEX(SPLIT([Original Text],“delimeter”),1),“delimeter”, INDEX(SPLIT([Original Text],“delimeter”),3))
I understand until Split - SPLIT([Original Text],“X”)
Learning INDEX.... aha, understood, you use it because you need to say to the app that you want after SPLIT the 1st option and then add the new with the 3th. Interesting.
Thanks boys, now it seems not badwords, only new ideas. I try to find a solution for me.
Sara
User | Count |
---|---|
33 | |
30 | |
29 | |
20 | |
18 |