topic Re: Code for replacing character in column values in a collection in Product Forum

Code for replacing character in column values in a collection

KarinaHansen — Mon, 08 Feb 2021 10:29:32 GMT

Hi

Can anyone provide a code (C#), or give advise on, how to replace dot with comma (or other characters) for an entire column in a collection. I need to be able to define which column and I want to avoid looping.

Thank you!

Re: Code for replacing character in column values in a collection

NicholasZejdlik — Mon, 08 Feb 2021 18:22:51 GMT

There should be an action in the stock Collection Manipulation object for Remove Dots From Headers that should help.

In case you don't have it, this is the VB code:

For Each Column As DataColumn In Input_Collection.Columns
   Column.ColumnName=Microsoft.Visualbasic.Replace(Column.ColumnName,".","")
Next
Output_Collection = Input_Collection

And the C# version of it:

foreach (DataColumn col in Input_Collection.Columns) {
	col.ColumnName = col.ColumnName.Replace(".", "");
}
Output_Collection = Input_Collection;

Re: Code for replacing character in column values in a collection

KarinaHansen — Tue, 09 Feb 2021 08:18:28 GMT

Thanks for your reply.
This code seems to be replacing dots in the collection field names. What I meant was the column values - Sorry if this was unclear 🙂

Re: Code for replacing character in column values in a collection

NickLeGuerrier — Tue, 09 Feb 2021 14:01:45 GMT

Hi Karina,

Since you mentioned you want to be able to modify all rows for one specific column, this code should work.

foreach(DataRow row in inputCollection.Rows)
{
row[columnName] = row[columnName].ToString().Replace(".",",");
}

outputCollection = inputCollection;

Re: Code for replacing character in column values in a collection

KarinaHansen — Tue, 09 Feb 2021 14:37:39 GMT

Thanks Nick,
I see that you replied in the other thread as well 😄

I get this error when I try to define columnName as input and run it:

Internal : Could not execute code stage because exception thrown by code stage: Unable to cast object of type 'System.Data.DataColumn' to type 'System.Data.DataRow'.

Re: Code for replacing character in column values in a collection

KarinaHansen — Tue, 09 Feb 2021 14:48:18 GMT

It works now - There was a mistake in line 1.

Had it saying:

foreach(DataRow row in inputCollection.Columns)

instead of:

foreach(DataRow row in inputCollection.Rows)

Thank you very much 🙂 🙂