How to remove whitespace after a full name in ETL

helpme12345 · 2023-05-31T19:47:40+00:00

There was an error rendering this rich post.

I have a name column with a full name: example Bob Dylan and am joining to another dataset by name. I'm having issues and believe its due to extra white space after the last name.

I tried using Replace text, regEx, \s, but that just removed all white space creating BobDylan.

Any thoughts here?

Find more posts tagged with

Magic ETL

Accepted answers

GrantSmith

You can use the TRIM function in a formula tile to strip leading and trailing whitespace off of a string.

MichelleH

@renee12345 The TRIM() function in the Formula tile will remove any extra spaces from text values, while preserving spaces between words. Try applying that formula to your dataset field before joining.

All comments

GrantSmith

You can use the TRIM function in a formula tile to strip leading and trailing whitespace off of a string.

MichelleH