Separate text and number

[Sabbir_Anwar]

Could anyone please say how can i separate text from number. Example T101054. i want separate “T”. I working on THIS in an excel sheet where i have to separate.

[Gokul001 (Gokul Balaji)]

Hi @Sabbir_Anwar

To get Character try with below expression

System.Text.RegularExpressions.Regex.Match(YourString,"\D+(?=\d+)").Tostring

To Get Number

System.Text.RegularExpressions.Regex.Match(YourString,"\d+").Tostring

Regards
Gokul

[Sabbir_Anwar]

[Gokul001 (Gokul Balaji)]

You need to write it in separate columns in the excel? @Sabbir_Anwar

[Sabbir_Anwar]

DEAR Gokul Sir,

I want to keep only employee ID. and want to remove "T

[Sabbir_Anwar]

When I Apply this whole number with text shift to next column

[Gokul001 (Gokul Balaji)]

Hi @Sabbir_Anwar

Have a look on the XAML file

SeparateChar&Number.xaml (9.0 KB)

Regards
Gokul

[Sabbir_Anwar]

[Sabbir_Anwar]

[Gokul001 (Gokul Balaji)]

Have you Find the Output @Sabbir_Anwar

That is a log of the current transaction

Regards
Gokul

[Sabbir_Anwar]

Yes I have found current transaction. Thank you. Looking for your help

[Gokul001 (Gokul Balaji)]

Great @Sabbir_Anwar

Kindly close the Topic by mark as a solution. It will help other users.

Regards
Gokul

[Sabbir_Anwar]

But I did not get the solution

. I want to separate text. But it shows previous situation as output.

[Gokul001 (Gokul Balaji)]

Check out the below screenshot @Sabbir_Anwar

Remove the Log message CurrentRow("Employee_ID").toString and Replace with NumVal

[Sabbir_Anwar]

OUTPUT IS EMPTY

[Gokul001 (Gokul Balaji)]

Check out the XAML file

SeparateChar&Number.xaml (10.4 KB)

Regards
Gokul

[Sabbir_Anwar]

You are awesome. Thank you for your kind help