Search results

I'm using some read CSV activities, but regardless of the activity, I cannot read the CSV files as they really are, meaning that I have quotes around every value, but the collections inside blue prism don't appear with quotes around values. Is there a way to fix this ?

I currently write collections as CSV files but I saw that there are no quotes around values and I need this. Is there a way to achieve this ?

In the end, I fixed by replacing the symbols when it was the case with calculation stage. Thank you.

Hi, thanks for the reply. Unfortunately, this does not apply for my case. I'm reading a collection from the csv file, and those hidden symbols goes into the naming of the first column. I tried to rename that collumn with an action but unfortunately this does not work. The column will look normal...

Hello, I have a process where I'm reading some .csv files which are encoded in UTF-8-BOM. The problem is that this enconding provides some hidden symbols at the beginning of the text and it interferes with some of my actions of merging collection ( columns headers not matching because of those...

Way more faster than using loops. Cheers !

So let's say, for example, that in my collection with 1000 rows, I have some rows which have the same value in column 2 and in column 4. (column 2 = column 4). When this case appears, the value in column 4 has to be changed to a another, given, value.

Thanks again, Sahil. Do you also have an idea for the case if I have same value in two columns, to change value in one of the two columns? I'm also using loop for this case but a code stage I think would make it way faster.

Hello, I have a collection with around 1000 rows and I need to copy the contents of the, let's say, first three columns, to the last 6 columns. I don't want to use loops because takes a lot of time. Can I use some code stage to do this instead ?

It's working. Thanks a lot!

Thank again for yout help, the code is working but it deletes the last row from every group of duplicate rows, instead of the first row. Tried to change the way of iteration but that just makes it messy. I guess that when you say that the collection has to be sorted, you mean to change the...

Do you have an idea if the loop can be integrated in the Code Stage ?

My bad, code works just fine. Thanks a lot !

I tried to run the code, but it's returning all the rows from the original collection. I got the idea of using the loop, looks like working but the code don't seems to. Will check more and see what has to be changed or what I am doing wrong. Thanks a lot.

Any idea ? I tried but can't reach to the solution I want.

Thank you, Sahil. Your code works brilliant and saves a lot of time. Cheers to you. Just a small notice that the following External References are needed : System.Core.dll & System.Data.DataSetExtensions.dll Now, I'm about to make the problem more challenging, maybe you have also an idea on...

Also, must keep the entire rows after removing the duplicates.

I would but just now I figured out that I was not doing it ok. Instead of removing duplicates based only on one column, my object was removing duplicates based on all columns. Is there a way to remove duplicates but based only on one column ? Without using loops because the collection is big.

Hello, I am working on a process right now on which I have to merge some collections into a single one (with around 1000 rows ) and after that to remove duplicates based on a single column. I already did these steps but I would also need to keep track of which rows were removed from the...