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.
Hello, i have been trying to get this to work too, but it's not. My data may be slightly different in that i have a regex earlier on in the flow which is removing text between brackets so from:
AB1234 (XY23RG) Widget
I think in doing this using \(.*?\) it's leaving a trailing space as i have two spaces inbetween now. Like the original poster the data cleanse tool is not getting rid of it, and the suggested regex here doesn't appear to work either.
Thought the behaviour you describes makes me think that this isn’t actually whitespace as in fact some funky character that looks like whitespace.
What I would do is take a sample like and use the text input to right that value out, as you write it out you know you are using the space key, then perform a join, if they don’t match then it’s some strange chars that are causing the issue.
Also Roger, if you are using the ‘multfield’ method, make sure you have the ‘copy output as new field’ option checked as this can often fool people into thinking that it isn’t working when it is, because they don’t acknowledge it has gone into a new field!