Does anyone know how i can get rid of emtpy lines in a text file:
I thought this might work - it doesn't :(
welcome any suggestions
k

=STRTOFILE(CHRTRAN(FILETOSTR("c:\mydir\m.txt"),CHR(13)+"  ",' '),"c:\mydir\m.txt")

original text:
line 1 of text
line 2 of text


line 3 of text

line 5 of text

i would like converted to
line 1 of text
line 2 of text
line 3 of text
line 5 of text