How can I split the letter and the number in the text?

[heyium]

How can I split the letter and the number in the text?
Forexample:
T23-> variable1: T variable2:23
AB02->variable1: AB variable2:02

[THIRU_NANI (NaNi)]

Hey Try this!

For Text:

strText = System.Text.RegularExpressions.RegEx.Match(Variable1,"[A-Za-z]{0,}").ToString.Trim

Reference:

regex101: build, test, and debug regex

For Number:

strNumber = System.Text.RegularExpressions.RegEx.Match(Variable1,"[0-9]{0,}").ToString.Trim

Reference:

regex101: build, test, and debug regex

Regards,
NaNi

[Gokul001 (Gokul Balaji)]

HI @heyium

You can try with Regex expression

 System.Text.ReguarExpressions.RegEx.Match(YourString,"[A-Za-z]*").ToString.Trim

Output -> T or AB

 System.Text.ReguarExpressions.RegEx.Match(YourString,"\d.*").ToString.Trim

Output -> 23 or 02

Regards
Gokul

[Yoichi]

HI,

FYI, another solution:

m = System.Text.RegularExpressions.Regex.Match(yourString,"(?<LETTER>[A-Za-z]+)(?<NUMBER>\d+)")

Then

variable1 = m.Groups("LETTER").Value
variable2 = m.Groups("NUMBER").Value

Note: m is Match class

Sample20221117-6-2net.zip (5.3 KB)

Regards,

[heyium]

Then I want to increase the number value by 1 but I couldn’t.

[Gokul001 (Gokul Balaji)]

I thinks so this is a new query right? @heyium

Check out this thread

How to increment count inside a for each row

Hey Guys I have tricky question. But to ask it, I have to explain my process. So sorry for the long message. But basically I have a process made that reads a excel and outputs a datatable. I then use a for each row to cycle through all the rows in the data table and carry out tasks based on names in the spreadsheet. Inside the for each row, I use workflows to navigate to the different applications. So when I get the main process workflow I want to increment A counter each time it hits this wor…

For this can you create the new topic and close this topic by mark as solved.

Regards
Gokul