Beast Mode to remove text after space

ozarkram

Hi All,

I am trying to remove the text after space from the below example ..Can you please let me know how to do the same..

R17245 20 should return just R17245

FG789 32 should return just FG789...

Can you please let me know how to achieve this in beast mode..

Ashleigh

@ozarkram I know you can use split_part or squash_whitespace in the formula tile of an ETL

mhouston

@ozarkram you can do this using the instr() and left() functions. You use instr() to find the first space, and then use left to take everything to the left of that index.

The formula looks like this:

left(fieldname,INSTR(fieldname,' ')-1)

ozarkram

Thank you so much @mhouston!..Really appreciate your help!