Simple split of a text with no space and no character

[william.coulson (Will Coulson)]

Hey @Latif,

See if this post helps you:

Split Multiple Rows with no spaces to get Specific Data

Hello, I am currently developing a process which requires me to pull data from a banking website, and then add this data to an array, to later be added to a spreadsheet. I am using a Get Full Text activity to get the items, and I only want two items; Ordered By, and Payment Details. I cannot figure out how to split the data as there are no spaces between the title and the required data. An example will be below. Items needed are in bold. Amount Credited GBP 567,000.00 Value date16-DEC-2019 B…