Extract only selected data

hello guys,
here i want some related number from column “Details” which no i want is shown in “Output” column.
i tried System.Text.RegularExpressions.Regex.Replace(row(1).ToString,"\D","").TrimStart("0"C)
but it take all the numbers i want selcted no like in Output column.
here share u my excelOutput_Scaned_Img.xlsx (8.8 KB)

1 Like

hi @sayli
kindly follow the below steps that could help you get this resolved

  1. use excel application scope and pass the excel file path as input
  2. use read range activity and get the output from this activity with the variable of type datatable
  3. use a for each row loop and pass the above obtained variable as input
  4. use two assign activity and mention like
    out_value = row(0).ToString
    Finalvalue = out_value.Substring(out_value.Indexof(row(1).ToString.Trim),row(1).ToString.Length)

where boh out_value and Finalvalue is a variable of type string
–now you can use his Finalvalue where you want to

Kindly try this and let know buddy
Cheers @sayli

still it took whole row from Detail

can i have a screenshot of your assign activity with the above expression if possible

Cheers @sayli


Just change @Palaniyappan solution to like this and then try.


share u my .xaml test1.xaml (14.5 KB)

1 Like

Can i have a sample of your excel file as well. if possible that could help us go in full swing to solve this issue buddy
Cheers @sayli

Output_Scaned_Img.xlsx (8.7 KB)

1 Like

.csv u take any because its just for output.

1 Like

Fine , but you have created a datatable may i know what data to enter there in it
cheers @sayli

Fine got it now buddy
Five mins pls
Cheers @sayli

here you go buddy
uj.zip (9.6 KB)

Hope its resolved now kindly have a view on the output pane as i have used write line to print the output as well, and we are getting the cheque no alone and its getting entered in CSV file as well
Cheers @sayli

thanks fa giving time yar,but did you observe on 5th row it should be empty because there is no number in “GROUP PREMIUM REM-11042019” ,it took date as no which is wrong it need to empty

1 Like

Fine one min
let me check
Cheers @sayli

fine its resolved now
uj.zip (16.9 KB)
Cheers @sayli

ohhh just i open your excel…@Palaniyappan you haven’t took my Excel you applied logic on “Output” column it need to be on “Details” columns
for an example i create “Output” column
Output_Scaned_Img.xlsx (8.7 KB) this is my excel which i share

1 Like

what value to get from the first column buddy @sayli
image @sayli

like in output column
see give u ex:
in Details we have info like "DHAOWDA/6067717517/1646-K R PETE
so i want only selected no,so output in uj.csv in checq_no is like 6067717517.

1 Like

But there is no output column in the excel given buddy
Cheers @sayli