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.
To get Character try with below expression
To Get Number
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
Have you Find the Output @Sabbir_Anwar
That is a log of the current transaction
Yes I have found current transaction. Thank you. Looking for your help
Kindly close the Topic by mark as a solution. It will help other users.
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
Check out the XAML file
SeparateChar&Number.xaml (10.4 KB)
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.