Beast Mode to remove text after space

ozarkram · 2022-07-21T16:07:57+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Comments

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!

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of