Remove text

[sowmi]

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]

Please use Sub field Function.

https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm

[Colin-Albert]

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

] ;