Answered

Getting substring out of a string in PowerAutomate to find a digit/number

(0) Share

Report

Posted on by benny_blanco

Hi all,

Had a similar question before, but now there's a new requirement. I'm building this Flow that needs to rename a created document before it gets moved to a folder. Couldn't find what I'm looking for in here, so posting a new topic for it. I'm trying to get everything before the number of the document. For example, out of the string 'BugsBunny-Arn-999999-67378-CLMPDVVD-TB-GN.docx', I'm trying to make it to be only '999999-67378-CLMPDVVD-TB-GN.docx', need to make it look for a number/digit, remove everything before it and leave the name with what's left out of the string. What is the correct expression that will work? Have in mind that'd be a dynamic value, so I'm basically taking the Name of the file first and then need to convert it to have only what is after the first digit/number, with the first digit included of course. Thank you!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
join(skip(split(outputs('fileName'),'-'),2),'-')

Was this reply helpful? Yes No
benny_blanco 68 on at

Like (0)

Report
Copy link

Link copied!

Hi @Paulie78 ,

Is this going to look for a number within the string and remove everything before it, or is it going to remove everything after the second "-" character? As I need it to look for a digit/number and to remove everything before it. The digits might start and be after the second "-" character, they might be after the third, fourth etc., it needs to look for the first digit within a dynamic string/name value and remove everything before it. Thank you!

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

Everything after the second - character.

Was this reply helpful? Yes No
benny_blanco 68 on at

Like (0)

Report
Copy link

Link copied!

This wouldn't work in this case, as the digits might start after the third, fourth character etc. Need it to find the first digit in the string and remove everything before it, any idea how to achieve that? Thank you!

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
Much more difficult and messy, but you can do it like this:
https://ibb.co/w4cfJD7
The expression in IsItLess is:
if ( equals(outputs('NumberPositionInFileName'), -1), variables('numberPos'), if ( less(outputs('NumberPositionInFileName'), variables('numberPos')), outputs('NumberPositionInFileName'), variables('numberPos') ) )

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

That screenshot isn't clear. Use this one:
https://ibb.co/pfZbznB

Was this reply helpful? Yes No
benny_blanco 68 on at

Like (0)

Report
Copy link

Link copied!

Thank you! Will give it a try and let you know.

Was this reply helpful? Yes No