Sponsored Content
Top Forums UNIX for Advanced & Expert Users Help in Deleting columns and Renaming Mutliple columns in a .Csv File Post 302610397 by mahi_mayu069 on Wednesday 21st of March 2012 08:11:09 AM
Old 03-21-2012
@Scrutinizer:- Thanks a ton, Its working great....
I had some environmantal set up issues, hence couldn't excecuted the peice of code.

@SolarMax:- Thank you muchSmilie your code works fine now.

Thanks again, you guys really rock!!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Deleting specific columns from a file

Hi Friends, I want to delete specific columns from a file. Say my file content is as follows: "1","a","ww1",1234" "2","b","wwr3","2222" "3","c","erre","3333" Now i want to delete the column 2 and 4 from this file. That is I want the file content to be: "1","ww1" "2","wwr3"... (11 Replies)
Discussion started by: premar
11 Replies

2. Shell Programming and Scripting

deleting rows & columns form a csv file

Hi , I want to delete some rows & columns from file. can someone please help me on this? Regards. (2 Replies)
Discussion started by: code19
2 Replies

3. Shell Programming and Scripting

no of columns in csv file

Hi, I would like to know how can I find the number of columns in each line in a csv file. I have a csv file wiht comma separated an dhas 10000 line in it. I want to verify the number of columns in each line. is there any way to find it out using awk or any other commands? Thanks.... (2 Replies)
Discussion started by: McLan
2 Replies

4. Shell Programming and Scripting

Deleting columns from CSV file

Hi All, Am working on perl script which should delete columns in existing CSV file. If my file is : AA,BB,CC,DD 00,11,22,33 00,55,66,77 00,99,88,21 AA,BB... are all my headers can come in any order (e.g AA,CC,BB...) and rest are values. I want to delete column CC... Can anybody help... (2 Replies)
Discussion started by: darshakraut
2 Replies

5. Shell Programming and Scripting

Deleting columns by list or file

Dear specialists out there, please help a poor awk newbie: I have a very huge file to process consisting of 300000 columns and 1500 rows. About 20000 columns shall be deleted from that file. So it is clear, that I can't do this by writing down all the columns in an awk command like $1, $x etc.... (5 Replies)
Discussion started by: flxms
5 Replies

6. UNIX for Advanced & Expert Users

Unix Bash: substitute columns in .csv using other .csv columns

Hi All, I have two .csv's input.csv having values as (7 columns) ABC,A19907103,ABC DEV YUNG,2.17,1000,2157,07/07/2006 XYZ,H00213850,MM TRUP HILL,38.38,580,23308,31/08/2010 output.csv having (25 columns) A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y... (4 Replies)
Discussion started by: abhivyas
4 Replies

7. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies

8. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies

9. Shell Programming and Scripting

Match columns from two csv files and update field in one of the csv file

Hi, I have a file of csv data, which looks like this: file1: 1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628 2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies

10. UNIX for Advanced & Expert Users

Replace columns in .csv using other .csv columns

Hi, I have 2 csv files with 15 000 lines, which looks like this: Daily.csv "CODE","BRAND","DESIGNER","SIZE","TYPE","GENDER","SET","DESCRIPTION","IMAGE","COST","WEIGHT","MSRP","UPC" "M-1001","212","Caroline Her","1.7 oz","EDT... (4 Replies)
Discussion started by: olivieraz
4 Replies
Ouch(3pm)						User Contributed Perl Documentation						 Ouch(3pm)

