Is it possible to parse a *.csv file and remove certain rows if it matches through Automic script. ?
or should we be using external scripting language ?
Thanks and Regards,
You can usehttp://docs.automic.com/documentation/AE/10.0/english/AE_WEBHELP/help.htm?product=awa#ucaafq.htm?Highlight=:PREP_PROCESS_FILEto read the file and store the filtered content in a VARA and then PREP_PROESS_VARA to write down the VARA content to a file.
..however I would strongly suggest to do it with an external script language :).
I tried using PREP_PROCESS_FILE but it was not working as expected.
I agree that using a external script language would be better as the file is a huge and processing & formatting would be better handled.
Retrieving data ...