Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Parsing a clunky file

by Jim (Curate)
on Mar 14, 2014 at 23:42 UTC ( #1078404=note: print w/replies, xml ) Need Help??


in reply to Parsing a clunky file

This really strikes me as an XY Problem. You don't want to have to grapple with the output of a simple SQL SELECT query in this "clunky" format unless you absolutely have to. And it doesn't seem like you have to because you admitted you could rerun the query this weekend. So rerun it and change the output format to CSV (comma-separated-value) or TSV (tab-separated-value). Problem solved.

Save your mad skillz for an occasion when your boss has gone to everyone else and been told "It's impossible." Querying data from an Oracle database in an immediately useable form is hardly impossible.

Jim

Replies are listed 'Best First'.
Re^2: Parsing a clunky file
by SamCG (Hermit) on Mar 17, 2014 at 20:55 UTC
    Thank you, I think you're right. (and FWIW, it's not the querying part that people are going to say is difficult, it's the next steps. but I already have ideas on how perl will help me with that.)



    -----------------
    s''limp';@p=split '!','n!h!p!';s,m,s,;$s=y;$c=slice @p1;so brutally;d;$n=reverse;$c=$s**$#p;print(''.$c^chop($n))while($c/=$#p)>=1;

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1078404]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (5)
As of 2022-05-24 12:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (82 votes). Check out past polls.

    Notices?