Remove rows length != 10 characters and replace 3rd last character from the rows if exists

[mayankjha986 (Mayank986)]

Looking to remove rows whose character length is not equals to 10, and how to replace the 3rd last character from the rows if an specific character exists.

I would like to replace “O” or o with “0”.

I have tried working with Filter activity as well as

Dt1 = Dt1.Select(“LEN(0) = 15”).CopyToDataTable

But its not working

Please Suggest

[ppr (Peter)]

@mayankjha986

Dt1 = Dt1.Select(“LEN(0) = 15”).CopyToDataTable

For the Length Part:
give try on Dt1 = Dt1.Select(“LEN([YourColName]) = 15”).CopyToDataTable

As alternate we can check LINQ for this

[mayankjha986 (Mayank986)]

@ppr

Dt1.Select(“LEN([YourColName]) = 15”).CopyToDataTable

@ppr Thanks for the answer, How to replace the 3rd last character from the rows if exists
I would like to replace “O” or o with “0”.

[ppr (Peter)]

give a try on regex replace:

[mayankjha986 (Mayank986)]

@ppr Not getting the last 3rd character and how to replace it .

[ppr (Peter)]

share sample values with us. Thanks

[mayankjha986 (Mayank986)]

225ACHN1AZ
36AHDGBI2K
267HFJK3CB
88JHDSHI8U
678BCZHiJK

Expected Output :

225ACHN1AZ
36AHDGB12K
267HFJK3CB
88JHDSH18U
678BCZH1JK

[ppr (Peter)]

@mayankjha986

Looking to remove rows whose character length is not equals to 10, and how to replace the 3rd last character from the rows if an specific character exists.

I would like to replace “O” or o with “0”.

@mayankjha986

225ACHN1AZ
36AHDGBI2K
267HFJK3CB
88JHDSHI8U
678BCZHiJK

Expected Output :

225ACHN1AZ
36AHDGB12K
267HFJK3CB
88JHDSH18U
678BCZH1JK

dont see any oO replacements in your samples and expected output

[mayankjha986 (Mayank986)]

225ACHN0AZ
36AHDGBO2K
267HFJK3CB
88JHDSHO8U
678BCZHoJK

Expected Output :

225ACHN0AZ
36AHDGB02K
267HFJK3CB
88JHDSH08U
678BCZH0JK

@ppr Please find the updated data

[ppr (Peter)]

Pattern: [oO](?=\S{2}\s*$) Also tolerant on end for spaces etc.
Usable in Regex Replace as mentioned above.

Please tell us what is not covered? Thanks

[mayankjha986 (Mayank986)]

@ppr - How to write the activity in UIPath.

Please Suggest

[ppr (Peter)]

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…

Replace Activity or

Assign Activity:
newText = System.Text.RegularExpressions.Regex.Replace(YourStringTextVar, “oO”, “0”)