Jump to content

Delete first line off CSV File


Recommended Posts

hey,

im trying to get a script, which reads paths out of a txt, then opens them and deletes the first line.

The files are csv files, so it was pretty weird

Could anyone help me? I need to finish this in 3 hours, would be realllly nice!

 

#include <file.au3>
#RequireAdmin
$l = _FileCountLines(@DesktopDir & "\dateien.txt")
MsgBox(0,"",$l)
for $i = 1 to $l
$l2 = FileReadLine(@DesktopDir & "\dateien.txt",$i)
MsGBOx(0,"t",$l2)
$l3 = StringReplace($l2,".csv",".txt")
MsGBox(0,"t",$l3)
$ab = StringSplit($l2,"\")
$ub = Ubound($ab)
MsGbox(0,"",$ub)
$ub2 = $ub - "1"
$ub3 = StringReplace($ab[$ub2],".csv","")
MsgBox(0,"",$ub3)
FileDelete($l2)
Run(@ComSpec&'\c ren '& $l2 & ' " ' & $ub3 )
_FileWriteToLine($l3,"1","",1)
Run(@ComSpec&'\c ren '& $l3 & ' " ' & $l2 )
Next

 

Link to comment
Share on other sites

  • Moderators

iCrypto,

This works for me:

#include <File.au3>

Local $aLines

$hFile = FileOpen("dateien.txt")

While 1

    $sPath = FileReadLine($hFile) ; This reads the next line on each pass
    If @error Then ExitLoop ; Stop when there are no more lines to read

    _FileReadToArray(@ScriptDir & "\" & $sPath, $aLines, $FRTA_NOCOUNT) ; Read file into an array

    _FileWriteFromArray(@ScriptDir & "\" & $sPath, $aLines, 1) ; Rewrite the file without the first line

WEnd

FileClose($hFile)

Please ask if you have any questions.

M23

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...