bulk replace

[monojchakrab]

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

[Anonymous · Accepted solution]

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]

Thanks @Anonymous ,

will try out your solution

[monojchakrab]

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.

[jaipal]

@monojchakrab as long as I understand your question, I would suggest to change all the cases to "lowercases" and replace values. This may helpful