Forum Discussion
Solved
bulk replace
Hi good people of PBI community, I have read thru and used most of these solutions but none of them seems to work when the text to replace contains multiple strings - e.g. navi mumbai by mumbai &...
HI monojchakrab,
I think you can split the string into a variable list and loop its items to check and exclude matched elements, then you can use concatenate function to merge remains items to achieve your requirement.
Can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
monojchakrab as long as I understand your question, I would suggest to change all the cases to "lowercases" and replace values. This may helpful