To extract string from a text file

[Nani_Kumar]

Hi All,
I have a text file where it has specific string “ABC” in multiple rows/places and I want to fetch that string and replace with “BCD” .

Could you please help me with the expression?

ABC
ABC
ABC
ABC

[prasath17 (Guru)]

@Nani_Kumar - Use regex replace

[Nani_Kumar]

Thanks Prasath, I am a newbie and exploring Regex expressions how to write syntax for this expression.
First I have to find the word “AbC” and then replace with “BCD”.
Could you please help me with same?

[Etienne_Vahrmeijer (Etienne)]

Hi Nani Kumar

This is my default string values: I want to replace the CCC

This is my result with them changed

Use an assign

NewSTRValue = YourSTRValue.Replace(“CCC”,“CorrectValues has been changed”)

in your case it would be
NewSTRValue = yourSTRValue.Repalce(“ABC”,“BCD”)

[NIVED_NAMBIAR (NIVED N)]

Hi @Nani_Kumar try this code using assign activitiy

Assuming u had stored ur string in input varaible

Then use the below code

input = System.Text.RegularExpressions.Regex.Replace(input,“ABC”,“BCD”)

Regards

Nived N

Happy Automation

[ppr (Peter Preuss)]

@Nani_Kumar
as you requested a case insensitive matching go for following (RegEx)

System.Text.RegularExpressions.Regex.Replace(YourStringVar,“ABC”,“BCD”,RegexOptions.IgnoreCase)

Help for Regex have a look here:

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…