End of Line and Carriage Return

Hey guys,

I am reading data from a .csv file into a text box. In the textbox columns are seperated by commas but the rows are seperated by a character that I do not recognize-it looks like two pipe symbols "||". I think it may be a carriage return or end of line symbol. I want to search this string for a particular instance of this character but I don't even know what the char is and I can't copy and paste it from my text box to my Instr() function as it only advances the cursor to the next line when I do. Does any one know what the correct syntax for this character?

 

Thank you all for you help the soloution for this problem is to use vbCrLf as the search criteria in the following statement:

CustomerCodeStartPosition = InStr(CustomerAR, vbCrLf)

This will search CustomerAR for instances of carriage return and line feed (which seperates rows within the .csv file) and return its position.