Find and Replace

Hi Team,

Hope you are well. I am trying to replace and find on below text. Please let me know how to go about this

Question : where ever [.] and | will be replaced with ;

'Investigate_-_Rectangle[.]Side_entrance_(red_flag)_-_Picture1.png|No_investigation_-_Rectangle[.]Camera_-_Image_3.png|Investigate_-_Rectangle[.]CCTV_(red_flag)_-_CCTV_Monitoring.png|No_investigation_-_Rectangle[.]Truck_-_Image_4.png

But the below formula is not working its giving [;] instead of ;

Thanks ,

Sri

Regex

Accepted answers

binu_acs

@sriniprad08 one way of doing this

Replace_0512.yxmd

All comments

binu_acs

@sriniprad08 one way of doing this

Replace_0512.yxmd

ShankerV

Hi @sriniprad08

You can try Find and Replace tool, which will help to over come the issue.

Many thanks

Shanker V

ShankerV

Hi @sriniprad08

Input:

Workflow:

Output:

Many thanks

Shanker V

ShankerV

Hi @sriniprad08

Input tool for Find and Replace: We can add as much as find and replace criteria's and help to do replace at one go.

Find and Replace tool:

Many thanks

Shanker V

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703