Extract only selected data

Help
1

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
2

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

3

still it took whole row from Detail

4

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

Cheers @sayli

5

@sayli

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

out_value.Substring(out_value.Indexof(row(1).ToString.Trim)+row(1).ToString.Trim.Length)

6

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

1 Like
7

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

8

Output_Scaned_Img.xlsx (8.7 KB)

1 Like
9

.csv u take any because its just for output.

1 Like
10

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

11

Fine got it now buddy
Five mins pls
Cheers @sayli

12

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

13

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

error
error1024×768 63.8 KB

1 Like
14

Fine one min
let me check
Cheers @sayli

15

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

16

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
17

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

18

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.

19

csv
csv1024×768 62.1 KB

1 Like
20

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