Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re^3: Help Sorting a CSV File

by erix (Prior)
on Oct 07, 2019 at 14:20 UTC ( [id://11107135]=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    psql -qX << SQL_TXT
    create server if not exists temp_fs foreign data wrapper file_fdw;
    ...
    );
    copy(select * from ft_pm2 order by 2, 3) to stdout with (format csv, h
    +eader true);
    SQL_TXT
    
  2. or download this
    CAT_HEADER,SUPPLIER_CODE,CUSTOMER_CODE,F4,F5,F6,F7,F8
    CAT_LINE,0001P,ABC12345,20190924,,1,Z,3.36
    ...
    CAT_LINE,0002P,ABC12345,20190924,,1,Z,4.26
    CAT_LINE,0002P,ABC23456,20190924,,1,Z,1.21
    CAT_LINE,0002P,ABC34567,20190924,,1,Z,22.24
    

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (2)
As of 2024-04-20 09:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found