Extracting string from a field in collection

[ArdraM]

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 ?

[Soumya21]

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
​

[Tejaskumar_Darji]

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.

[ArdraM]

@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​​

[MichealCharron]

@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.​​