Deleting Lines

[aslani]

I've been searching the forums for 2 days now and I can't seem to find what I'm looking for. So here's my problem.

I have a spreadsheet in Excel that looks like this:

Line#,PartNumber,,OldRev,NewRev,Type,Description,,,,,,Date,,,

After converting it to comma delimited .csv file.

Now my script opens that file and run StringSplit() and save it into a temporary .txt file. It is now looks like this;

NumberOfSplits
Line#
PartNumber

OldRev
NewRev
Type
Description





Date

I'm trying to get rid of the blank lines and I can't seems to find the right script to do it. I know it can't be that complicated, I might just be overlooking something.

Any advice?

[PsaltyDS]

After the StringSplit() do this to clean out empty lines in the resulting array:

For $n = Ubound($YourArray) - 1 To 1 Step -1
      If StringStripWS($YourArray[$n], 8) = "" Then _ArrayDelete($YourArray, $n)
Next
$YourArray[0] = Ubound($YourArray) - 1

_ArrayDelete() is in the array.au3 UDF

Edit: Forgot the "Step -1"

Edited September 14, 2007 by PsaltyDS

[aslani]

Thanks for the fast reply.

Here's a follow up question.

Is the cleaned array saved into $YourArray?

So if I do something like;

$datas = ""
For $element In $YourArray
$datas = $datas & $element & @CRLF
Next

$file = FileOpen(@ScriptDir & "\ecotmp.txt", 2)
FileWrite(@ScriptDir & "\tmp.txt", "" & $datas)
FileClose($file)

The tmp.txt will have the cleaned version?

EDIT: Ok, nvm. It works. tyty

Edited September 14, 2007 by aslani