This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 10-14-201604:24 PM - edited on 05-22-201902:09 PM by SydneyF
There are a couple of different whitespace situations you might get yourself into, but the schematic below (from the attached example Remove Whitespace.yxmd) has you covered in all of them:
Most of the approaches make use of the Formula Tool’s trim() function which, without a second argument, defaults to trimming whitespace from your strings. You can also use the Data Cleansing tool to clean your fields for you! Master it here.