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(intRowCo…

HI @Greggy How about this expression? Strings.Right("123456789",4).PadLeft(CInt("123456789").ToString.count,"X"c) [image] Regards Gokul

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

ppr (Peter Preuss) October 18, 2022, 9:18am 3

grafik

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

1 Like

Topic		Replies	Views
Replace first number Studio datatable , excel , activities , studio	5	411	July 11, 2023
Add dynamic number of leading zeros to string Help excel , activities	3	9544	November 4, 2019
If Stringlength is 1 add Help excel , activities , string , question , data_manipulation	7	2141	January 2, 2020
Special Character to replace character Help	4	1206	October 21, 2019
How to take first x characters of string? Help	8	29621	January 23, 2023