How to add a symbol every few characters in a query?

[Urya]

I'm hoping to make a workflow that turns a query that looks like '12345678' into '1234-5678', adding a line break every four characters in a query. I'm guessing this can be done in regex, but I'm not too familiar with how to do that. Would anyone be able to help me figure it out?

 

Thanks!

[vitor]

Welcome @Urya,

 

Indeed you can do it with a regex. Use the Replace Utility to replace (.{4}(?!$)) with $1-. It might look complicated, but the heart of it is the (.{4}) which means “capture four characters in a row”. The cryptic (?!$) adds to that, saying “except if they’re right at the end”. This is to avoid 12345678 becoming 1234-5678-.

[Urya]

Thanks so much, @vitor, that works perfectly!