Extract specific word from a column

Hi

Hope the below steps would help you resolve this

  1. Let’s take you have a datatable named dt

2.now use a ADD DATACOLUMN activity and mention the datatable as dt and the new column name you want

  1. This will add the new column atlast to the right of the datatable

  2. Then use a FOR EACH ROW activity and pass dt as input

  3. Inside the loop use a IF activity and mention the condition like this

CurrentRow(“yourcolumnname”).ToString.ToUpper.Contains(“HOTEL”)

If true it goes to THEN block where we can use a assign activity and add the value you want to that new column

like this
CurrentRow(“new columnname”) = “your value”

Cheers @ravindar.singh

1 Like