End line char

[John Yazou]

Hi,
Wondering.. I have this statement in VBA, InStr(strTemp, ",") + 1.. what should I change in the "," part to find the end-of-line character??

 

[Mark O'Brien]

I guess the end of line character is "carriage return". In which case, substitute "," with:<pre>
Chr(13)</pre>

Hope this is what you want.
This message was edited by Mark O'Brien on 2002-03-21 19:43
This message was edited by Mark O'Brien on 2002-03-21 19:43

 

[Juan Pablo González]

If you're looking for the position of the last character, use Len(String)