And once I DID get a file delimited with "|". Nasty to handle.

Jim, I think a 'line delimited file' in this case is a file with each field on a separate line. If I'm right, then Bruce's method looks like the easiest way of separating out the fields.

One problem I ran into, is that if the LAST field/line is empty it may not be entered into the file as a blank line. Paul, if there is ANY way of checking the first field/line for every record, be sure you add this to the loop.

HTH
Barbara

>Every time I even think about the different ways I've seen files delimited I just wanna crawl into my cave and sit and make shadow puppets on the wall from the firelight......(shudder). So I don't even want to imagine a "line delimited" file....unless they (whoever they are) mean the '|'?
>
>
>
>>Dorris,
>>
>>That's the way I remember it too.
>>
>>But a wonder what a "line delimited text file" is?? I suppose SDF is a good guess, but who can say for sure?
>>
>>Cheers,
>>Jim N
>>
>>>>I do the same way but isn't it "DELIMITED" or "WITH dilimiter" instead of "SDF"?
>>>
>>>If I'm remembering correctly ('cuz I'm too lazy to look it up)
>>>
>>>Append from filename DELIMITED means there is a a CR/LF at the end of each line and a (default) comma between field items.
>>>
>>>Append from filename TYPE SDF means that the file is a flat ASCII file laid out with a fixed length with a CR/LF at the end of each line.