1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. To combat forum spam, we are temporarily disabling the ability to create new accounts for the forums. Please feel free to open a support ticket through out client area with any support issues. You can also search the forums for answers to many questions.

Using a "|" in a text field

Discussion in 'General Support' started by jabi, May 10, 2005.

Thread Status:
Not open for further replies.
  1. jabi

    jabi New Member

    Noticed with the flat file that if someone uses the pipe (|) character in a text field, that field is truncated at the pipe - presumably since this is your field delimeter. Haven't checked it in the mySql database.

    Since we can't control the data entry of all users, I would suggest that you add an error checking routine that either warns the user to replace the character, provide for an admin selected replacement character, or do an automatic replacement using another character (like * or ~ perhaps).

    Found this while trying to parse the database text file.
  2. Brian

    Brian EPC Developer Staff Member

    This was accounted for in Version 6.1.0. Are you experiencing this issue with this or a later version?
  3. jabi

    jabi New Member

    Sorry. Tested it on 6.014.
Thread Status:
Not open for further replies.

Share This Page