subfield(@315:343T,' ',1), 'OTHERS' AS BRAND_DESC, return only OTHER

[paulyeo11]

Hi All

I have one column from 315 till 343 is product Describe of model like below :-

ZIMMER WWR50F-B

I use the below load script to get the brand name :-

subfield(@315:343T,' ',1), 'OTHERS' AS BRAND_DESC,

I only get OTHERS AND Unable to get ZIMMER Brand

May i know where i go wrong ?

Paul Yeo

[sunny_talwar · Accepted solution]

Are you trying to get ZIMMER OTHERS? May be this

SubField(@315:343T, ' ', 1) & ' OTHERS' AS BRAND_DESC,

[paulyeo11]

Hi Sunny

Yes , your script work fine :-

SubField(@315:343T, ' ', 1) & '' AS BRAND_DESC,

I don't need the OTHER , so above is what i need.

Appreciate very much.

Paul