Within a BAQ, I need to “trim” our part description to remove any spaces, carriage returns, etc. (so that it can be used in a CSV file for uploading onto the DHL website when shipping parts.
I have tried using the TRIM function, but this only removes spaces from the left or the right of the description, not the middle.
Is there another function that can be used to achieve this?
Thanks.