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?
dgudkov
#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
Thanks @dgudkov. We tried that first. We get this error?
Try
startswith([Item Number],"0")
as described in the documentation.
https://help.easymorph.com/doku.php?id=syntax:functions:startswith
2 Likes
dgudkov
#5
Oh, my bad. Of course, it should be
startswith([Item Number],"0")
@Jochen_Marquardt, thanks for pointing it out.
1 Like
That worked great. Thank you.
1 Like