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
Yes jaipal ,
That seems to be one way of doing that but there is another more elegant way and that is to use this function :
comparer.cardinalignorecase - I saw this function used to success in one of the blogs.