maddy99
(mani)
1
Hi,
My data in Excel Column is in the format " Number(Column Name) - 1-8432633658(Values) " .
And My doubt is if any item has format like " 1-826455836ghdv " .
Alphablets may appear anywhere like “1-rhu34835hv3” .
Then I have to remove that item from my database. So that I can add the items which has only numerical values in the orchestrator queue.
I know that we can use filter data table to filter the required data. But I don’t know exactly what to do there.
Could anyone please help me.
Yoichi
(Yoichi)
2
Hi,
Hope the following expression helps you.
filteredDt = dt.AsEnumerable.Where(Function(r) not System.Text.RegularExpressions.Regex.IsMatch( r("Values").ToString(),"[^\d\-]")).CopyToDataTable
This will filter out row which contains except number and dash in Values column.
Regards,
1 Like
maddy99
(mani)
3
Hi Yoichi,
Thank you for your information…Can you please explain it briefly where to use…
Yoichi
(Yoichi)
4
Hi,
How about the following step?
- Read source data using Read range
- Filter datatable using the above expression
- Write filtered datatable to another sheet.
Regards,
1 Like
maddy99
(mani)
5
Hi Yoichi,
Cheers! It works… Thanks for the help…
1 Like
system
(system)
Closed
6
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.