topic Re: extract function in QlikView

extract function

master_student — Tue, 14 Feb 2017 16:52:05 GMT

Hello Guys

I hope you are good

I have a field in my database that contains number and test, I would like to extract only the number before the '-' with a qlikview function.

Any idea please

here 's my field :

for the first value for exampe i want to extract 2205 and put the result in a new field

Thankss

Re: extract function

vishsaggi — Tue, 14 Feb 2017 16:54:17 GMT

Use

LOAD *,

Subfield(EVENTDETAILS4, '-', 1) AS yournumber,

Subfield(EVENTDETAILS4, '-', 2) AS yourtext

FROM yourtablename;

Re: extract function

maxgro — Tue, 14 Feb 2017 16:55:24 GMT

look at these 2 functions

keepchar subfield

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringFunctions/KeepChar.htm

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringFunctions/SubField.htm

Re: extract function

Chanty4u — Wed, 15 Feb 2017 06:30:55 GMT

Try like below

LOAD * INLINE [

Text

2205-EISA

6344-SECM MSC SOUSE

2846-SSS-678 MFJFG

];

Result:

LOAD

KeepChar(Text,'0123456789') as NewField

Resident a;

Re: extract function

Anil_Babu_Samineni — Wed, 15 Feb 2017 06:39:50 GMT

Chanty Bhai, Your expression won't work here due to he need only Number's of left hand side of the Field

From your data the out put came like below

2205 6344 2846678(This is wrong)

And he want

2205 6344 2846

Re: extract function

sdmech81 — Wed, 15 Feb 2017 06:42:55 GMT

Hi,

U can do this by many ways by using different sets f string functions.

Attaching string function list here.Go through n u can try as many as.

U can use Subfield fr this.Example is thr inside attachment.

Sachin

Re: extract function

Chanty4u — Wed, 15 Feb 2017 06:43:54 GMT

Hmmm ... He doesnt have that field value i just added if he require like that also he will get,

in his screen shot there is no value like below

2846-SSS-678 MFJFG

Re: extract function

shraddha_g — Wed, 15 Feb 2017 07:37:14 GMT

You can also try

left( FieldName, index(Fieldname,'-',1)-1) as Newfield

Re: extract function

master_student — Wed, 15 Feb 2017 10:18:05 GMT

Thank you for your interation guys