i'm trying to extract values from a raw data file, when the file is opened it is put into 1 long line. there are 2 delimiters, one is the "|" character and another one is the carriage return which is presented in ascii code and if i'm not mistaken its represented as chr(13) in vb code. i am using the strAryWords=Split(strValue,"|") and extracting values within each delimiters by updating the content of the array to an access table. can i use split(strvalue,"|" or chr(13))?
really appreciate if anyone have an idea on how to do this. been stuck with this for 2 weeks.