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?
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:
See also our tutorial on expressions here: EasyMorph | Type system and expressions
Thanks @dgudkov. We tried that first. We get this error?
as described in the documentation.
Oh, my bad. Of course, it should be
@Jochen_Marquardt, thanks for pointing it out.
That worked great. Thank you.