Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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