Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to remove the brand name from model field ?

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

2 Solutions

Accepted Solutions
benvatvandata
Partner - Creator II
Partner - Creator II

Try:

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

 

Thanks,

Ben

View solution in original post

Kushal_Chawda

try below

 

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

View solution in original post

8 Replies
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
Master
Master
Author

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
Partner - Creator II
Partner - Creator II

Try:

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

 

Thanks,

Ben

Kushal_Chawda

try below

 

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

paulyeo11
Master
Master
Author

Hi Kush

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

Paul

paulyeo11
Master
Master
Author

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