Replace last letter of Variable with the next in sequence

(0) Share

Report

Posted on by Skybluekid

262

Hi,

I am curious. I have a variable XXX C0006A. Is it possible to resubmit the variable and change the A to B, XXX C0006B in a flow?

Then Change to a C if required.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Skybluekid

You could use the following expression:

replace(outputs('compose'),last(outputs('compose')),'B')

Hope that helps!

Ferran

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

Hi @fchopo
thank you for the reply. I was thinking more changing the letter dynamically i.e. if the variable contains XXX C0006A, then it would automatically change to XXX C0006B, without any hardcoding.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!
A few questions.

What do you do with XXX C0006Z - what should it change to?

Will the variable always be in the same format? Will it always be the last letter you need to change?

Below is one way to do it.

See full flow below. I'll go into each of the actions. Note that they are all Compose action - I've just renamed them.

The expression I used in the Output is:

concat( substring(outputs('Input'), 0, sub(length(outputs('Input')), 1)), substring(outputs('AZ'), add(indexOf(outputs('AZ'), last(outputs('Input'))), 1), 1) )

Note that in AZ I added A at the end so if the code ends with Z it will be set as A. Not sure what you would want to do in your scenario.

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

Hi @grantjenkins

Thank you for the reply. I would not anticipate that it would get to Z, in the case of the actual flow. I will give this a try.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,525 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
concat( slice('XXX C0006A', 0 , -1), chunk('ABCDEFGHIJKLMNOPQRSTUVWXYZ', 1)[ add(indexOf('ABCDEFGHIJKLMNOPQRSTUVWXYZ', last('XXX C0006A')), 1) ] )

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

Thank you both for the assistance

Was this reply helpful? Yes No