Sponsored Content
Top Forums Shell Programming and Scripting ksh coding to extract records from file Post 302487589 by Grueben on Thursday 13th of January 2011 02:06:54 AM
Old 01-13-2011
File info

The file looks like:

awky8888888888888888888888888888888888888888888888888888888888888888888888888888
88888888888888888888888888888888888
awky8888888888888888888888888888888888888888888888888888888888888888888888888888
awky88888888888888888888888888
888888888888888888888888888888
888888888888888888888888888888
888888888888888888888888888888
888888888888888888888888888888
888888888888888888888888888888
888888888888888

Cheers
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extract set of matching records

i have a pipe delimited file with records spread in many lines. i need to extract those records 1)having X in beginning of that record 2)and having at least one Y in beginning before other record begins eg: X|Rec1| A|Rec1| Y|Rec1| X|Rec2| Y|Rec2| Z|Rec3| X|Rec4| M|Rec4| ... (4 Replies)
Discussion started by: finder255
4 Replies

2. Shell Programming and Scripting

Extract data from large file 80+ million records

Hello, I have got one file with more than 120+ million records(35 GB in size). I have to extract some relevant data from file based on some parameter and generate other output file. What will be the besat and fastest way to extract the ne file. sample file format :--... (2 Replies)
Discussion started by: learner16s
2 Replies

3. Shell Programming and Scripting

KSH to group records in a file and compare it with another file

Hi, I've a file like below: DeptFile.csv DeptID EmpID ------- ------ Dep01 Emp01 Dep01 Emp02 Dep01 Emp03 Dep02 Emp04 Dep02 Emp05 I've another file which has EmpFile.csv EmpID Salary ------ ------ (3 Replies)
Discussion started by: Matrix2682
3 Replies

4. UNIX for Dummies Questions & Answers

Extract records by column value - file non-delimited

the data in my file is has no delimiters. it looks like this: H52082320024740010PH333200612290000930 0.0020080131 D5208232002474000120070306200703060580T1502 TT 1.00 H52082320029180003PH333200702150001 30 100.0020080205 D5208232002918000120070726200707260580T1502 ... (3 Replies)
Discussion started by: jclanc8
3 Replies

5. Shell Programming and Scripting

Extract CSV records using NAWK?

Example CSV: $ cat myfile HDR COL_A,COL_B,COL_C X,Y,Z Z,Y,X ... X,W,Z In this example, I know that column names are on the second line. I also know that I would like to print lines where COL_A="X" and COL_C="Z". In this simple example, I know that COL_A = $1 and COL_C = $3, and hence... (6 Replies)
Discussion started by: cs03dmj
6 Replies

6. Shell Programming and Scripting

Extract file records based on some field conditions

Hello Friends, I have a file(InputFile.csv) with the following columns(the columns are pipe-delimited): ColA|ColB|ColC|ColD|ColE|ColF Now for this file, I have to get those records which fulfil the following condition: If "ColB" is NOT NULL and "ColD" has values one of the following... (9 Replies)
Discussion started by: mehimadri
9 Replies

7. Shell Programming and Scripting

Extract error records based on specific criteria from Unix file

Hi, I look for a awk one liner for below issue. input file ABC 1234 abc 12345 ABC 4567 678 XYZ xyz ght 678 ABC 787 yyuu ABC 789 7890 777 zxr hyip hyu mno uii 678 776 ABC ty7 888 All lines should be started with ABC as first field. If a record has another value for 1st... (7 Replies)
Discussion started by: ratheesh2011
7 Replies

8. Shell Programming and Scripting

Extract records from list

Hi Gents, I have a file 1 like this 1 1000 20 2 2000 30 3 1000 40 5 1000 50 And I have other file 1 like 2 1 I would like to get from the file 1 the complete line which are in file 2, the key to compare is the column 2 then output should be. 2 2000 30. I was trying to get it... (5 Replies)
Discussion started by: jiam912
5 Replies

9. Shell Programming and Scripting

Extract UNIque records from File

Hi, I have a file with 20GB Pipe Delimited file where i have too many duplicate records. I need an awk script to extract the unique records from the file and put it into another file. Kindly help. Thanks, Arun (1 Reply)
Discussion started by: Arun Mishra
1 Replies

10. Shell Programming and Scripting

Extract records from Oracle to UNIX file with headers

Hi, I have a shell script which extracts records form oracle to unix file. sqlplus -s ${WMD_DM_CONNECT} <<EOF >$tmpfile set heading off set pagesize 0 set feedback off select CD_DESC||'|'||CD_ID||'|'||'Arun'||'|'||'Montu' from WMD_SYS_CD_LKUP where CD_TYP =... (5 Replies)
Discussion started by: Arun Mishra
5 Replies
Kwiki(3pm)						User Contributed Perl Documentation						Kwiki(3pm)

