Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to extract data from text file ?

Hi

How to extrect data from text file which is not arrange in a proper format. Say I want to generate 1 report which contains data like Timestamp, username & document name that user downloaded.

All these details are present in a text file.

Br

Anta

1 Reply
Miguel_Angel_Baeyens

Hi Anta,

You will have to use as many string functions as needed to clean the data until you get exactly what you want. As a general rule, I'd load the whole row as one field, and starting from that, cleaning the data as required. You have in this thread a good example on how hard could become to do this job in QlikView.

Hope that helps.

Miguel