Solved

PHP Multiple Pipe Special Character Issue

Posted on 2008-06-10
1
348 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now