If & Len

[Anonymous]

Can anyone tell what is the issue in this formula?

Trying to extract the numbers then after looking at the first digit assign valid or invalid status
using it in custom column in editor
if (Text.Start(Text.Select([StoreCode], {"0".."9"})) ) = 5 then "Valid" else "Not Valid"

[Anonymous]

Tried "5" as well nothing changed.

Formula isn't showing any error in syntax but when I apply it says

Expression.Error: 1 arguments were passed to a function which expects 2.
Details:
Pattern=
Arguments=[List]

[HotChilli · Accepted solution]

Text.Start takes 2 parameters.

5 is not a text value.

That's my initial thoughts.

Break it down to get it working, then build it back up

[Anonymous]

Yes i was missing the second parameter of count.