Find and Replace

[sriniprad08]

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

[binuacs · Accepted solution]

@sriniprad08 one way of doing this

[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