Split Text / URL in Dynamics CRM

(0) Share

Report

Posted on by Leon Podiev

Hello together,

we are working the Visit-Entity from ClickDimensions. From every page we receive a URL which contain specific campaign Code in it. With this Code we want to connect the visit to the campaign for reporting reasons. Now we want to create a workflow which is able to split / separate last 16 characters from the URL, look after campaign with the Code and assign it to the visit. This should happen by creating a new visit.

Is there any function how can we separate last 16 characters from the URL?

7367.URL.png

Thank you in advance

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (3)

Leon Podiev 50 on at

Like (0)

Report

RE: Split Text / URL in Dynamics CRM

Thank you so much Ryan!

Was this reply helpful? Yes No
Verified answer

Ryan Maclean 3,070 on at

Like (0)

Report

RE: Split Text / URL in Dynamics CRM

Hi Leon,

You could use something like:

[A-Z]{3}-[A-Z0-9]{5}-[A-Z0-9]{6}

This looks for 3 capital letters, then 5 alphanumeric characters, then 6 alphanumeric characters, each separated by a hyphen

Was this reply helpful? Yes No
Leon Podiev 50 on at

Like (0)

Report

RE: Split Text / URL in Dynamics CRM

Hello Ryan, thank you for you Suggestion. How should the pattern look like in my case? CMP-XXX-XXXX?

Was this reply helpful? Yes No
Leon Podiev 50 on at

Like (0)

Report

RE: Split Text / URL in Dynamics CRM

Thank you for this two possibilities. I’ll have a look which one is better for our Environment.

Was this reply helpful? Yes No
Verified answer

Ryan Maclean 3,070 on at

Like (0)

Report

RE: Split Text / URL in Dynamics CRM

Hi Leon,

You could try using the RegEx Extract function from Jason Lattimer's String Workflow Utilities solution: github.com/.../releases

This would allow you to extract the string you're looking for.

I have used this in my environment to extract an error code from an error message, see below:

Was this reply helpful? Yes No
Verified answer

Radu Chiribelea 6,667 on at

Like (0)

Report

RE: Split Text / URL in Dynamics CRM

Hi Leon,

You could create a custom workflow activity and move the logic there.

Then, add the workflow activity as a step to your workflow.

Hope this helps!

Radu

Was this reply helpful? Yes No