I have parsed the “Won…” into a string field, but I can’t convert it to INT or DOUBLE in a pipeline step (I’m using Compass btw). So my field looks like this:
str_oscars:“3” in the GUI, but when I parse it using NumberInt() into a new field, i get num_oscars:NaN. I’ve tried $toInt and $convert and neither seem to work at all (“unrecognized expressions”).
Hopefully this is simple and tangential to the core problem, and TIA!
Edit: I realized, I do the calculations based on the rating, not the number of oscars, and it’s already a number, but i’d still like to know the answer to the original question