Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

PHP Multiple Pipe Special Character Issue

Posted on 2008-06-10
1
Medium Priority
?
359 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
Make the most of your online learning experience.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Introduction to Processes

927 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