cancel
Showing results for 
Search instead for 
Did you mean: 

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

SANDEEPRATTAN
Level 3
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
1 REPLY 1

HarpreetKaur
Level 7
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.