topic Re: Read .log file dynamically in QlikView

Read .log file dynamically

Tue, 01 Mar 2016 15:58:18 GMT

Hi qlikers,

I have an issue reading .log file. When i want to read xKULLANICI there are several lenghts before "_" character. Is there any option to read data dynamıcally? Ex, when BEGUMT is 6 char length, read 6; BATUHANK is 8 char length, so ıt has to read 8 char before the "_" char.

Thank you folks.

Re: Read .log file dynamically

maxgro — Tue, 01 Mar 2016 22:25:42 GMT

subfield

load *, subfield(xKULLANICI, '_', 1) as Before_ inline [

xKULLANICI

BATUHANK_502083/N

BATUHANK_502263/N

BEGUMT_0000000

Berkant_65837432

]

;

Re: Read .log file dynamically

jagan — Wed, 02 Mar 2016 02:05:42 GMT

Hi,

Try like this

Data:

LOAD

SubField(xKULLANICI, '_') AS NewFieldName

FROM DataSource;

Hope this helps you.

Regards,

jagan.

Re: Read .log file dynamically

Wed, 02 Mar 2016 06:11:56 GMT

There are lots of people in this list. So, that not an optimal solution for me but thanks for answer, i'll like it.

Re: Read .log file dynamically

Wed, 02 Mar 2016 06:12:58 GMT

I use and it works. Thank you!

SubField([@59:N], '_', 1) AS xKULLANICI

Re: Read .log file dynamically

avinashelite — Wed, 02 Mar 2016 06:23:08 GMT

Try with subfield() function.

Load *,

subfield(xKULLANICI, '_', 1) as field1,// this will give the data before _ i.e. position 1

subfield(xKULLANICI, '_', 2) as field2,// this will give the data after _ i.e position 2

subfield(xKULLANICI, '_') as field3, //if you don't specific the position than it will load all the data i.e before and after _

Re: Read .log file dynamically

Wed, 02 Mar 2016 09:11:40 GMT

Re: Read .log file dynamically

oknotsen — Wed, 02 Mar 2016 15:21:22 GMT

If your question is now answered, please flag the Correct Answer and optionally Helpful Answers.

If not, please make clear what part of your question you still need help with .