Page 1 of 1

Append data to file in turn?

Posted: Fri Mar 11, 2005 11:16 pm
by sergeda
Hi. Is this possible to append some data to file in turn?
The reason is that I extract some data each line in turn, then I need to save this data before processing next one. Can somebody help me with this?

Posted: Sat Mar 12, 2005 9:04 pm
by DataMystic Support
You could use the new Capture Filter in v7.3, or use VBScript to get the same result (but slower).

A bit more details?

Posted: Mon Mar 14, 2005 6:48 am
by sergeda
Thank you for reply.
Can you give a bit more information? I have a file with lines of data like this "MAC_Addr:0002B32E2208,Computer_Name:FESUPPORT,System:Windows 2000 build 2195(Server)/Service Pack 4,Record_Date:2.03.2005,CPU:Intel Pentium II 333 MHz MMX Deschutes " and I want to extract every peace of data, rearrange it and then write to file. I started from creating filter "Line in turn", than I create number of subfilters to extract data and result of every extract I remember in diffrent global variable. If I enable only one extraction filter - it extract data, but when I enable all of it, nothing happen. Could somebody help me with it or give me the name of the demo file to look at?

Posted: Mon Mar 14, 2005 8:21 am
by DataMystic Support
Naturally, the Extract option removes all non-matching text. You need to save the data instead - for every matching option - and then discard matching text.

See this white paper: http://www.datamystic.com/docs/reportmining.pdf

Didn't get it

Posted: Tue Mar 15, 2005 12:02 am
by sergeda
Ok. I achieve needed result and now every variable get it's data, but I can't gain what you say I need - cannot save the data - for every matching option - and then discard matching text. Haw can I achieve this result. Every turn I get one line of data, extract data that I need and assign it to number of variables. Now I need to save this variables every turn to file. How can I achieve this?

Posted: Wed Mar 16, 2005 4:19 pm
by Guest
One way is to use an Add Footer filter, which uses the @varname macros that you've saved data into to output the variables.

Another way is to place the data you need on new lines with a marker like '###', then remove all non matching lines.

Thanks

Posted: Fri Mar 18, 2005 9:31 pm
by sergeda
Thanks a lot