Deleting a character in a DataTable

Hello,
I have a data table and am trying to remove every “-” contained in the data table. What’s the best way to do this?
Thanks,

1 Like

@Jp02

Use Output DataTable Activity to convert DataTable into string and then replace that hypen with empty value like below.

                    inputDTString.Replace("-","")

And then pass this string to Generate DataTable activity to convert back to DataTable.

4 Likes

@Jp02
Find a starter help here using another approach
Jp02_HyphenCorrector.xaml (7.5 KB)

3 Likes

Thank you. Do I need to put inputDTString.Replace(“-”,“”) in an activity?

@Jp02

Yes, use Assign activity.

1 Like

Thank you. that worked!!

1 Like

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