Hi peter, I'm not worried about the data itself since i'm very clear about the scripting techniques to extract data from flat files or any other non conventional datasource using string functions...the challenge i'm having for now is how to manipulate with qilkview a file that is comming with the structure I described.
Currently what i'm doing is to manipulate the file with a textpad macro that performs 2 tasks:
1) Find every new line indicator (\n) and replace it by a white space (this convert the entire file in a single line.....)
2) Then Find and replace the regular expression </GLTData> for </GLTData>\n
The problem is that this is a very manual procedure and the files size are too big and are many files to process so it is very "expensive" to do that
I want to use the qlikview power to perform this transformation with some scripting techniques since the wizard is not helping me to obtain the same result WITH NO EXTRA MANIPULATION OF THE DATA
Please find attached a ppt that will show the current problem and how the workaround applied is making the "expensive' trick