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)
kindly follow the below steps that could help you get this resolved
- use excel application scope and pass the excel file path as input
- use read range activity and get the output from this activity with the variable of type datatable
- use a for each row loop and pass the above obtained variable as input
- 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
still it took whole row from Detail
can i have a screenshot of your assign activity with the above expression if possible
Just change @Palaniyappan solution to like this and then try.
share u my .xaml test1.xaml (14.5 KB)
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
.csv u take any because its just for output.
Fine , but you have created a datatable may i know what data to enter there in it
Fine got it now buddy
Five mins pls
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
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
Fine one min
let me check
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
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.
But there is no output column in the excel given buddy