Set up query to tag items start with P but run through the process .

SANDEEPRATTAN — Wed, 10 Mar 2021 04:43:45 GMT

Hi,
I am passing orders from the worksheet with initial T using expression instr > 0 so items with P do not pass through the validation and get mark as exception.

I have set tags to choose items type criteria but tag stage is not identifying the P items and letting them go through the process

Please suggest

Re: Set up query to tag items start with P but run through the process .

HarpreetKaur — Fri, 12 Mar 2021 00:13:57 GMT

Hi Sandeep,

Could you please elaborate on the exact expression you're using?
InStr can work for a character placed anywhere in the string, it doesn't necessarily have to be in the first position. so if there are orders with 'P' anywhere in the entire string it will be considered as a pass.
If you are looking to process only the orders that start with a 'T' and not with 'P' you might want to consider LEFT substring expression to get the first letter using - Left([stringT], 1) where stringT is your Order name and then check if the result is a P or T.
Hope this helps.

topic Set up query to tag items start with P but run through the process . in Product Forum

Set up query to tag items start with P but run through the process .

Re: Set up query to tag items start with P but run through the process .