Solved

PHP Multiple Pipe Special Character Issue

Posted on 2008-06-10
1
350 Views
Last Modified: 2013-11-13
Hi I am having trouble with the special character pipe (vertical bar or | ).

Currently I have a program that can takes a text file and parses out the data from CSV format into a Microsoft SQL database. When submitting the file, it has no issues except when multiple pipes ( ||| ) are being used  back to back in one of the text fields. This text field needs to use these pipes as it is being exported out of another program.

Example:
Text File states: 202000|||
Database states: 202000+|

Or

Text File States: 202000||
Database StateS: 202000+

Or with one pipe ( | ) it works...

Text File States: 202000|
Database States: 202000|

I am unsure where to start with this, but the pipes need to be correctly inserted in the database and when I use a select statement, I will need to be able to pull multiple pipes out of the database as well.....
0
Comment
Question by:robertarmbrister
1 Comment
 

Accepted Solution

by:
robertarmbrister earned 0 total points
ID: 21759447
Decided to change to '~' instead of pipes and does not look to have issues.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
migration MS SQL database to Oracle 30 59
SQL Server tables join on parse list 6 22
Cygwin - GNU GPL License 1 23
transaction in asp.net, sql server 6 31
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question