Split Text By Space

AdamAziz

New Member
Hello,

I am pulling data from a table, but need to separate the words by the spaces and store them in separate data elements. For example, I am pulling the persons name JOHN SMITH. I need to input JOHN in one location, and SMITH in another. Therefore, I need to split and save the words individually. I see a lot of responses in other posts with respect to Utility - String but I don't seem to have that Business Object in BP.

Other data that I am pulling includes an address, which needs to be parsed by house number and street name as well. Example, 123 Main street needs to be separated to 123, and Main street individually.

Thank you,
 

Amarender

Member
Hello,

I am pulling data from a table, but need to separate the words by the spaces and store them in separate data elements. For example, I am pulling the persons name JOHN SMITH. I need to input JOHN in one location, and SMITH in another. Therefore, I need to split and save the words individually. I see a lot of responses in other posts with respect to Utility - String but I don't seem to have that Business Object in BP.

Other data that I am pulling includes an address, which needs to be parsed by house number and street name as well. Example, 123 Main street needs to be separated to 123, and Main street individually.

Thank you,

Hi Adamaziz

Open Blue Prism>Go to File>Import>Browse>local Drive(Where Blue Prism is Installed)>Program Files>Blue Prism Limited>Blue Prism Automate>VBO>BPA Object - Utility - Strings>Open>Next>Finish.
 
Top