Tstudent Posted January 12, 2021 Share Posted January 12, 2021 Hello, i have a directory with about 50 .csv files. I want to delete last row for each of them. Can you suggest a script that automate this action? Is it possible? My best alternative is to do this manually one by one. Thank you Link to comment Share on other sites More sharing options...
Nine Posted January 12, 2021 Share Posted January 12, 2021 You can get a list of all .csv file using _FileListToArray. For each file, you can dump the content into an array with _FileReadToArray. Delete last row of the array with _ArrayDelete and rewrite the file with _FileWriteFromArray. A few line of code, not very complicated. Try this out and come back with your code if you face an issue. “They did not know it was impossible, so they did it” ― Mark Twain Spoiler Block all input without UAC Save/Retrieve Images to/from Text Monitor Management (VCP commands) Tool to search in text (au3) files Date Range Picker Virtual Desktop Manager Sudoku Game 2020 Overlapped Named Pipe IPC HotString 2.0 - Hot keys with string x64 Bitwise Operations Multi-keyboards HotKeySet Recursive Array Display Fast and simple WCD IPC Multiple Folders Selector Printer Manager GIF Animation (cached) Screen Scraping Multi-Threading Made Easy Link to comment Share on other sites More sharing options...
water Posted January 12, 2021 Share Posted January 12, 2021 Did you search the forum? There are a lot of threads discussing this issue. Example: Tstudent 1 My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
Tstudent Posted January 12, 2021 Author Share Posted January 12, 2021 Thanks this exmple helpd me. Found my solution Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now