topic Re: Re: Search and find a string in QlikView

Search and find a string

Mon, 10 Mar 2014 09:44:04 GMT

Hi All,

I have a requirement to find a string from the data base and represne in a table.

Input data :

Data :

ABC1230

dfg ABC11 th

yur ABC435000 mm

kk ABC76859 ndf ght ii

I need to find the string Which start from ABC.

Expected Output:-

data

ABC1230

ABC11

ABC435000

ABC76859

You help will be highly appriciated

Thanks!
D J

Re: Search and find a string

rustyfishbones — Mon, 10 Mar 2014 09:57:56 GMT

You could try

KEEPCHAR(data,'ABC0123456789') AS Data

Re: Search and find a string

alexandros17 — Mon, 10 Mar 2014 10:02:08 GMT

This is the working expression

If(Index(VAL,'ABC')>0,

If(Index(Mid(VAL, Index(VAL,'ABC')),' ') > 0,

Mid(VAL, Index(VAL,'ABC'), Index(Mid(VAL, Index(VAL,'ABC')),' ')),

If(Index(Mid(VAL, Index(VAL,'ABC')),' ') = 0,

Mid(VAL, Index(VAL,'ABC')),

'---'

)

,'---'

)

Re: Search and find a string

rustyfishbones — Mon, 10 Mar 2014 10:05:50 GMT

Or try

TRIM(PURGECHAR(data,'abcdefghijklmnopqrstuvwxyz')) as [New Data]

Re: Search and find a string

Mon, 10 Mar 2014 10:09:14 GMT

KeepChar is not working because it will return all the character in that string .

Thanks

D J

Re: Search and find a string

tresB — Mon, 10 Mar 2014 10:14:13 GMT

May be like:

Input:

Load SubField(data, ' ') as NewData From <>;

Output:

Load

NewData

Resident Input Where WildMatch(NewData, 'ABC*') ;

Drop table Input;

Re: Re: Search and find a string

rustyfishbones — Mon, 10 Mar 2014 10:18:10 GMT

See attached

Re: Re: Search and find a string

rustyfishbones — Mon, 10 Mar 2014 10:19:34 GMT

You could also try