Hi,
Currently I am using the following: filter "tableName.csv"."TASK_TITLE" LIKE 'Condition1' which is filtering on a specific name.
How do I change the syntax so that it takes into account an additional condition? i.e. I want it to filter words that have a full stop in them. (condition 2 = '.')
thanks,
Terence
Hi Terence ,
You can add like the following ways :
Way-1:
FILTER "tableName.csv"."TASK_TITLE" LIKE 'Condition1' ;
FILTER condition 2 = '.';
All filter statement should end with ;
Way-2:
FILTER "tableName.csv"."TASK_TITLE" LIKE 'Condition1' AND condition 2 = '.' ;
Hope this helps.
Please mark my response as Best Answer if it is helpful to you.
Regards
Ayan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
