query assistance

[keilamym]

can someon please help.

I have text file that I need Autoit to open, and reformat.

Example

Opt("WinTitleMatchMode", 2)

Run("Notepad.exe Resource.csv", "", )

WinWaitActive("Resource","")

Send ("'" & "{END}" & "'" & "," & "{DEL}")

While this simple query works, I would like to only have it run for number of lines in the .txt file.

My question is how can I have autoit load the names into some environment and once its at the end, it will stop.

Example

user.user1

user.user2

user.user3

needs to look like

'user.user1','user.user2','user.user3' etc.

Any assistance would be appreciated.

Thank You

Lavelle

[DaleHohm]

You'll have much more control if you open the file directly with AutoIt instead of automating Notepad.

See the commands FileOpen, FileReadLine, FileWrite (or FileWriteLine) and FileClose.

Dale

can someon please help.

I have text file that I need Autoit to open, and reformat.

Example

Opt("WinTitleMatchMode", 2)

Run("Notepad.exe Resource.csv", "", )

WinWaitActive("Resource","")

Send ("'" & "{END}" & "'" & "," & "{DEL}")

While this simple query works, I would like to only have it run for number of lines in the .txt file.

My question is how can I have autoit load the names into some environment and once its at the end, it will stop.

Example

user.user1

user.user2

user.user3

needs to look like

'user.user1','user.user2','user.user3' etc.

Any assistance would be appreciated.

Thank You

Lavelle

<{POST_SNAPBACK}>

[keilamym]

Dale,

Thanks for your response. I've setup loops for directory reads and have it run commands in the past but never like this.

Are you saying that I need to read the file (FileRead, FileReadLine, or FileOpen) and if the line exist, then write the contents of that line along with my changes to a different file(FileWrite, or FileWriteLine)?

Thank You

Lavelle

[DaleHohm]

Yes, that is a simple approch. Open the existing file for read access, open a second with write access. Read in the lines from the read-only file one at a time, parse them and then write the desired output to the second file.

The help on FileReadLine has a nice example on how open and read a file line by line till you hit the end.

Dale

[keilamym]

Dale thanks for the input... While this is the test script, it works great.

$file = FileOpen("test.txt", 0)

$newfile = "saved.txt"

while 1

$line = FileReadLine($file)

if @error = -1 then ExitLoop

FileWrite($newfile,"'" & $line & "'" & ",")

WEnd

I'll just be going back and adding prompts for the file names I want to convert.

Thanks again

Lavelle

Edited August 16, 2005 by keilamym