I'm working with a lot of Excel files from our production and partners, and I have to merge them a lot to get what I need.
Multiple times, I have to compare the values of multiple columns to select the good one with rules, and put it in a final column.
But in some columns, I have spaces instead of empty() values.
I know that I can use the trim() function to remove spaces on a column.
But I need to do that on a lot of column.
Can you add something, an action or an option on import file to trim all the columns ?
Or is there something to do it easy ?
Maybe you could add something in the description like this : "Remove hidden system characters, extra spaces, and line breaks, like the trim() function".
I think this action do more than the trim() function, but I think it could be helpful to add something like this.
Or at least make it appear when we search "trim" in the actions.
Whilst it doesn't appear in the regular search for the term "trim", it does appear in the new extended search, although admittedly not at the top. Searching for "whitespace" or "spaces" seems to do a little better but still isn't perfect. We're actively working on improving the action search so I'll send your feedback to our UX team to see if they can improve this specific case further.
