Sponsored Content
Top Forums Shell Programming and Scripting Split file based on a column/field value Post 302914651 by SriniShoo on Wednesday 27th of August 2014 05:43:52 AM
Old 08-27-2014
Code:
awk -F ';' '$13 == "ASD" {print > ("ASD.txt"); next} {print > ("REST.txt")}' input_file

This User Gave Thanks to SriniShoo For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split file based on field

Hi I have a large file 2.6 million records and I am trying to split the file based on last column. I am doing awk -F"|" '{ print > $NF }' filename1 After around 1000 splits it gives me a error awk: can't open file 3332332423 input record number 1068, file filename1 source... (6 Replies)
Discussion started by: s_adu
6 Replies

2. Shell Programming and Scripting

split large file based on field criteria

I have a file containing date/time sorted data of the form ... 2009/06/10,20:59:59.950,XAG/USD,Q,1,1115, 14.3025,100,1,1 2009/06/10,20:59:59.950,XAG/USD,Q,1,1116, 14.3026,125,1,1 2009/06/10,20:59:59.950,XAG/USD,R,0,0, , 0,0,0 2009/06/10,20:59:59.950,XAG/USD,R,1,0, 14.1910,100,1,1... (6 Replies)
Discussion started by: asriva
6 Replies

3. Shell Programming and Scripting

Split large file based on last digit from a column

Hello, What's the best way to split a large into multiple files based on the last digit in the first column. input file: f 2738483300000x0y03772748378831x1y13478378358383x2y23743878383802x3y33787828282820x4y43748838383881x5y5 Desired Output: f0 3738483300000x0y03787828282820x4y4 f1... (9 Replies)
Discussion started by: alain.kazan
9 Replies

4. Shell Programming and Scripting

split the file based on the 2nd column passing as a parameter

I am unable to spit the file based on the 2nd column passing as a parameter with awk command. Source file: “100”,”customer information”,”10000” “200”,”customer information”,”50000” “300”,”product information”,”40000” script: the command is not allowing to pass the parameters with the awk... (7 Replies)
Discussion started by: number10
7 Replies

5. Shell Programming and Scripting

How to split a fixed width text file into several ones based on a column value?

Hi, I have a fixed width text file without any header row. One of the columns contains a date in YYYYMMDD format. If the original file contains 3 dates, I want my shell script to split the file into 3 small files with data for each date. I am a newbie and need help doing this. (14 Replies)
Discussion started by: bhanja_trinanja
14 Replies

6. Shell Programming and Scripting

Split a file into multiple files based on field value

Hi, I've one requirement. I have to split one comma delimited file into multiple files based on one of the column values. How can I achieve this Unix Here is the sample data. In this case I have split the files based on date column(c4) Input file c1,c2,c3,c4,c5... (1 Reply)
Discussion started by: manasvi24
1 Replies

7. Shell Programming and Scripting

How to split file into multiple files using awk based on 1 field in the file?

Good day all I need some helps, say that I have data like below, each field separated by a tab DATE NAME ADDRESS 15/7/2012 LX a.b.c 15/7/2012 LX1 a.b.c 16/7/2012 AB a.b.c 16/7/2012 AB2 a.b.c 15/7/2012 LX2 a.b.c... (2 Replies)
Discussion started by: alexyyw
2 Replies

8. Shell Programming and Scripting

Split the file based on column

Hi, I have a file sample_1.txt (300k rows) which has data like below: * Also each record is around 64k bytes 11|1|abc|102553|125589|64k bytes of data 10|2|def|123452|123356|...... 13|2|geh|144351|121123|... 25|4|fgh|165250|118890|.. 14|1|abc|186149|116657|......... (6 Replies)
Discussion started by: sol_nov
6 Replies

9. UNIX for Dummies Questions & Answers

Split file based on column

i have file1.txt asdas|csada|130310|0423|A1|canberra sdasd|sfdsf|130426|2328|A1|sydney Expected output : on eaceh third and fourth colum, split into each two characters asdas|csada|13|03|10|04|23|A1|canberra sdasd|sfdsf|13|04|26|23|28|A1|sydney (10 Replies)
Discussion started by: radius
10 Replies

10. Shell Programming and Scripting

To Split the file based on column value

Hi Team, I have a requirement in such a way that need to split the file into two based on which column particular value appears.Please find my sample file below. Lets consider the delimiter of this file as either comma or two colons.(:: and ,). So I need to split the file in such a way that all... (2 Replies)
Discussion started by: ginrkf
2 Replies
RT::Client::REST::Exception(3pm)			User Contributed Perl Documentation			  RT::Client::REST::Exception(3pm)

NAME
RT::Client::REST::Exception -- exceptions thrown by RT::Client::REST methods. DESCRIPTION
These are exceptions that are thrown by various RT::Client::REST methods. EXCEPTION HIERARCHY
RT::Client::REST::Exception This exception is virtual -- it is never thrown. It is used to group all the exceptions in this category. RT::Client::REST::OddNumberOfArgumentsException This means that the method you called wants key-value pairs. RT::Client::REST::InvaildObjectTypeException Thrown when you specify an invalid type to "show()", "edit()", or "search()" methods. RT::Client::REST::RequiredAttributeUnsetException An operation failed because a required attribute was not set in the object. RT::Client::REST::MalformedRTResponseException RT server sent response that we cannot parse. This may very well mean a bug in this client, so if you get this exception, some debug information mailed to the author would be appreciated. RT::Client::REST::InvalidParameterValueException Invalid value for comments, link types, object IDs, etc. RT::Client::REST::CannotReadAttachmentException Cannot read attachment (thrown from methods "comment()" and "correspond"). RT::Client::REST::RTException This is a virtual exception and is never thrown. It is used to group exceptions thrown because RT server returns an error. RT::Client::REST::ObjectNotFoundException One or more of the specified objects was not found. RT::Client::REST::AuthenticationFailureException Incorrect username or password. RT::Client::REST::UpdateException This is a virtual exception. It is used to group exceptions thrown when RT server returns an error trying to update an object. RT::Client::REST::CouldNotSetAttributeException For one or another reason, attribute could not be updated with the new value. RT::Client::REST::InvalidEmailAddressException Invalid e-mail address specified. RT::Client::REST::AlreadyCurrentValueException The attribute you are trying to update already has this value. I do not know why RT insists on treating this as an exception, but since it does so, so should the client. You can probably safely catch and throw away this exception in your code. RT::Client::REST::ImmutableFieldException Trying to update an immutable field (such as "last_updated", for example). RT::Client::REST::IllegalValueException Illegal value for attribute was specified. RT::Client::REST::UnknownCustomFieldException Unknown custom field was specified in the request. RT::Client::REST::InvalidQueryException Server could not parse the search query. RT::Client::REST::UnauthorizedActionException You are not authorized to perform this action. RT::Client::REST::AlreadyTicketOwnerException The owner you are trying to assign to a ticket is already the owner. This exception is usually thrown by methods "take()", "untake", and "steal", if the operation is a noop. RT::Client::REST::RequestTimedOutException Request timed out. RT::Client::REST::UnknownRTException Some other RT exception that the driver cannot recognize. METHODS
_get_exception_class Figure out exception class based on content returned by RT. _rt_content_to_exception Translate error string returned by RT server into an exception object ready to be thrown. SEE ALSO
Exception::Class, RT::Client::REST. AUTHOR
Dmitri Tikhonov <dtikhonov@yahoo.com> perl v5.14.2 2011-12-27 RT::Client::REST::Exception(3pm)
All times are GMT -4. The time now is 03:54 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy