How to remove the Characters in string?

Hi all,

how can I remove all characters after the dot in a DataTable? For example, I want to convert “” to “MCH-S1-Z89”


Hi @chandrakala.productanalys

If these values are in the one column.
Use for each row in datatable activity to iterate the each row in datatable. Inside for each insert If activity to check the condition.

- If -> Currentrow("Column name").contains(".")

Inside then block insert the assign activity and give the below expression.

Assign -> Currentrow("Column name") = Currentrow("Column name").Split(".").first

Hope it helps!!

Hi @chandrakala.productanalys

row("YourColumnName") = row("YourColumnName").ToString.Split("."c)(0)

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