Microsoft Dynamics 365 | Integration, Dataverse...

Dynamics 365 Workflow Tools - String function - Trim String

(0) Share

Report

Posted on by yleclerc

1,545

I am trying to trim (remove) the last 25 characters at the end of a string, using the Dynamics 365 Workflow Tools - String Function.

I understand that I need to use this as a 2nd step:

But how do I specify my trimming in the first place (in the screen below)?

Thanks!

All responses (9)

Answers (0)

MJatAU 10 on at

Like (0)

Report

RE: Dynamics 365 Workflow Tools - String function - Trim String

I would like to remove all spaces from a concatenated address but the Output Parameter 'Without Spaces' is not available. Is there a different way to remove all spaces?
yleclerc 1,545 on at

Like (0)

Report

RE: Dynamics 365 Workflow Tools - String function - Trim String

Oh well, I finally figured it out. It's not perfect, but it works.

1. Isolate the last 25 characters in a sting using Regular Expression.

2. Replace the isolated string by... nothing

3. Use "Replaced Text" when updating the field.
yleclerc 1,545 on at

Like (0)

Report

RE: Dynamics 365 Workflow Tools - String function - Trim String

Yep! I tried this too, but the "Operator" field is greyed out.
erhan.keskin 2,247 on at

Like (0)

Report

RE: Dynamics 365 Workflow Tools - String function - Trim String

Can you check if you can select "Decrement By" operator in that whole number field? If so, try it please.
yleclerc 1,545 on at

Like (0)

Report

RE: Dynamics 365 Workflow Tools - String function - Trim String

I also tried with this regular expression: (.{25}$)

But it keeps the last 25, and I want to remove them :(.
Suggested answer

yleclerc 1,545 on at

Like (0)

Report

RE: Dynamics 365 Workflow Tools - String function - Trim String

Thanks Erhan!

I don't have an exact length for all records, si I need to go with your 2nd suggestion.

It makes a lot of sense! But in the last part, I can't seem to be able to insert a calculation in this field: Substring: Length

Once I insert the Lenght that I got in the first step, I can't type in the field any more (to remove 25 from that length).
yleclerc 1,545 on at

Like (0)

Report

RE: Dynamics 365 Workflow Tools - String function - Trim String

@Bipin - Thank you for taking the time to answer. But this page does not help. The instructions are incomplete, which is why I need some help.
erhan.keskin 2,247 on at

Like (0)

Report
RE: Dynamics 365 Workflow Tools - String function - Trim String

Hi,

I think what you need is SubString rather than Trimmed Text.

This is what you can do;

If you have an exact length of the text from left to right, then you can provide them like;

Substring: From Left to Right = True

Substring: Start Index = 0

Substring: Length = [The Length of the text you want]

Use "SubString Text" from output

If you don't have an exact length of a text from left to right, then you can provide them like;

Use "TextLength" from output to determine the length of your text (Title {note}) first

Then use subtring properties

Substring: From Left to Right = True

Substring: Start Index = 0

Substring: Length = [TextLength from the first step - 25]

Use "Substring Text" from output

Regards,
Bipin D365 28,964 Super User 2024 Season 1 on at

Like (0)

Report

RE: Dynamics 365 Workflow Tools - String function - Trim String

Hi,

Chech below guide to trim text in workflow.

github.com/.../String Functions.md

Please mark my answer verified if i were helpful