Answered

Reducing number of characters and inserting dashes at specific points

(0) Share

Report

Posted on by Dudditz

467

Hello there, I am hoping someone might have some guidance on this one as its using some concepts I have yet to use in flow and do not have a lot of time to research this one. The values listed below are being returned from a Dynamics Entity.

This is the original value returned. Dynamic Characters_F4049210D54EEB11A813000D3A36886F

I need to remove all characters starting with the _ and everything to the left. The dynamic characters is a place holder indicating the name varies in size and length to the left of the _

The next step is to insert the - character at the specific points to reconstruct the GUID.

The end result would be f4049210-d54e-eb11-a813-000d3a36886f

Any direction on this one would be greatly appreciated!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

coyote_ptm 56 on at

Like (1)

Report
Copy link

Link copied!

Hi @Dudditz ,

A few steps.
Initialize second temp variable to store intermediate value.

Value = substring( variables('test'), lastIndexOf( variables('test'), '_' ) )
// this will get string from the LAST underscore to the right.

Then another set variable:
toLower( concat( substring(variables('tmpTest'), 1, 8 ), '-',
                 substring(variables('tmpTest'), 9, 4 ), '-' ,
                 substring(variables('tmpTest'), 13, 4 ), '-' ,
                 substring(variables('tmpTest'), 17, 4 ), '-' ,
                 substring(variables('tmpTest'), 21  )
               )
       )

Was this reply helpful? Yes No
Dudditz 467 on at

Like (0)

Report
Copy link

Link copied!

Amazing! Worked perfect and will be a good reference for future solutions. Thank you so much for your help.

Was this reply helpful? Yes No