Remove all characters after initial whitespace.

[mattcoleman]

I'm trying to remove all characters that happen after initial whitespace. Should be a pretty simple split, but I can't figure it out. Example below:

PM AWI -> PM

123 GAM -> 123

1nas89 aee aer -> 1nas89

Thanks!

Matt

[Thableaus · Accepted solution]

Hi @mattcoleman 

What about a Text to Columns Tool?

Cheers,

[KP_DML · Accepted solution]

You could use the formula tool to grab the string up to where the space occurs.

Left([InputField], FindString([InputField],' '))

[Thableaus]

@mattcoleman 

You can also try regex.

REGEX_Replace([Field1], "(.+?)\s.*", "$1")

or REGEX_Replace([Field1], "(\S+)\s.*", "$1")

Cheers,

[mattcoleman]

All of these methods actually work, so thanks! I prefer the LEFT formula tool or REGEX over the Text to Columns tool due to the creation of an additional column.