Unanswered

Creating your own delimited field

(0) Share

Report

Posted on by GreenThrumbo

I currently am trying to compose a field to make my own delimiter but i am stuck as i am unable to add a specific character after each character. Is there a workaround or function that could help me achieve this?

Current Field: A1234567890Z

Objective: |A|1|2|3|4|5|6|7|8|9|0|Z|

I tried splitting but I am sure this is not possible since i cant split by a n empty ('') delimiter

Thank you!

Categories:

Process mining

I have the same question (0)

All responses (2)

Answers (0)

Sort by

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @GreenThrumbo

Try and copy/ paste the code below into New Step -> My ClipBoard here:

{ "id": "123", "brandColor": "#8C3900", "connectionReferences": {}, "connectorDisplayName": "Control", "isTrigger": false, "operationName": "DamoBird365SplitString", "operationDefinition": { "type": "Scope", "actions": { "String": { "type": "Compose", "inputs": "A1234567890Z", "runAfter": {} }, "SelectSplitToArray": { "type": "Select", "inputs": { "from": "@range(0,length(outputs('String')))", "select": "@substring(outputs('String'),item(),1)" }, "runAfter": { "String": [ "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

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @GreenThrumbo

How are you getting on?

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

Was this reply helpful? Yes No