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?