converting a log file in sometheing readable to ve analized by QVW

[hectorgarcia]

i'm reading a log file that is very particular since is not well formed.

Using some scripting techniques i've being able to have read the log but i'm having some troubles to assemble a table with the data (i'm not expert in the inter records function (in the scripot or chart)

This is my script:

================================================================================

data:
load *,
if(index(t,'Preparing to signin user in RSA')>=1,'Preparing to signin user in RSA',if(index(t,'Session signin process succeded')>=1,' Session signin process succeded',
if(index(t,'Challenge process succeded')>=1,'Challenge process succeded', if(index(t,'NotifyWrongPassword process succeded')>=1,'NotifyWrongPassword process succeded',0)))) as evento,
trim(subfield(t,'Response time ',2)) as [Response time],
trim(subfield(t,'HTTP session ',2)) as Session,
trim(subfield(t,'User ',2)) as USERID,
trim(subfield(t,'NIT ',2)) as NIT
;
LOAD @1:23T,
timestamp(left(@1:23T,18)) as timestamp,
date(left(@1:23T,10)) as fecha,
@24:28T,
@29:n,
trim(subfield(@29:n,'-',4)) as t,
purgechar(trim(subfield(@29:n,'-',3)),']') as t1,
recno() as rec
FROM rsa.log (oem, fix, no labels, header is 0, record is line);

================================================================================

I need to have a table that populate the related items in a single record but did not find a simple way to do it...

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6874.Doc.doc:550:0]

[#2]

Perhaps you can attach the data you are trying to load in a more raw format like .TXT. I would be happy to take a look at it for you.

[hectorgarcia]

Thanks I already resolved, I found an archived article that gave me the lead

Hector

[#4]

Hi Hector

Which archived article helped you with this question?