Hi @Anonymous
This is possible with substring. Your positioning for the latter half of the string seems to be 1 out though. See below. Type 1 is position 50, but you list 51.
This made it a bit more confusing as substring starts from index 0, so i had to subtract 1 from the start position but then spotted Type 1,2,3 and GL were a further 1 char out of position. Or at least when I copied/pasted from above it was.
Here's the flow:
and here is the output array:
The compose with a split is the follow expression:
split(outputs('Compose'),outputs('Compose_With_A_ReturnKey'))
and the values of the select consist of the following:
GL substring(item(),1,8)
Desc trim(substring(item(),12,30)) [note I used trim to remove trailing and ending spaces - you could do this on all if you wanted].
If you copy the code below, you should then be able to create a new flow and paste it into a new step using the myclipboard tab and this will give you an instant Damo, sorry Demo! 😉
{"id":"badc1a27-1b5f-4779-bef2-3621-a153cc88","brandColor":"#8C3900","connectionReferences":{},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"DamoBird365","operationDefinition":{"type":"Scope","actions":{"Compose":{"type":"Compose","inputs":" 100-0000 ASSETS H DR B \n 101-0000 CASH ACCOUNTS C DR B \n 101-0001 OPERATING BANK ACCOUNT D DR B 101-0000 ","runAfter":{}},"Compose_With_A_ReturnKey":{"type":"Compose","inputs":"\n","runAfter":{"Compose":["Succeeded"]}},"Compose_with_a_Split":{"type":"Compose","inputs":"@split(outputs('Compose'), outputs('Compose_With_A_ReturnKey'))","runAfter":{"Compose_With_A_ReturnKey":["Succeeded"]}},"Select":{"type":"Select","inputs":{"from":"@outputs('Compose_with_a_Split')","select":{"GL":"@substring(item(), 1, 8)","Description":"@trim(substring(item(), 12, 30))","Type1":"@substring(item(), 49, 1)","Type2":"@substring(item(), 58, 1)","Type3":"@substring(item(), 70, 1)","GL 2":"@substring(item(), 80, 8)"}},"runAfter":{"Compose_with_a_Split":["Succeeded"]}}},"runAfter":{}}}
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉
