Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can someone explain me what does the below code is doing ?
where (Department='TT' and not match([Code dep],'IP-0AF5C33F\NNMoLI')) or left([Code dep],10) ='TT_BT';
Thanks
Hi,
it will give you the below result.
Where(Dep='TT') means it wil display only related to 'TT' department and [Codedep] not equal to='IP-0AF5C33F\NNMoLI or it will display first 10 letters in the [Code dep]
It brings the data only the Department field value is 'TT' and
Code dep not equal to 'IP-0AF5C33F\NNMoLI' or
Code dep is like (the value is which is extracted 10 charecters from left side) that eqaual to 'TT_BT'
Hi chanty thanks for the explanation , can you please tell me what is this doing ,iam confused now
or left([Code dep],10) ='TABLETS_BT'; ? is giveing [Code dep] =TABLETS_BT becuase this are 10 words
Hi,
Did you checked the aboe link which i have mentioned above it gives you clarification for your doubt.
check sample example:
DATA:
LOAD * INLINE [
CODE
ADMNNFNFNFNFN
AJDJFIMIKMEKM
NSAJJFMGKGMGM
];
RESULT:
LOAD *,
Left(CODE,5) AS NEW
Resident DATA;
Hi John,
code: where (Department='TT' and not match([Code dep],'IP-0AF5C33F\NNMoLI')) or left([Code dep],10) ='TT_BT';
applying following condition
1. Department='TT'
2. and [Code dep] should not equal to (<>) 'IP-0AF5C33F\NNMoLI'
3 or count of 10 characters of [Code dep] from left should be 'TT_BT'
Thanks,
It will give the rows that [Code dep] having values of 'TABLETS_BT' at the beginning.