How to remove the brand name from model field ?

[paulyeo11]

Hi All

I have below load script :-

@12:42T as [DESC_INVENTORY_TABLE],

BECKHOFF 023309

I need it remove the brand name and jut display the model number like below :-

23309

Hope some one can advise me.

Paul Yeo

[Kushal_Chawda]

try below

num(KeepChar([DESC_INVENTORY_TABLE],'0123456789'))

[Kushal_Chawda]

If your string format is same (Text [Space] Number) then try below

num(SubField([DESC_INVENTORY_TABLE],' ',2))

[paulyeo11]

Hi SirThank you for your sharing  , i have try your script :-

 num(SubField(@12:42T,' ',2)) as MODEL_,

When the model number is below :-
 

NSI 16 ALPHANUMERIC LED MATRIX

it display 16

May i know how to modify the script , to make it display :-

16 ALPHANUMERIC LED MATRIX

Paul Yeo

[Kushal_Chawda]

What do you want to display for above examples?

[benvatvandata · Accepted solution]

Try:

Right(@12:42T, Len(@12:42T) - Index(@12:42T, ' ', 1)) as Model

Thanks,

Ben

[Kushal_Chawda · Accepted solution]

try below

mid(@12:42T,Index(@12:42T,' ')+1,len(@12:42T))

[paulyeo11]

Hi Kush

Thank you.  your is shorter , should be the best  , but not easy to understand how it work. 

Paul

[paulyeo11]

Hi Benva

Thank you.

Your is longer , is suppose to be the best , because i can understand your expression well. So easy for maintenance.

Paul