Flutterby™! : SOAP gone wrong

SOAP gone wrong

2012-04-27 21:18:06.709319+00 by Dan Lyke 4 comments

Awesome: "We have an employee whose last name is Null. He kills our employee lookup app when his last name is used as the search term (which happens to be quite often now)."

Little Bobby Tables in real life.

[ related topics: Work, productivity and environment Furniture ]

comments in ascending chronological order (reverse):

#Comment Re: made: 2012-04-27 21:44:45.165588+00 by: meuon [edit history]

I'm having issues parsing 1999 version of Sybase SQL exported CSV, I thought I could just use Perl's: Text::CSV but that would be too easy, it's barfing on strings like:

1234,'M. "Meuon" Geek','N° 4 Coutoun, Apt 2',Benin,1024/2044

I either regex/replace/escape all the exceptions, or just manually parse the whole thing. It seems every time I try to use a library/toolset that is supposed to make such things easier, I get frustrated and build my own.

#Comment Re: made: 2012-04-28 01:59:08.553954+00 by: John Anderson

Meuon, I can get Text::CSV to parse that as long as as I include the 'allow_loose_escapes' option when calling the constructor, like so:

my $csv = Text::CSV->new({ binary => 1 , allow_loose_escapes => 1 });

Hopefully that helps you avoid re-inventing this particular wheel.

#Comment Re: made: 2012-04-28 03:33:06.141288+00 by: ebradway

Is Null's first name Devon?

#Comment Re: made: 2012-04-28 14:00:11.635562+00 by: meuon

John, Thank you. That helped, I had loose quotes, but not loose escapes. The rest of the oddities I'm removing with regex's. 12+ years of sticking French W. African data into a database that didn't really support it well creates cruft. At least it's not from an old Oracle system,