Web table sorting/selecting columns and rows

I’d like to use realtime raindata which is in three numbers (000) as input to change a colour (rgb, also 3 numbers). For instance, have the rain change the reds, or greens or blues of a constant. Here’s my project file: rainradar-to-colour.toe (3.6 KB)

I’d like to pull the rain data (first three digits) and time separately so I can use both for different purposes. Can someone point me in the right direction how to achieve this?

So I try to pull the data out of a WEB dat with a SELECT dat like in this pic, but pull the 000 and the times after the | in the row separately.

You want your Web dat to feed to a Convert dat. In the Convert dat, use “|” as the “Split Cells at” parameter. That yields two columns in the Convert dat.

From there, I’m not sure what else you want to do, but you probably want to convert the times in the right column from strings (“14:05”) to something numeric like minutes in a day.

I attached a version of your file that does that. From there… good luck!
rainradar-to-colour.2.toe (3.9 KB)

Knew it could be done, but wouldn’t have thought of using a convert op, so thanks!