Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
When my script below :-
SubField(@315:343T, ' ', 1) & 'OTHER' AS BRAND_DESC,
I get below , Where there it a blank , it does not indicate OTHER :-
BECKHOFF
MITSUBISHI
GE
UNIVERSAL
HAKKO
MSA
HMS
I try to modify the script to below , by add OTHER to below script :-
SubField(@315:343T, ' ', 1) & 'OTHER' AS BRAND_DESC,
MOTIONOTHER
LEIPOLEOTHER
KINCOOTHER
50POTHER
METEOOTHER
AUTENTOOTHER
SECOMEAOTHER
BECKKOFFOTHER
EISELEOTHER
TOYOOTHER
BEIJEROTHER
I get all brand with OTHER at the back.
May i know how to change ? So that it will fill the blank with OTHER
Paul Yeo
Try this:
if(len(SubField(@315:343T, ' ', 1))<1,'OTHER',SubField(@315:343T, ' ', 1)) AS BRAND_DESC
Try this:
if(len(SubField(@315:343T, ' ', 1))<1,'OTHER',SubField(@315:343T, ' ', 1)) AS BRAND_DESC
Hi Sir
Thank you very much.
Paul