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, new accounts will need to make at least one (valid) post.
    Otherwise, we will periodically purge all users without posts or that haven't confirmed their account.

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