Beast Mode to remove text after space

ozarkram
ozarkram ⚪️
edited July 21 in Dataflows

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..

Comments

  • Ashleigh
    Ashleigh Florida 🟣

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

  • @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
    ozarkram ⚪️

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