Hi,
| Quantity | Rate |
|---|---|
| 100 Qty | 310.37 |
| 50 Qty | 84.93 |
| 4 Qty | 49.97 |
| 17 Qty | 13.5 |
i have excel like this i want to remove Qty from Quantity Column. i need only number like below for your referance. give me solution screen shot.
| Quantity | Rate |
|---|---|
| 100 | 310.37 |
| 50 | 84.93 |
| 4 | 49.97 |
| 17 | 13.5 |
Thank you
Use this LINQ in invoke code like this
dtInput.AsEnumerable().ToList().ForEach(Sub(row)
row("Quantity") = row("Quantity").ToString.Replace("Qty", "").Trim
End Sub)
Hi @MD_Farhan1
Use this workflow
System.Text.RegularExpressions.Regex.Match((CurrentRow("Quantity").ToString), "\d+").Value
Hope this helps!
after invoke code again i want to process write activity?
If you want the data in and excel file then yes, use Write range activity and pass dtInput to it.
You can use For Each Row in Datatable activity and inside Assign Activity
CurrentRow(“Quantity”) = Cint(CurrentRow(“Quantity”).ToString.Replace(“Qty”, “”).Trim)
Then you might use “Write Range” activity to write it to excel file
Thank you for your Effort 
