Parsing space delimited text tables using Infinity

[uajqq]

I'm trying to parse data from NOAA buoys that is reported like this (I don't have control over the data source):

#STN       LAT      LON  YYYY MM DD hh mm WDIR WSPD   GST WVHT  DPD APD MWD   PRES  PTDY  ATMP  WTMP  DEWP  VIS   TIDE
#text      deg      deg   yr mo day hr mn degT  m/s   m/s   m   sec sec degT   hPa   hPa  degC  degC  degC  nmi     ft
13001    12.000  -23.000 2025 07 25 19 00  17   5.1   6.2   MM  MM   MM  MM 1012.0    MM    MM    MM    MM   MM     MM
13002    21.000  -23.000 2025 07 25 19 00  MM    MM    MM   MM  MM   MM  MM     MM    MM  24.6    MM    MM   MM     MM
13008    15.000  -38.000 2025 07 25 19 00  65   8.7  10.3   MM  MM   MM  MM 1014.6    MM  25.8  26.4    MM   MM     MM
14048    -8.000   65.000 2025 07 25 19 00 162   8.3  10.6   MM  MM   MM  MM 1012.6    MM  27.2  27.8    MM   MM     MM

The problem is that each value has a variable number of spaces between them, so I can't use as a delimiting character -- each line is interpreted as having a variable number of columns, and I get a "wrong number of columns" error. Is there any way to set the delimiting character to multiple spaces, like regex \s+, or to transform the data into comma-separated values prior to parsing? I can use value mapping in table visualization, but that doesn't allow me to actually split the columns or parse the data for calculations.

[yesoreyeram]

Nope. This is not supported. Unknown/variable number of spaces delimitation is hard to support.

[uajqq]

Can you point me in a direction to figure out how to parse this kind of data, in that case? Do I have to pull it in to one table, and then use that visualization as a source for a second calculation?

[uajqq]

For anyone else having this issue, right now I'm solving it by using a crontab python script to parse the file with pandas every 5 min, then accessing the resulting CSV from my own server. If there's a way to due this entirely within Grafana / Grafana Cloud, though, that would be preferable.