Extract Particular(First) Number From Excel

Help
1

Hi,
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

2

@sayli

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

1 Like
3

For reference : Main.xaml (5.8 KB)

1 Like
4

how to remove first zero from it

5

row(0).tostring.splt("-"c).first.substring(1)

6

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
7

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