test please delete

[ladymuck]

I set off a bit early as it's right next to M&S, where I was able to pick up my new coat, with which I'm pretty pleased

[ladymuck]

It's been a good day at the coal face. Now pondering the best way to work out how to determine if one element of an array of strings is contained within another string. It's a bit of a reverse of the normal.

[NickFitz]

It's been a good day at the coal face. Now pondering the best way to work out how to determine if one element of an array of strings is contained within another string. It's a bit of a reverse of the normal.

In JavaScript, assuming variables array_of_strings and putative_superstring, you can do:

return array_of_strings.some(value => putative_superstring.includes(value));

Though to work on IE, which doesn't support ES6:

return array_of_strings.some(function(value) { return putative_superstring.indexOf(value) != -1; });

[ladymuck]

That's all a bit


Mostly because I know sweet FA about JavaScript

In the meantime, I distracted myself by finishing S6 of Marvel's Agents of the increasingly implausible SHIELD.

Bring back the Oak Island nutjobs, all is forgiven!

[ladymuck]

Turns out, watching tat on the telly is perfect for fixing tricky problems.

All solved with:

=INDEX($A$2:$A$5,MATCH(1,ISNUMBER(SEARCH($A$2:$A$5 ,C2))*1,0))

Entered as an array formula so it gets some curly brackets around it

[NickFitz]

Tea has been ribs and chips

I didn't really have the energy to make the lamb shanks, so they'll be done tomorrow when (I hope) the booster jab's side effects have diminished

It's not as bad as the first couple of times, I don't think, but it has made me feel pretty tired after a few hours

[WTFH]

Teaming it down here. Watched GBBO then Judy Dench on WDYTYA.

[vetran]

Turns out, watching tat on the telly is perfect for fixing tricky problems.

All solved with:

=INDEX($A$2:$A$5,MATCH(1,ISNUMBER(SEARCH($A$2:$A$5 ,C2))*1,0))

Entered as an array formula so it gets some curly brackets around it

my goodness no Vlookup?????? Pat yourself on the back!

Once you use it to retrieve more than one column from data match wins hands down. On large amounts of data match just performs better.

[vetran]

A few drops of rain here in the PRS.

[NickFitz]

Been raining here for a couple of hours or more, off and on but mainly on. This is predicted to continue with little in the way of a break throughout tomorrow, and there's even the chance of a thunderstorm around lunchtime

Telly was Traffic Cops whilst dining

And after that, the rather more peaceful environs of The Repair Shop

Feeling pretty beat now, presumably due to the vaccine, so an early night seems like a good idea

Goodnight all