Explore Courses Blog Tutorials Interview Questions
0 votes
in RPA by (12.7k points)

I am trying to get cell values of a particular column having a Column name which is not fixed after particular words. I need to loop through Datatable and get values from a column having a column name as something like 'Value @02/29/2019'. Here the Date is changing but I want to know whether we can have something like contains or 'Values%'.

I tried regex but no luck.

expected is like: - for each row (Test_DT) - assign row("Value%") to CellValue - end for

1 Answer

0 votes
by (29.5k points)

I am attaching a screenshot of how to do it

enter image description here

inside your ' for each' column use an 'if' activity to check if col contains "Value @"col.ToString.contains("Value @")

Also, you will have to change type arguments of your for each activity otherwise you will get "Option String On Disallows Late Binding" error

enter image description here

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers


108k users

Browse Categories