How to remove the letter "A" from all values in the data table

How do I remove the letter “A” from all values ​​in the data table?

Are you telling about the whole datatable or column?

@vishal.kp
I want to delete it from the whole datatable.

1 Like

Hi
—use Output datatable activity and pass the datatable as input and get the output with a variable of type string named str_input
—now use a assign activity like this
str_input = str_input.ToString.Replace(“A”,””)

Now again use GENERATE DATATABLE ACTIVITY and pass the string variable as input and get the output variable as datatable

Cheers @tera

2 Likes

@tera

Use Output DataTable activity to convert DataTable into string and then use replace method to replace A.

   outputDTStr.Replace("A","")

Then use Generate DataTable activity to convert String back to DataTable by specifying delimiter as space and write it back to excel using Write Range activity.

1 Like

I was thinking about using LINQ, but this is easier to understand.

Thank you very much.

1 Like

Cheers @tera

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