NAME
Ouch - Exceptions that don't hurt. VERSION
version 0.0401 SYNOPSIS
use Ouch; eval { ouch(404, 'File not found.'); }; if (kiss 404) { check_elsewhere(); } say $@; # These two lines do the say $@->scalar; # same thing. DESCRIPTION
Ouch provides a class for exception handling that doesn't require a lot of boilerplate, nor any up front definition. If Exception::Class is working for you, great! But if you want something that is faster, easier to use, requires less typing, and has no prereqs, but still gives you much of that same functionality, then Ouch is for you. Why another exception handling module? It really comes down to Carp isn't enough for me, and Exception::Class does what I want but makes me type way too much. Also, I tend to work on a lot of protocol-based systems that use error codes (HTTP, FTP, SMTP, JSON-RPC) rather than error classes, so that feels more natural to me. Consider the difference between these: Ouch use Ouch; ouch 404, 'File not found.', 'file'; Exception::Class use Exception::Class ( 'FileNotFound' => { fields => [ 'code', 'field' ], }, ); FileNotFound->throw( error => 'File not found.', code => 404, field => 'file' ); And if you want to catch the exception you're looking at: Ouch if (kiss 404) { # do something } Exception::Class my $e; if ($e = Exception::Class->caught('FileNotFound')) { # do something } Those differences may not seem like a lot, but over any substantial program with lots of exceptions it can become a big deal. Usage Most of the time, all you need to do is: ouch $code, $message, $data; ouch -32700, 'Parse error.', $request; # JSON-RPC 2.0 error ouch 441, 'You need to specify an email address.', 'email'; # form processing error ouch 'missing_param', 'You need to specify an email address.', 'email'; You can also go long form if you prefer: die Ouch->new($code, $message, $data); Functional Interface ouch Some nice sugar instead of using the object oriented interface. ouch 2121, 'Did not do the big thing.'; code An error code. An integer or string representing error type. Try to stick to codes used in whatever domain you happen to be working in. HTTP Status codes. JSON-RPC error codes, etc. message A human readable error message. data Optional. Anything you want to attach to the exception to help a developer catching it decide what to do. For example, if you're doing form processing, you might want this to be the name of the field that caused the exception. WARNING: Do not include objects or code refs in your data. This should only be stuff that is easily serializable like scalars, array refs, and hash refs. kiss Some nice sugar to trap an Ouch. if (kiss $code) { # make it go } code The code you're looking for. exception Optional. If you like you can pass the exception into "kiss". If not, it will just use whatever is in $@. You might want to do this if you've saved the exception before running another "eval", for example. hug Some nice sugar to trap any exception. if (hug) { # make it stop } exception Optional. If you like you can pass the exception into "hug". If not, it will just use whatever is in $@. bleep A little sugar to make exceptions human friendly. Returns a clean error message from any exception, including an Ouch. File not found. Rather than: File not found. at /Some/File.pm line 63. exception Optional. If you like you can pass the exception into "bleep". If not, it will just use whatever is in $@. Calls "bleep", and then exits with error code exception Optional. You can pass an exception into "barf" which then gets passed to "bleep" otherwise it will use whatever's in $@ Object-Oriented Interface new Constructor for the object-oriented interface. Takes the same parameters as "ouch". Ouch->new($code, $message, $data); scalar Returns the scalar form of the error message: Crap! at /Some/File.pm line 43. Just as if you had done: die 'Crap!'; Rather than: ouch $code, 'Crap!'; trace Call this if you want the full stack trace that lead up to the ouch. hashref Returns a formatted hash reference of the exception, which can be useful for handing off to a serializer like JSON. { code => $code, message => $message, data => $data, } code Returns the "code" passed into the constructor. message Returns the "messsage" passed into the constructor. data Returns the "data" passed into the constructor. Traditional Interface Some people just can't bring themselves to use the sugary cuteness of Ouch. For them there is the ":traditional" interface. Here's how it works: use Ouch qw(:traditional); my $e = try { throw 404, 'File not found.'; }; if ( catch 404, $e ) { # do the big thing } elsif ( catch_all $e ) { # make it stop } else { # make it go } NOTE: "try" also populates $@, and "catch" and "catch_all" will also use $@ if you don't specify an exception. try Returns an exception. Is basically just a nice wrapper around "eval". block Try accepts a code ref, anonymous subroutine, or a block. NOTE: You need a semi-colon at the end of a "try" block. throw Works exactly like "ouch". See "ouch" for details. catch Works exactly like "kiss". See "kiss" for details. catch_all Works exactly like "hug". See "hug" for details. Try::Tiny Many Ouch users, like to use Ouch with Try::Tiny, and some of them are sticks in the mud who can't bring themselves to "ouch" and "kiss", and don't like that ":traditional" walks all over "try" and "catch" For them, there is the ":trytiny" interface. Here's how it works: use Try::Tiny; use Ouch qw(:trytiny); try { throw(404, 'File not found!'; } catch { if (caught($_)) { # do something } else { throw($_); # rethrow } }; SUPPORT
Repository <http://github.com/rizen/Ouch> Bug Reports <http://github.com/rizen/Ouch/issues> SEE ALSO
If you're looking for something lighter, check out Carp that ships with Perl. Or if you're looking for something heavier check out Exception::Class. AUTHOR
JT Smith <jt_at_plainblack_dot_com> LEGAL
Ouch is Copyright 2011 Plain Black Corporation (<http://www.plainblack.com>) and is licensed under the same terms as Perl itself. perl v5.12.3 2011-04-30 Ouch(3pm)
All times are GMT -4. The time now is 02:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy