• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

Append data to CSV file

hello,

I have a client tool which exports data to csv file and everytime i refresh the data the csv file gets new data and delete the old data. I need data to be appended wth every refresh and how is hs possible?

Thanks,
Sailaja
0
welcome 123
Asked:
welcome 123
  • 2
1 Solution
 
mikeopoloCommented:
What is the tool? Is there a settings or parameters screen where you can choose different options?
0
 
Bill PrewCommented:
Agreed, first choice would be to see if the tool has an "append" setting for the output file.

If not, then one way to work around this would be to rename the prior file (save it) before running the next export, and then use a BAT command or VBS script to merge the two files back together, combining the prior history with the new exported data.

~bp
0
 
welcome 123Author Commented:
yes the tool has no option.

Also can you help me with the vbs script on merging the two files please?
0
 
Bill PrewCommented:
Sure, happy to help.  Can you describe a little bit more how the process works?  How do you run the tool each time, it it via a BAT file, or some other method?  What folder does the output file exist in, and what is it named?  Any other details that might be useful?

~bp
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now