Archive

Archive

Removing Comma's from string in Beast Mode Numeric Values

I have a Beast Mode that I'm using to trim a value from a string, the issue is that the trim contains a comma which prevents me from treating the resulting values as a number and therefore suming the totals.

Here is the Beast Mode that is producing the trim value:

 

Case When Month(`EventDateTime`)= month(CURRENT_DATE()) and `EventNotes`is not null THEN LEFT(`EventNotes`, INSTR(`EventNotes`, ';') - 1)
else 0
End

 

Is there another Beast Mode I could use to remove the comma or a way to remove the comma in the above beast mode.

Any help as always appreciated.

Thanks

Randy

Comments

  • I was able to do the trim and then convert the column in the ETL itself so no longer a need to do this in the Beast Mode.

    Thanks

    Randy

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In