python - Problem in spliting columns in a row if it contains semicolon and double quote in text -


i want import few rows csv file. problem there few columns contain semicolon , double quote in middle of text.

and since delimeter ; , csv quote ", splits columns sees ; , " in middle of text.

my sample csv file :

"hello";"<span onmouseup="__dopostback('bb','')">;</span> <span onmouseup="__dopostback('j','')" style="display: none" enabled="true"> ";"bye"

the code read rows are:

csv.reader((line.replace('\0','') line in f) , delimiter=';',quotechar = '"')    row in reader:      print row    , prints ;['hello', "<span onmouseup=__dopostback('bb','')>", '</span> <span onmouseup="__dopostback(\'j\',\'\')" style="display: none" enabled="true"> "', 'bye']

i want result :

 row[0] = hello  row[1] = <span onmouseup="__dopostback('bb','')">;</span> <span onmouseup="__dopostback('j','')" style="display: none" enabled="true">   row[2] = bye

wheras output is:

row[0] = hello  row[1] = <span onmouseup="__dopostback('bb','')">  row[2] = </span> <span onmouseup="__dopostback('j','')" style="display: none" enabled="true">   row[3] = bye

i have used code " reader = csv.reader(open("yourfile.csv", "rb"), delimiter=';') " defined in python split function, still code splits rows 4.

any appreciated.

thank you..

i think have problem input format, not proper csv:

quoted wikipedia:

fields contain special character (comma, newline, or double quote), must enclosed in double quotes. [...] if field's value contains double quote character escaped placing double quote character next it

it seems input file misses out on escaping double quotes.

that said, if cannot input, have come kind of pattern in data allow fix file before passing cvs.reader, or have parse manually according said patterns. can complex quickly.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more