Splitting text by 2nd appearance of word

Hi all

I’m probably being really thick here but I’m struggling with something and wondered if someone could point out where I was going wrong.

I’m looking at this text:

Kitchen Cooke New World FL 7.9 KW/h Yes N/A N/A N/A N/A High: High: Yes No Yes Yes r - / Low: Low: Dual BG740VQI Fuel DUP Utility Boiler Baxi / RS 17.2 KW/h Yes N/A N/A Yes Pass High:.0009 High:.0009 Yes No Yes Yes Room - Gas Low:.0004 Low:.0004 Under System 14 70kw

I’m trying to get the text after the 2nd appearance of “High:” by using Split(strText,“High:”)(2) but the text it’s returning is Yes No Yes Yes r - / Low: Low: Dual BG740VQI Fuel DUP Utility Boiler Baxi / RS 17.2 KW/h Yes N/A N/A Yes Pass

Any idea why it’s returning the text between "High:"s and not just splitting it? What am I doing wrong?

Thanks :slight_smile:

Hey

You could use Regex.

What is your expected output? What is consistent with your text?

Check out my Regex MegaPost to learn more :slight_smile:

Regex preview sample

Hi,

Could you try like below and see if you are getting the correct output. Thanks.

yourstring.split("High:"c(2))