strange issue with substring function - need help please

(0) Share

Report

Posted on by andreasgraf

Hi there

I encounter a strange issue with my cloud workflow. Basically it does the following:

- extract information from a PDF with AI-builder (in this case an amount in EUR) e.g 132.78 EUR

- find the text position EUR

- use substring function with starting index 0 to return only the numeric value e.g 132.78

- write the value e.g 132.78 into an excel-file

the flow worked fine for a couple of weeks and suddenly I get the following error:

I dont understand where the issue is coming from, the starting position is 0 AND despite of the error, the value is still being written into my Excel-file which shows that it still works somehow.

how could I fix the issue? is there another way to extract just the numeric value without the subsequent characters, e.g EUR ?

all the best

Andrew

all the best

Andrew

All responses (2)

Answers (1)

andreasgraf 14 on at

Like (0)

Report

Re: strange issue with substring function - need help please

many thanks! that did the trick, you made my day 😉
Verified answer

Nived_Nambiar 17,739 Super User 2025 Season 1 on at

Like (1)

Report

Re: strange issue with substring function - need help please

Hi @andreasgraf

I could see the error part is having text value as empty while finding text position

May be the value entered in excel would be the next iteration ?

could you check the loop iterations?

To resolve this error, may be you can use the condition after find text position with condition as text position output is not equals -1