Forum Discussion

monojchakrab's avatar
monojchakrab
Resolver III
4 years ago
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 &...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    monojchakrab
    Resolver III
    4 years ago

    Thanks Anonymous ,

     

    will try out your solution