Do we have any alternative way for TRIM function in Polaris model.

shaziakhan
shaziakhan
in Modeling

Answers

  • seymatas1
    seymatas1

    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.

    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.

Categories