How to take first x characters of string?

Help
1

Hi everyone,

I’ve been looking around the forums, and although I have been able to find topics like how to split string into characters, I was not able to adapt their solutions for my slightly different problem: I don’t want to split when encountering a certain character, rather I want to split on encountering a certain character limit. So I want to be able to break it down into say groups of 50 characters or so, I’ve been trying to figure out how to do it but I’m very new to UIPath and have been unable to find a solution. Any help would be greatly appreciated.

2

Hi.

You can do most things with string manipulation through vb.net in UiPath, so there are various sources out there online to figure out how to do something like this.

One approach would be to use Regex.Matches() to create an array of any character up to certain length

System.Text.RegularExpressions.Regex.Matches("12345678901234567890","(.*){10}").Count.ToString

The above example would split the string by 10 characters using the pattern “(.*){10}”

3

Hi, I need help
I want to take the first 3 letters from a phone number (string variable) in a data table
I know how to get to the right column, the only problem for me is how to take the first 3 chars

thank u

4

Left(variablename,3)

9 Likes
5

thanks
but I found the .substring(0,3)
but good to know there is another option

7 Likes
6

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.

7

Hello @Greggy ,

Please find the attached Xaml file… I have tested.

Logic to repeat N characters with "" - new String(""C,3)

Repeating Characters length = 3
image

image
NewActivity.xaml (8.2 KB)

8

HI @Greggy

How about this expression?

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

Regards
Gokul

9

hey please tell me that how to fetch “(30209x and 309049b)” this type of data also from one sheet excel to another excel sheet.