Hi everyone!

I was wondering, is there a way of cycling through a record?

Let me explain why. I have a csv file where the records have over 50 columns in them, don't ask me why, it is what it is. So I need to replace some special characters, being one of them "#". I could use the Replace() function, no problem. But the problem is that the special character appears in almost all of the columns, and in another csv file too, but with a different set of columns.

So, what i'm hoping to achieve is a way to work smarter, by building a logic where I can replace all of those characters without worrying about the amount of columns, and save the results in a temp record list for download.

Hope I could explain myself. TIA.

Hello Moisés, 

Not directly in OutSystems. You would have to create an extension to do that. 

I think it is easier to simply perform the changes in the CSV files prior to upload them, or create logic to make the replacements in the CSV as text, before processing them. 

Hope this helps. 

Cheers 

Hi Eduardo,

The issue with performing the changes before uploading the CSV is that it would be a laborius work.. since the CSVs can have 60000+ records and 50+ columns.

I've found a pair of components looking in the forge, one for OS11 (https://www.outsystems.com/forge/component-overview/484/record-introspect) and another for OS10 (https://www.outsystems.com/forge/component-overview/5391/objecttorecordlist-using-c-reflection). They both act great to cycle records, and allow me to process each record field as individual data.

Now I just need to figure out how to concatenate that processed data and convert that into the corresponding record again. If it is possible.

Thanks