topic Remove text in QlikView

Remove text

sowmi — Tue, 13 Mar 2018 02:57:28 GMT

I have a 'sw'field in my db which contains values such as the following:

1. dw8 12.8.2/9.2

2. d8 12.8.2 A/B/G/N

3. Blank

Basically im aiming to change to the values to:

1.12.8.2/9.2

2.12.8.2

3.Blank

isingh30 — Tue, 13 Mar 2018 15:55:29 GMT

Please use Sub field Function.

Colin-Albert — Tue, 13 Mar 2018 15:55:39 GMT

Use subfield.

subfield(data, ' ', 2) as sw will just return the data after the first space

test:

load

subfield(data, ' ', 2) as sw,

data

inline [

data

dw8 12.8.2/9.2

d8 12.8.2 A/B/G/N

Blank

] ;