Datatable extraction

I want to extract the data from the data table in row one and two

I want to print 2023.12.28 not 생산관리

Hi @wjdehdnr456

You can use regular expression for it to get the required text.

- Assign -> Currentrow("Column name") = System.text.regularexpressions.Regex.match(Currentrow("Column name"),"[\d.]+").Value

image

Check the below workflow for better understanding,

Hope it helps!!


Is this how you do it?

After extract datatable activity use the for each row in datatable activity to iterate the values in the datatable.
Inside for each insert the assign activity and provide the below expression.

- Assign -> Currentrow("Column name") = System.text.regularexpressions.Regex.match(Currentrow("Column name"),"[\d.]+").Value

Hope you understand!!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.