Substring not by character count

Questions & Suggestions
1

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:

String:
12345421GAH12764318643

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!

2

Hey Josh,

That's easily done with a regular expression.

-Chris

Substring Search with Regular Expression.kmmacros (4.2 KB)

3

Thanks! Much appreciated. I am such a noob.

1 Like