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.
Hi, I have a string which have some empty spaces before the text. Using trim function (trim, trimleft) does not work, when I copy the data to excel or notpad they seem to be just a blank spaces. Any idea how can I remove them and make the data consistent. Just as a side note the records of this column have different lenght.
I tested with a non-breaking space as the first character and the TRIM function doesn't remove it. This is probably what is happening in your case so the RegEx approach is more 'generous' in the definition of whitespace.
Note, though, that the Alteryx TRIM function is fully specified as TRIM(x,y) where x=your field to be trimmed and y=the character you want to trim so if you knew the ASCII code for the character that wasn't getting trimmed, you could specify it as the y argument.