How to Replace the first x characters of a string with a specific character

[Greggy (Greggy O)]

Hi everyone, hope anyone of this thread can help me. I have a variable strMasked = 123456789012 , I want to convert the first few characters with “X” and retain the last the four digits as is. The output should be XXXXXXXX9012.

Apparently this is my code strMasked = right(dtExcelValue.Rows(intRowCounter).Item(“Settlement Account No.”).ToString.Replace(“strMasked”,“X”),4)

but the output I’m getting is only 9012. I want the output to be XXXXXXXX9012

Thank you.

[Rahul_Unnikrishnan]

Hello @Greggy

You need to use padleft to add x to the value.

strMasked = right(dtExcelValue.Rows(intRowCounter).Item(“Settlement Account No.”).ToString.Replace(“strMasked”,“X”),4)

strMasked=strMasked.padleft(12,“X”)

Add dynamic number of leading zeros to string

Hi, I have a number of IDs that can be various lengths however, I need to add 0s at the start of the ID so that the final length is 14 digits long. For example: 1234 would need to be 00000000001234 456789 would need to be 00000000456789 Is there a simple way to do this? The theory in my head was to get the length of the initial string given. If its less than 14, add another zero at the start, then check again… but that seems a bit clunky. Is there a nicer way to do this? Thanks

Thanks

[ppr (Peter Preuss)]

Strings.Right(dtExcelValue.Rows(intRowCounter).Item("Settlement Account No.").ToString,4).PadLeft(12,"X"c)

[Greggy (Greggy O)]

Thank you so much @ppr for your help, how about if the first few characters are dynamic? like what if the first row has 16 digits while the second row has only 12 and I want the last four to be shown while the first few characters will be replaced by ‘X’?

[Greggy (Greggy O)]

Thanks @Rahul_Unnikrishnan for your help!

[Gokul001 (Gokul Balaji)]

HI @Greggy

How about this expression?

Strings.Right("123456789",4).PadLeft(CInt("123456789").ToString.count,"X"c)

Regards
Gokul

[Gokul001 (Gokul Balaji)]

If you don’t have any queries, Kindly close this topic by mark as solved @Greggy

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Regards
Gokul

[ppr (Peter Preuss)]

@Greggy

Thank you so much @ppr for your help, how about if the first few characters are dynamic? like what if the first row has 16 digits while the second row has only 12 and I want the last four to be shown while the first few characters will be replaced by ‘X’?

as also mentioned, then we make use of the string length from the origin value

strOld = dtExcelValue.Rows(intRowCounter).Item("Settlement Account No.").ToString.Trim
strNew = Strings.Right(strOld ,4).PadLeft(strOld.Length,"X"c)