Hi Guys,
I have a csv file with the following format that I'm trying to parse:
"Column1","Column2","Column3",etc...
Everything is ok, except that sometimes, a comma will show up in one of the columns as:
"text, more text","Column2","Column 3",etc...
so a split on {','} will not work all the times. To make matters worst, sometimes the column has a \r\n in the middle as:
"text
more text","column2","column3".
This is actually a log file, over which I have no control, so I can not change the logging format, column delimiters, nothing.
Now, I can very well live w/o the commas and \r\n if i can remove them somehow. Up until now this seems to be the only 2 'bad' issues. The commas, and the \r\n.
Any ideas on dealing with this file?
1 909
Hi,
Is there any way to differentiate between between Column and other text?
I think the columnNames should be enclosed within double quotes like
"Column1","Column2". So that you can get rid of {,} and /r/n issue and even then split function will not work , you have write some lines of code for that.
Hi Guys,
I have a csv file with the following format that I'm trying to parse:
"Column1","Column2","Column3",etc...
Everything is ok, except that sometimes, a comma will show up in one of the columns as:
"text, more text","Column2","Column 3",etc...
so a split on {','} will not work all the times. To make matters worst, sometimes the column has a \r\n in the middle as:
"text
more text","column2","column3".
This is actually a log file, over which I have no control, so I can not change the logging format, column delimiters, nothing.
Now, I can very well live w/o the commas and \r\n if i can remove them somehow. Up until now this seems to be the only 2 'bad' issues. The commas, and the \r\n.
Any ideas on dealing with this file?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Oxmard |
last post by:
Armed with my new O'Reilly book Optimizing Oracle Performance I have been
trying to get a better understanding of how Oracle works.
The book makes the statement, " A database cal with dep=n + 1...
|
by: Cigdem |
last post by:
Hello,
I am trying to parse the XML files that the user selects(XML files are
on anoher OS400 system called "wkdis3"). But i am permenantly getting
that error:
Directory0: \\wkdis3\ROOT\home...
|
by: H |
last post by:
Now, I'm here with another newbie question ....
I want to read a text file, string by string (to do some things with some
words etc etc), but I can't seem to find a way to do this String by...
|
by: Ørjan Langbakk |
last post by:
I wanna make a file that holds the complete pricelist for a small
webshop (yes, I know that a database in the background would be a lot
simpler, but that is not an option today, unfortunately).
...
|
by: comp.lang.tcl |
last post by:
My TCL proc, XML_GET_ALL_ELEMENT_ATTRS, is supposed to convert an XML
file into a TCL list as follows:
attr1 {val1} attr2 {val2} ... attrN {valN}
This is the TCL code that does this:
set...
|
by: baskarpr |
last post by:
Hi all,
I my program after parsing in SAX parser, I want to write the parse result as an XML file. I want to ensure that there should be no difference between source XML file and parse result xml...
|
by: bmichel |
last post by:
Hey,
What I'm doing is the following:
- Load XML data a file
- Parsing the XML data
- Printing some parsed content
The problem is that the script execution is stopping before all the...
|
by: AdrianH |
last post by:
Assumptions
I am assuming that you know or are capable of looking up the functions I am to describe here and have some remedial understanding of C++ programming.
FYI
Although I have called...
|
by: AdrianH |
last post by:
Assumptions
I am assuming that you know or are capable of looking up the functions I am to describe here and have some remedial understanding of C programming.
FYI
Although I have called this...
|
by: souravmallik |
last post by:
Hello,
I'm facing a big logical problem while writing a parser in VC++ using C.
I have to parse a file in a chunk of bytes in a round robin fashion.
Means, when I select a file, the parser...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |