How to fill blank with OTHER ? SubField(@315:343T, ' ', 1) & 'OTHER' AS BRAND_DESC,

[paulyeo11]

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

[Arthur_Fong · Accepted solution]

Try this:

if(len(SubField(@315:343T, ' ', 1))<1,'OTHER',SubField(@315:343T, ' ', 1)) AS BRAND_DESC

[paulyeo11]

Hi Sir

Thank you very much.

Paul