Microsoft Dynamics 365 | Integration, Dataverse...

Dynamics 365 Workflow Tools - String function - Trim String

(0) Share

Report

Posted on by yleclerc

1,549

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!

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Bipin D365 28,985 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Chech below guide to trim text in workflow.

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

Please mark my answer verified if i were helpful

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
yleclerc 1,549 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Suggested answer

yleclerc 1,549 on at

Like (0)

Report
Copy link

Link copied!

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).

Was this reply helpful? Yes No
yleclerc 1,549 on at

Like (0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
yleclerc 1,549 on at

Like (0)

Report
Copy link

Link copied!

Yep! I tried this too, but the "Operator" field is greyed out.

Was this reply helpful? Yes No
yleclerc 1,549 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
MJatAU 10 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No