Hi @shaziakhan,
If there’s a specific pattern for the spaces, you can try using FIND combined with SUBSTITUTE. Just keep in mind that text manipulation is memory-inefficient.
FIND
SUBSTITUTE
Also, note that there are slight differences in how these functions work in Polaris compared to the classic engine.
If there isn’t a clear pattern or logic for the spaces, it might not be possible to achieve a Trim-like functionality in the Polaris engine.
Done with the course but want to practice a bit more before I take the Level 1 exam
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
I have a question about the new Expand or collapse grid rows option. Is it possible to publish a grid containing a 5-level hierarchy so that all items from levels 1 and 2 are always visible? And I do not want to use a filter for this.
