Substring not by character count

I was searching the forum and found similar Avery's but not exact so I thought id just ask.

Trying to get a Substring but not by character count exactly. For example:


Goal Substring: GAH12764

This issue I am having is the character count between the 1-G and 4-3 are always different so doing it by character count alone won't work. However, the character count of GAH12764 will always be the same. So checking to see if I can get it to search for GAH and it get the 5 digits afterwards or any alternatives. Any help would be great, thanks!

Hey Josh,

That's easily done with a regular expression.


Substring Search with Regular Expression.kmmacros (4.2 KB)

Thanks! Much appreciated. I am such a noob.

1 Like