Dear all.
new to UiPath, i have this big project, where i need to match the values from columns.
The files are CSV and XLSX.
the CSV file column has more values and i only wan’t to fetch one specific word from it.
as you can see i use for each row to loop trough all my DT to match
and a match to fetch the specific word.
i wan’t it to tell me if there is a match or not, but i can’t seem to get it correct. my regex in the match look like this \bKSD-\d{4}-\d{12}\b
@Christina_Ilkjaer_Peterse
Welcome to the forums
there are few other options (maybe with a more compact modelling result) but as you have mentioned:
we will stick to your started modelling
We assume that you want to compare/check column values and would expect more a condition like
myLoopRowVar(“ColumnName”).toString.Trim.Equals(myRegexMatchedValue)
feel free to share with us sample data and/or your xaml and we can assist more specific
i can’t share my xaml file, because is a work thing.
But let us say that i have to compare column C, in the column there is a lot of tekst, but i only need a specific word from it, to compare with the other column that only has the specific word in it.
to see if it is there or not.
@Christina_Ilkjaer_Peterse
unfortunately we cannot derive the needed details
have a look at such flow
myMatch = System.Text.RegularExpressions.Regex.Match(row1("ColName").toString, "\bKSD-\d{4}-\d{12}\b" )
just take it as a little starter help and remodel your implementation
fine, still you could share sample data along with expected output sample
Hello Christina
Please take a look at this previous post, perhaps it will help you:
Regards
Soren
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
