I am importing text files into a database.
These text files have a row delimiter of CR (or possible CR/LF)
What I want to do is import the text files into a table, count the number of rows imported, then I want to run a DOS command to count the number of CR's in the text file.... in theory they should match.
I can't work out how to use FIND or FINDSTR to search for a CR and/or CRLF in a file. If I could then I could use these to return the count of CR's
I've tried \n and that doesn't work