Convert this formula to M Language?

[Stoner7Matt]

Could anyone help me convert this formula to M Language?


IFERROR(LEFT(I3,FIND(",",I3)-1),I3)

This formula currently pulls the text before a comma, if it finds no comma, it returns the text.

For example...

Robert Smith, Jon Jones - Result would be Robert Smith

 

[Matt Allington]

The if statement in Power Query Formula Language (or PQL as I like to call it) is just like conversational English and is case sensitive

if some_test then do_something else do_something_else

There are no commas etc

here are the text formulas you will need. 5 Very Useful Text Formulas - Power Query EditionThe Ken Puls (Excelguru) Blog

 

[anvg]

Hi

let
    source = "this is a string, but",
    return = if Text.Contains(source,",") then Text.Range(source, 0, Text.PositionOf(source,",")) else source
in
    return

Regards,