Substring takes 0 as StartIndex, but doesnt take more than 0 as StartIndex

(0) Share

Report

Posted on by Community Power Pla...

Hey Team,

I want to remove the first 29 characters of the email and save it in the sharepoint folder as new emails come in.

When I try to use Substring, it throws me this error.

Unable to process template language expressions in action 'Remove_Pretext' inputs at line '1' and column '23468': 'The template language function 'substring' parameters are out of range: 'start index' and 'length' must be non-negative integers and their sum must be no larger than the length of the string. Please see https://aka.ms/logicexpressions#substring for usage details.'.

This is my substring function

substring(variables('Filename'),29,length(variables('Filename')))

It works with 0 as the StartString, but not > 0.

Works fine until removing the pretext part where there is the substring function.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Anonymous

If you need first 29 characters use below

:

substring(variables('Filename'),0,28)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey @Mira_Ghaly ,

I need to remove the first 29 Characters. "Rpt1000000528_20210103230011"_FILENAME.xlsx

substring(variables('Filename'),0,length(variables('Filename'))) - This works

substring(variables('Filename'),29,length(variables('Filename'))) - This doesnt work

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Anonymous

Yeah I got you wrong please use

substring(variables('Filename'),29,length(variables('Filename'))-1)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Mira_Ghaly
I tried that as well.

substring(variables('Filename'),29,sub(length(variables('Filename')),1))

Tried subtracting the filename length by 1. I think the final index is correct, because it works with 0 to the (length of file -1), doesnt work if the index is set greater than 0.

I also have a condition if the filename ends with ".xlsx" to make sure that there is a filename

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@Anonymous

I got the issue:

This worked for me

substring(variables('FileName'),28,sub(length(variables('FileName')),28))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you! 🙂 This worked!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Getting error - The 'start index' for function 'substring' must be equal to or greater than zero and must be less than '0' which is the length of the string.
On split(substring(variables('BidderString'),0,outputs('Compose')),',')
Please help

Was this reply helpful? Yes No