Hi all, Again I am stuck with some UIpath activity, I read excel data table and I am referring here two columns named “client reference” & “comment”. And my automation requirements as follows;
- The column named “comment” contains some values like “1988411_YM2021-189” and that particular value need to be separate to read as “1988411”(separate from special character “_” and take leading values only) and write on same column (“comment”) .
- Also same column (“comment”) if contains some values that starts from alphabetic characters like “GB2021-378” , “WV21587”, “MG2021-2712” , then those values need to be replaced with values which are in “client reference” same row and write it to “comment” column as well.
I here attached the screen shots which describes the questions I mentioned above. Also attached herewith the excel data table
Hope you understand my question and your kind attention & solution in this regard much appreciated.
Thanks in advance.
Data Table.xlsx (18.2 KB)