topic RE: Edit Value in Collection by Index in Blue Prism in Digital Exchange

Edit Value in Collection by Index in Blue Prism

Digital_WorkerB — Mon, 05 Aug 2019 14:30:00 GMT

If I have a collection named CollectionLabels and the content is below

UI Value Label  |Backend ->Fields
Label1          |Backend1
Label2          |Backend2
Label3          |Backend3

How can I edit the 'Label2' to 'Label2_New' by index?

I really want to avoid using the Loop Stage since it's really slow. Is there a way like:

CollectionLabels.UI Value Label (2) = 'Label2_New'

I would really appreciate a fast moving code here.

--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by ac_98521.

RE: Edit Value in Collection by Index in Blue Prism

AmiBarrett — Mon, 05 Aug 2019 14:36:00 GMT

This C# stage assumes that the index you're updating is always of type Text. Should be fairly easy to make modifications to accommodate other data types.

Inputs:
Collection - Collection
Row - Number
Column - Number
newVal - Text

Outputs:
Modified Collection - Collection

Collection.Rows[Convert.ToInt32(Row)][Convert.ToInt32(Column)]=newVal;
Modified_Collection=Collection;

------------------------------
Ami Barrett
Lead RPA Software Developer
Solai & Cameron
America/Chicago
------------------------------

RE: Edit Value in Collection by Index in Blue Prism

EduardoGS_Carva — Tue, 18 Aug 2020 19:41:00 GMT

Is there a similar code in VBS, please?
Thanks!

------------------------------
Eduardo Gomes Serradela de Carvalho
------------------------------

RE: Edit Value in Collection by Index in Blue Prism

AmiBarrett — Tue, 18 Aug 2020 20:29:00 GMT

Should look something like this, @EduardoGS_Carva

Collection.Rows(Convert.ToInt32(Row))(Convert.ToInt32(Column)) = newVal
Modified_Collection = Collection

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Plano, TX
------------------------------

RE: Edit Value in Collection by Index in Blue Prism

EduardoGS_Carva — Tue, 18 Aug 2020 20:47:00 GMT

Thanks, Ami, it worked perfectly!

Would there be a simple way to refer to Column by it's Name?
And Row by its Column=1 value (first one)?

Example: I want to change "val4" value, from fourth Row=XYZ and second Column=def, without calling them by Row=4 and Column=2, but by their names, is that possible?

Thanks a lot, other pictures show previous answer worked in VBS Code Stage!

column1 = abc	def	ghi	jkl
opk	val1	val5	val9
rst	val2	val6	val10
uvx	val3	val7	val11
xyz	val4	val8	val12

------------------------------
Eduardo
------------------------------

RE: Edit Value in Collection by Index in Blue Prism

AmiBarrett — Tue, 18 Aug 2020 21:22:00 GMT

If you change the 'Column' input from Number to Text, this should work:

Collection.Rows(Convert.ToInt32(Row))(Column) = newVal
Modified_Collection = Collection

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Plano, TX
------------------------------

RE: Edit Value in Collection by Index in Blue Prism

EduardoGS_Carva — Thu, 20 Aug 2020 10:52:00 GMT

Thank you a lot, Ami, I was able to use it to do what I needed!

------------------------------
Eduardo
------------------------------