writing in a specific row/deleting a row

[Reuben Cabrera]

is there a way to delete a row, I have read a post in this group regarding how to delete or perhaps update a file however i do not understand how it works. it seems that write always enters a new record on a new line.

[shriop]

CSV is a simple structured file lacking more complex features like deleting single rows. To delete a row, you have to instead read in every row from the file, writing each row back out to a new file, except the one that you're wanting to effectively delete. When you're done, you can delete the original file and rename the new file to the name of the original file.

Bruce Dunwiddie

[Reuben Cabrera]

writing to a new file and renaming the file. is this done manually?

[shriop]

Programmers would normally write code to do this, but they would have to write out a few lines of code.

Bruce Dunwiddie