Can this Excel formula be converted for use in Alteryx?

[rbelski]

I want to replicate an Excel formula that returns any set of characters in a cell to the left of a space.  The purpose is to convert a column from an input file called "Area Description" to a field "Area" containing only characters to the left of the space (example data below).

I've tried the Formula Tool, then started reading about the RegEx Tool but am a bit overwhelmed by all the options.

BULK01 - Floor Bulk Storage

DEVFLR01 - Device Floor A Area

DEVSCNY01 - Device Secondary Storage Area

HVYPRMY - Heavy Rack Primary Area

[binu_acs · Accepted solution]

@rbelski 

[Bren_Spill2]

Hi @rbelski - you could also use text to column here. Not as elegant as @binu_acs's solution, but works!

[rbelski]

Works perfectly... thanks!