topic Re: Search text in lines in QlikView

Search text in lines

anuradhaa — Thu, 14 Jan 2016 10:33:13 GMT

I have a column in my db and that colum has text like below,

@gsuiguidf #144646 fgedygfeygf #hvdvd

@gfgrtrrrre #232424 tytytuyu #656576

@retrtrytry #265656 fgfhth

I havnt to get the 1st number after # mark when loading data to QV

sunny_talwar — Thu, 14 Jan 2016 10:35:34 GMT

May be this:

TextBetween(FieldName, '#', ' ') as Number

PrashantSangle — Thu, 14 Jan 2016 10:40:05 GMT

Hi,

Use subfield(FieldName,'#',2)

Edit:

If you want only number then

subfield(subfield(FieldName,'#',2),' ')

Regards

engishfaque — Thu, 14 Jan 2016 10:52:23 GMT

Dear Anuradha,

Kindly find attached document, I hope you are looking for that one App.

Kind regards,

Ishfaque Ahmed

PradeepReddy — Thu, 14 Jan 2016 10:58:03 GMT

textbetween(Field_Name,'#','#')

awhitfield — Thu, 14 Jan 2016 11:21:06 GMT

HI AA,

The following method also works

KeepChar(Subfield(Data,'#',2),'0123456789') as Number

Full Script using inline load:

Data:

Load * Inline

[

Data

@gsuiguidf #144646 fgedygfeygf #hvdvd

@gfgrtrrrre #232424 tytytuyu #656576

@retrtrytry #265656 fgfhth

];

Data2:

Load

KeepChar(Subfield(Data,'#',2),'0123456789') as Number

Resident Data;

HTH Andy