Skip navigation

REGEX..., SPLIT(), and FINDNTH() support for table calcs and fields from multiple data sources

score 21
You have not voted. Active

It turns out that the SPLIT(), FINDNTH(), and REGEX... functions introduced in v9 do not support table calcs or fields from multiple data sources, here's an example:

 

Screen Shot 2016-05-17 at 6.57.18 AM.png

 

I would like that support. The particular use case I have in mind is parsing out data returned from R scripts, it would be a lot easier if I had access to these features.

 

Also FLOOR() and CEILING() are not available for table calculations either.

 

Jonathan

Comments