Find and Replace in .TXT file

[GatesV]

Anyone can provide me with a way to find a string in a .TXT file and replace it with another string, then save the file on itself?

Much appreciated.

Thank you

 

[sunortap]

Have you tried to?:
1) read txt file to data item
2) convert text in data item
3) overwrite txt file

 

[GatesV]

Other than by code, I don't think there's a way to do what I need to do, which is replace every occurrence of s semicolon by a comma. Not sure what that code would be.

 

[gil.silva]

Hello GatesV,

You can achieve what you need in multiple ways, in my opinion, the easiest one would be:

1) Open notepad
2) Send Global Keys: ^a^c (select all and copy)
3) Utility Environment: Get Clipboard | Output: copied_text
4) Calculation stage: Replace([copied_text], ";", ",)
5) Write action with the updated [copied_text] as Input

 

[GatesV]

Even though I would have preferred doing it with a code stage, that’s exactly what I ended up doing except I converted the file to a Word document with the File Management utility so I could use the Word VBO built in functions for select all, copy and paste. Thanks for your reply.