NAME
Kwiki - The Kwiki Wiki Building Framework KWIKI 2.0 STOP. Don't install this CPAN module! Read this section to find out why... Kwiki-0.38 and the large collection of Kwiki CPAN modules has been relatively stable on CPAN for the last couple years. Being stable also means being undeveloped. In December 2006, the Kwiki community started actively developing Kwiki again. We call the revitalized project Kwiki 2.0. This is not a version number (at least not yet), but a code name for the effort. Some goals of Kwiki 2.0 are: * Make Kwiki easier to install and maintain * Make Kwiki fast * Make Kwiki plugins easier to develop * Make Kwiki more fun We've made a lot of headway on these goals and other goals too. Kwiki is *really* simple to install now. _All_ the Perl dependencies come with Kwiki, and are /preinstalled/. This means you just need Perl 5.8.3 and a web server. Well actually we give you a web server too! NOTE: /Preinstalled/ means that the modules are all linked into a lib tree that is separate from your installed Perl modules. This is good for several reasons: 1) Installing modules takes a lot of time. 2) Kwiki is guaranteed to have module versions that work. 3) Kwiki doesn't change anything about your system's Perl lib. 4) You can delete all the modules by just deleting the Kwiki checkout. 5) Upgrading Kwiki is simple as 'svn update'! 6) You can install Kwiki without root permissions. Also Kwiki is now smoking fast if you use Kwiki::FastCGI. There are also some new caching modules that make Kwiki even faster still. The important part is this: all the new stuff is not yet on CPAN. If you want to install Kwiki, get it from our subversion repository (highly recommended) or tarball downloads. You will be amazed at how simple and fast it is to install the new Kwiki which comes with nearly 500 Perl modules. The longest part is simply checking out the repository. See <http://www.kwiki.org/?InstallingKwiki2> for details. Eventually all this work will make it back to CPAN, but likely not for a while. Here's a list of references for more information: * http://www.kwiki.org - Main Kwiki Site * http://www.kwiki.org/?KwikiNews - Kwiki News * http://svn.kwiki.org/kwiki/trunk/ - Kwiki SVN Repository * http://trac.kwiki.org/trac/timeline - Kwiki Project Management * #kwiki on irc.freenode.net - Kwiki IRC Channel * http://www.kwiki.org/downloads/ - Kwiki downloads * http://doolittle.kwiki.org/ - Kwiki Documentation Wiki Finally, there are generally a good amount of helpful people on IRC. Please drop by sometime! Cheers, Ingy Here's the old Kwiki.pm doc. It might be a little out of date... SYNOPSIS
> kwiki -new cgi-bin/my-kwiki Kwiki software installed! Point your browser at this location. NOTE
If you are impatient (don't worry, that's a good thing!) read Kwiki::Command to get the details on how to install and configure a new Kwiki wiki in record time. DESCRIPTION
A Wiki is a website that allows its users to add pages, and edit any existing pages. It is one of the most popular forms of web collaboration. If you are new to wiki, visit http://c2.com/cgi/wiki?WelcomeVisitors which is possibly the oldest wiki, and has lots of information about how wikis work. Kwiki is a Perl wiki implementation based on the Spoon application architecture and using the Spiffy object orientation model. The major goals of Kwiki are that it be easy to install, maintain and extend. All the features of a Kwiki wiki come from plugin modules. The base installation comes with the bare minimum plugins to make a working Kwiki. To make a really nice Kwiki installation you need to install additional plugins. Which plugins you pick is entirely up to you. Another goal of Kwiki is that every installation will be unique. When there are hundreds of plugins available, this will hopefully be the case. CGI
::Kwiki Kwiki is the successor of the popular CGI::Kwiki software. It is a complete refactoring of that code. The new code has a lovely plugin API and is much cleaner and extendable on all fronts. There is currently no automated way to upgrade a CGI::Kwiki installation to Kwiki. It's actually quite easy to do by hand. Instructions on how to do it are here: http://www.kwiki.org/?KwikiMigrationByHand DOCUMENTATION
All of the future Kwiki module documentation is being written at the http://doc.kwiki.org/ wiki. Check there for the latest doc, and help improve it. Each successive release of Kwiki will include the latest doc from that site. CREDITS
I am currently employed by Socialtext, Inc. They make high quality social software for enterprise deployment. Socialtext has a bold new vision of building their products over Open Source software and returning the generic source code to the community. This results in a win/win effect for both entities. You get this shiny new wiki framework, and Socialtext can take advantage of your plugins and bug fixes. The Kwiki project would not be where it is now without their support. I thank them. Of particular note, Dave Rolsky and Chris Dent are two current Socialtext employees that have made significant contributions to Kwiki. --- Iain Truskett was probably the most active Kwiki community hacker before his untimely death in December 2003. The underlying foundation of Kwiki has been named "Spoon" in his honor. Rest in peace Spoon. --- Ian (what's with all these Iai?ns??) Langworth has become a new Kwiki warrior. He helped a lot with the maiden release. Expect a lot of plugins to come from him! Thanks Ian. --- Finally, big props to all the folks on http://www.kwiki.org and irc://irc.freenode.net/#kwiki. Thanks for all the support! SEE ALSO
Kwiki::Command AUTHOR
Ingy dA~Xt Net <ingy@cpan.org> COPYRIGHT
Copyright (c) 2004. Brian Ingerson. All rights reserved. Copyright (c) 2007. Ingy dA~Xt Net. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See http://www.perl.com/perl/misc/Artistic.html perl v5.12.4 2007-03-06 Kwiki(3pm)
All times are GMT -4. The time now is 03:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy