Modify text -> Find and replace text

[Kristoffer_Barstad]

Hello everybody

This is my first post.

i have a problem where i have som log files where i need to remove sensitive data before sending them further down the line.

the line i want to replace is: “cpr”: “xxxxxx-xx”

where i want to replace all the x’s with the string value “null”

im using modify text and find and replace. and i need a way to search between the to double qoutes, like a non greedy selector kinda thing where “x” is

in “search for” im using follow method :

chr(34)+“Cpr”+chr(34)+": "+chr(34)+“X”+chr(34)

and in “replace with” im using the follow method :

chr(34)+“Cpr”+chr(34)+": "+chr(34)+“Null”+chr(34)

to sum up i need to find a way to search the “X” wich is inbetween the two chr(34) wich present double qoutes

[Steven_McKeering]

@Kristoffer_Barstad

cpr”: “xxxxxx-xx”

Hello

You could use Regex to dynamically replace the x values.

Check out this Regex pattern(regex101: build, test, and debug regex)

Are the quotation marks (“”) present in the string?

[Kristoffer_Barstad]

cool i will try it out right away , thx

[Steven_McKeering]

Cool - let me know how it goes.

If you want to learn Regex check out my Megapost for new users

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[Kristoffer_Barstad]

With some small modifications i made it work, with your solution.

thank you very much Steven!

• Have a great day!