Extract Particular(First) Number From Excel

I have one Excel which Contains data in Column “TRAN_PART” like “0334918574-3072040150000893-9596745321-REN-283-F”
i want only first numbers like 334918574 from first row then 342090726 from second rowtest.xlsx (8.7 KB) this no from above excel.will share my excel


use : row(0).tostring.splt("-"c).first

1 Like

For reference : Main.xaml (5.8 KB)

1 Like

how to remove first zero from it


Hi @sayli
Please Refer the workflow it will will help you i have used Substring. it extracts the value from first Index.ExtractString.xaml (5.1 KB)

1 Like

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