if you want to perform this operation in excel itself use the below sample formula.
=TRIM(LEFT(A2,SEARCH(“-”,A2,1)-1))
A2 should be your number eg: 123456-1234
you could use write cell activity to write this formula in starting of the cell and after that use auto fill to fill the data of the entire column. if you have any doubts please let us know. thanks.
All right i try, and then i let you know.
Another question, how do i trim my entry sheet in excel, i can see i have the space in every cell, and i want to remove that.
take one foreach row in data table
3.Take one assign activity and write like this Variable(Name)=CurrentRow(“ColumnName”).ToString.Trim
4.take one more assign Name=name.Split(“-”,c)(0).trim
Error ERROR Validation Error Compiler error(s) encountered processing expression “”=TRIM(LEFT(G2,SEARCH(“-”,G2,1)-1))“”.
Option Strict On disallows implicit conversions from ‘String’ to ‘Double’.
Option Strict On disallows implicit conversions from ‘String’ to ‘Double’.