Trying to filter to rows where a field starts with the letter "O"

#1

I am attempting to filter my dataset to just items that start with the letter O.

Using this function - gives me an error.

FXN: [Item Number]startswith(O)

Error: Unexpected text after the end of expression. Error position 14
Source: action "Filter by condition", table "YTD_NewItems_20231019(PIM).txt"

How can I correct it?

#2

Hello Carl and welcome to the Community!

Text literals (constants) should be wrapped in quotes - single quotes or double quotes. Therefore, the correct syntax is:

startswith("O")

See also our tutorial on expressions here: EasyMorph | Type system and expressions

#3

Thanks @dgudkov. We tried that first. We get this error?

image
image840×634 53.4 KB

#4

Try

startswith([Item Number],"0")

as described in the documentation.
https://help.easymorph.com/doku.php?id=syntax:functions:startswith

2 Likes
#5

Oh, my bad. Of course, it should be

startswith([Item Number],"0")

@Jochen_Marquardt, thanks for pointing it out.

1 Like
#6

That worked great. Thank you.

1 Like