Search in a string and pick up a word

[0li5a3a]

Hi there,

is there a way to search into a column in qlikview and pick up a word and create a new column which got the field value?

Tab1:

LOAD * INLINE [
id, description
1, Balsasa sadadssa TSA000123 DADSADSADADA
2, TSA00002345 BABSDBABDSABDSABDSABDBSAD
3, DSAHDSADASBDSA - TSA0004567
4, DJSADJSADJSA:tsa00023435
];

I want a to create a new field in a new table where I call it TSA and my new table to look like this

Tab2:

id,

description,

tsa

resident Tab1;

The tsa column need to look something like this : TSA000123 , TSA00002345 , TSA0004567, tsa00023435.

Can someone help me with that ?

Many thanks C!

[Colin-Albert]

Try this expresion...

SUBFIELD(mid(description, index(upper(description), 'TSA'), 20), ' ', 1)

[Colin-Albert]

LOAD
SUBFIELD(mid(description, index(upper(description), 'TSA'), 20), ' ', 1) as tsa,
*
INLINE [
id, description
1, Balsasa sadadssa TSA000123 DADSADSADADA
2, TSA00002345 BABSDBABDSABDSABDSABDBSAD
3, DSAHDSADASBDSA - TSA0004567
4, DJSADJSADJSA:tsa00023435
];