Separate text and number

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.

Hi @Sabbir_Anwar

To get Character try with below expression

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

image

To Get Number

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

image

Regards
Gokul

IMG_20220831_202458

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

DEAR Gokul Sir,

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

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

Hi @Sabbir_Anwar

Have a look on the XAML file

SeparateChar&Number.xaml (9.0 KB)

Regards
Gokul

IMG_20220831_202458

Have you Find the Output @Sabbir_Anwar

That is a log of the current transaction

Regards
Gokul

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

Great @Sabbir_Anwar

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

Regards
Gokul

But I did not get the solution


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

Check out the below screenshot @Sabbir_Anwar

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

image


OUTPUT IS EMPTY

Check out the XAML file

SeparateChar&Number.xaml (10.4 KB)

image

Regards
Gokul

1 Like

You are awesome. Thank you for your kind help

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.