starts with, for a string

[becki]

just starting out with Alteryx from an ACL background.  if i have a field and i only want to pull out the records that start with "PO" , how do I do that?  i tried the reg ex    \<["PO"] but that's not cutting it and i'm not entirely certain what the filter "starts with" does because it doesn't seem to be what I need.

thanks in advance

becki kain

[JordanB · Accepted solution]

Hi @becki

You could use a filter tool and use the function: Startswith([FIELDNAME], "PO"). I have attached an example workflow which you can download

Best,

Jordan Barker

Solutions Consultant

[becki]

thanks!  I had the things backwards!

[saivig68]

Hi , 

I am trying to setup a starts with - with multiple targets ? Is that doable.

[BenGomez]

Sort of.  For multiple targets you have to specify multiple StartsWith functions each with it's own target and then OR the results assuming you want any of them to match.

StartsWith([Field1], "A") OR StartsWith([Field1], "B") OR StartsWith([Field1], "C")

[asahibzada001]

Hi

I am trying to make a sum with the first 3 letter in the ID number. does anyone have a solution for that ?