topic RE: Trim And Rename Collection Field Names in Product Forum

Trim And Rename Collection Field Names

vinodchinthakin — Fri, 28 Oct 2022 07:15:00 GMT

Hi All.

I have a collection with 20 columns. I want to rename all of them with same names in Upper or Lower case and also want to trim the field names using a code stage.

can anyone have a solution?

------------------------------
vinod chinthakindi
------------------------------

RE: Trim And Rename Collection Field Names

Carl__Carter — Fri, 28 Oct 2022 08:07:00 GMT

Hi Vinod,

You could get a list of the current column names using the 'Get Collection Fields' action. You could then Loop the collection, formatting the values to meet your requirement. Then, call the 'Rename Collection Fields' action passing the data Collection and the Collection containing the formatted column names to the action.

------------------------------
Carl Carter
Senior Developer
Blue Prism
Europe/London
------------------------------

RE: Trim And Rename Collection Field Names

RonanConsidine — Tue, 15 Nov 2022 17:18:00 GMT

Hi Vinod,

As Carl says, this is the easiest option, you can use the following functions in a calculation stage within a loop to do this such as

Trim(Lower([collection.Name]))

Trim(Upper([collection.Name]))

------------------------------
Ronan Considine
Senior Business Analyst
Blue Prism
------------------------------

RE: Trim And Rename Collection Field Names

vinodchinthakin — Wed, 16 Nov 2022 10:03:00 GMT

Hi @Carl__Carter @Ronan Considine. This logic seems time consuming for me. I couldn't able to achieve it properly.

If possible could pls try it in your blue prism and share screenshots of process action steps . Want to look how its achieved.

Instead of Loops, Do we have any code stage for this?

------------------------------
vinod chinthakindi
------------------------------

RE: Trim And Rename Collection Field Names

vinodchinthakin — Wed, 16 Nov 2022 14:20:00 GMT

Hello,

I just figured out the code. Following code helps me to achieve my requirement. I just tweaked Rename Field Action code.

Collection_Out = Collection_In.Copy

For Each c As DataColumn in Collection_Out.Columns

c.ColumnName = Trim(c.ColumnName).ToUpper

Exit For

Next

------------------------------
vinod chinthakindi
------------------------------

RE: Trim And Rename Collection Field Names

Carl__Carter — Wed, 16 Nov 2022 14:47:00 GMT

Hi Vinod,

When there is a solution which doesn't require custom code, then I would always offer this first unless there was a major performance gain from using a code stage. This is so more of the community can make use of the solution without needing to understand .NET code.

Well done in figuring out the custom code. I can see there is an issue with your code though. Your 'Exit For' command will exit your 'For Loop' after the first column name has been renamed. You should remove the 'Exit For' command unless it is your intention to only rename the first column.

------------------------------
Carl Carter
Senior Developer
Blue Prism
Europe/London
------------------------------

RE: Trim And Rename Collection Field Names

vinodchinthakin — Wed, 16 Nov 2022 15:20:00 GMT

Thanks Carl for the suggestion.
I have updated my code and also included Flags for Trim and Uppercase using If else condition within for loop. Now its working well.

------------------------------
vinod chinthakindi
------------------------------