Regex for text between items

Question

I'm having a hard time pulling out just the 1069 value using regex. I think I might be trying to use unsupported features to make it worse.

Q1: Would someone be able to let me know what regex would be needed to pull the numbers the 4th and 5th colons (value of 1069)

Q2: How to pull the items after the 6th colon? (value of 2929)

sample text:

diamond:dev:liquid:beta:1069:zone:2929

Can you use a function that splits strings based on a delimiter and returns an array? — Salman A, Oct 29 '20 at 10:00
Split isn't an option in this scenario, I'd need to do a regex. — Ali Razeghi - AWS, Oct 29 '20 at 16:44
Ill have to ask this in a different forum, "What does regex mean" doesn't have anything to do with the current specific question and issue Im listing as a non programmer. Thanks for your input people who mentioned split! — Ali Razeghi - AWS, Oct 29 '20 at 16:46

score -1 · Accepted Answer · answered Oct 29 '20 at 10:05

Answer 1: How to get value between 4th and 5th colons:

(?>[^:]+:){4}([^:]+)

Answer 2: How to get value after the 6th colon:

(?>[^:]+:){6}([^:]+)

Note: You can replace + with * to handle cases like ::::2: (empty between colons).

1 Answers1