Unanswered

First 100 character of a string

(0) Share

Report

Posted on by tpitman

I have a variable which I would like to restrict to the first 100 characters. How would I include this as an expression in my flow?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @tpitman,

That would be something like below.

substring('<text>', <startIndex>, <length>)

In your case:

substring(outputs('Compose'), 0, 100)

Below is an example in a Compose

You can also use the substring action instead.

Was this reply helpful? Yes No
tpitman 91 on at

Like (0)

Report

Thank you very Much!!

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (1)

Report
I think this is better:
if(greater(length(outputs('Compose')),100),substring(outputs('Compose'), 0, 100),outputs('Compose'))

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (2)

Report

Hi @VictorIvanidze,

Yes, I totally agree. It is definitely good practice to check if the value actually is greater than 100 characters before using the substring function 👍

I just wanted to start simple, by first explaining the substring function. I assumed this was going to be a follow-up question after my first reply and I would have explained the length and greater functions than. I was aiming for the step-by-step explanation approach 😁

Was this reply helpful? Yes No
tpitman 91 on at

Like (1)

Report

Thank you both.

The text is ALWAYS going to be > 100 so it should be fine 🙂

Was this reply helpful? Yes No
tpitman 91 on at

Like (1)

Report

out of interest, if I wanted to extract a string with characters 5-8, would it be as simple as "Starting position" 5, length 3
Using the substring action of course

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Try it!

Was this reply helpful? Yes No
tpitman 91 on at

Like (1)

Report

Yep! that works!! 🙂

Was this reply helpful? Yes No