Increase number for ID on new row in google sheet

[Tanja_Souza]

What are you trying to achieve?

Take an ID from a google sheet and bump the number up with 1 for my added row. The IDs are of the form “FDS7ASZTB - 109” and I want the serial number to increase with one so my nwe row would have ID “FDS7ASZTB - 110” in this case.

Steps taken so far

I have tried to with text parsers and regular expressions but it is very difficult and I am stuck. Not sure how to use them or if that is the correct way forward.

Screenshots: scenario setup, module configuration, errors

[Adeniji_Philip]

Here’s your solution

[Adeniji_Philip]

Bear with me I’m not currently with my PC.

Pass the ID into the “replace” text parser.

[Adeniji_Philip]

Split the text into an array

[Adeniji_Philip]

Then parse it like this.

This will work!