thing like this, i would like to import text file data into access. The data content example like this: (example.txt)
ID | Name | Message | User
1 | Joe | This is a text, error message | admin
2 | Mary | No error message, ID number: 9182734 | normal-user
3 | Terry | This is a long text, long message. Product ID : 1234,
Tag ID : fhdj123, Please restart | admin
I use -Delimiter “|” as a separator, and it works well for ID 1 and ID 2, but when comes to ID 3, it will just read until “…product ID :1234,” then stop. After then, it start read new line from “Tag ID”. As you guys can see the “|” is not close at end of ID 3. I wonder how to read string with line break. Please help.