Remove particular string from a datatable column

[vishal_nachankar (Visky)]

Hi ,

i hava datatable from which i need to remove 04 value from a particular column how i can achieve it.
Please find the screenshot of the column from which i need to remove 04

[vrdabberu (Varunraj Dabberu)]

Hi @vishal_nachankar

try using the below activity in for each row in excel

Regards

[lrtetala (Lakshman Reddy)]

Hi @vishal_nachankar

Try this

- Assign -> CurrentRow("Name")=CurrentRow("Column").ToString.Replace("04","")

[rlgandu (Rajyalakshmi Gandu)]

Hi,
Take for each row in datatable
take if condition
Currentrow(“YourColumn”).ToString.Contains(“04”)

take assign activity and use replace function to replace the value with empty.

Thank you

[supriya117 (Supriya Allada)]

Hi @vishal_nachankar

1. Read the DataTable as “dt”
2. For each row in “dt”
3. row(“Col_Name”).ToString.Replace(“04”,“”)

[vishal_nachankar (Visky)]

implemented using substring from 2