Forum Discussion
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 & when there are case mismatches.
Is there a comprehensive solution which addresses both these issues?
Any help appreciated
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
4 Replies
monojchakrab as long as I understand your question, I would suggest to change all the cases to "lowercases" and replace values. This may helpful
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.
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
Thanks Anonymous ,
will try out your solution
