How to get the only id

[Shiv_Kumar]

You can also exclude certain fields, so this would be equivalent:

db.mycollection.find({}, {“items”: 0});

You can exclude _id field by doing:

db.mycollection.find({}, {“user_id”: 1, “_id”: 0});

To know more about this visit at : MS SQL Programming

[jiejie (Call Me JJ)]

Thanks all for reply! i will try it !

[Alex2 (Alexander Daanen)]

Hi!
First: Get the text
Run a Get-Text Activity (choose the part of text needed) and assign the content to any variable you want.

Second: Split the text
Split the text by using the String variable from step1 and assigning its results to a new array variable like this:
…
StringArrayStep2 = StringVariableStep1.split(","c)
…
Third: Geht the ID
Step 2 will give you an array and you can access the ID like
…
ID=StringArrayStep2(0)
…

That should solve your issue and once you get used to it you can put these steps together into one, but thats advanced.

However, UiPath already offers a Split Text activity you can use as well:

Please let me know if this was helpful!

Best
Alex