How to convert "50000016900" to "5.000.00.16900" format

[Donna]

Gummie (and Claude) tell me to do it like this:

But it doesn’t work

If somebody can help, much appriciated

[Gumloop_Bot]

Hey @Donna! If you’re reporting an issue with a flow or an error in a run, please include the run link and make sure it’s shareable so we can take a look.

1. Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={your_run_id}&workbook_id={workbook_id}

2. Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
   

3. Provide details about the issue—more context helps us troubleshoot faster.

You can find your run history here: https://www.gumloop.com/history

[Wasay-Gumloop]

Hey @Donna – You’re super close. You’d need to add backslashed in the Replace With string otherwise it would be taken literally.

Here’s an example: https://www.gumloop.com/pipeline?workbook_id=p2ongVcLWzBedr9emgLZCp&run_id=PrCykavWsj9sbYn7SJ44Kf

Find word: /(\d)(\d{3})(\d{2})(\d{5})/g
This pattern finds an 11-digit number and breaks it into four groups: 1 digit, 3 digits, 2 digits, and 5 digits.

Replace with: \1.\2.\3.\4
This replaces the matched number with the same digits but adds periods between each group.

The \n notation is one of the standard ways to reference these captured groups in replacement strings.

[Donna]

Thanks … but too strange … Have a look at the screenshots:

Link to flow
https://www.gumloop.com/pipeline?workbook_id=8Si3xQZiS4uoBWk2VirQM3&tab=1&run_id=npd7LMjGrChHZbJuWHnSkz

[Wasay-Gumloop]

Your input has 10 digits while the regex supports 11 digits exclusively. Would recommend creating a more flexible regex pattern something like: /^(\d)(\d{3})(\d{2})(\d{4,5})$/

[Donna]

@Wasay-Gumloop

+1