Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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