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 ?
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...
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 ?
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.