topic Re: Extracting string from a field in collection in Product Forum

Extracting string from a field in collection

ArdraM — Mon, 21 Nov 2022 06:00:10 GMT

Currently, my collection has a field that looks like this: SERVER\Download\Imp\US12345_GL. how can I extract US12345_GL alone to a new field in the same collection ?

Re: Extracting string from a field in collection

Soumya21 — Mon, 21 Nov 2022 07:07:30 GMT

Hi @Ardra M

You Can use Get collection Fields action to take fields after that Loop through Fields and take the field name which u have mentioned and use Right or Left functions to extract string, then you will be having extracted string in one data item so by that name u can create field in collection.

Thanks,
Soumya

Re: Extracting string from a field in collection

Tejaskumar_Darji — Mon, 21 Nov 2022 09:55:44 GMT

If your file name is always going to be 10 alphabets then you can use - Right("SERVER\Download\Imp\US12345_GL",10)

If that is dynamic below is a better approach. I'm Attaching the required snaps for you to configure and try.

Let us know how it goes for you and if you need more help.

Thank you for using the Blue prism community.

Re: Extracting string from a field in collection

ArdraM — Mon, 21 Nov 2022 10:16:54 GMT

@Soumya21 and @Tejaskumar_Darji : Thank you very much for the response. Unfortunately, string length varies so can't use right, and left functions. I've implemented the code to reverse the string along with the instr function to get the desired result. Thanks again

Re: Extracting string from a field in collection

MichealCharron — Mon, 21 Nov 2022 13:56:50 GMT

@Ardra M

You can also use the "Split Path" action in Blue Prism's "Utility - File Management" VBO. The "File Name" output parameter will give you the value after the last backslash.