Sponsored Content
Top Forums Shell Programming and Scripting Extract data in tabular format from multiple files Post 302798703 by belalr on Thursday 25th of April 2013 04:35:30 AM
Old 04-25-2013
Extract data in tabular format from multiple files

Hi,

I have directory with multiple files from which i need to extract portion of specif lines and insert it in a new file, the new file will contain a separate columns for each file data.

Example:

I need to extract Value_1 & Value_3 from all files and insert in output file as below:

File 1 Content:
Code:
/2013/April/23 Value_1="10"
/2013/April/23 Value_2="20"
/2013/April/23 Value_3="30"

File 2 Content:
Code:
/2013/April/23 Value_1="40"
/2013/April/23 Value_2="50"
/2013/April/23 Value_3="60"

File 3 Content:
Code:
/2013/April/23 Value_1="70"
/2013/April/23 Value_2="80"
/2013/April/23 Value_3="90"

Required File output:
Code:
10,30
40,60
70,90


Can someone please advise how to achieve this? Thanks

Last edited by Franklin52; 04-25-2013 at 06:49 AM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Anyways to find sentences with data format and extract it???

Hi guys,i got this problem which is..i need to find those sentences with date inside and extract them out,the input is somehow like this eg: $DATA42.GANTRY2.GA161147 DISKFILE 2007-10-16 11:56:45 SUPER.OPR \NETS.$Y4CB.#IN ... (4 Replies)
Discussion started by: cyberray
4 Replies

2. Shell Programming and Scripting

extract specific data from xml format file.

Hi, I need to extract the start time value (bold, red font) under the '<LogEvent ID="Timer Start">' tag (black bold) from a file with the following pattern. There are other LogEventIDs listed in the file as well, making it harder for me to extract out the specific start time that I need. . .... (7 Replies)
Discussion started by: 60doses
7 Replies

3. UNIX for Dummies Questions & Answers

converting a tabular format data to comma seperated data in KSH

Hi, Could anyone help me in changing a tabular format output to comma seperated file pls in K-sh. Its very urgent. E.g : username empid ------------------------ sri 123 to username,empid sri,123 Thanks, Hema:confused: (2 Replies)
Discussion started by: Hemamalini
2 Replies

4. UNIX for Dummies Questions & Answers

AWK, extract data from multiple files

Hi, I'm using AWK to try to extract data from multiple files (*.txt). The script should look for a flag that occurs at a specific position in each file and it should return the data to the right of that flag. I should end up with one line for each file, each containing 3 columns:... (8 Replies)
Discussion started by: Liverpaul09
8 Replies

5. UNIX for Dummies Questions & Answers

Using AWK: Extract data from multiple files and output to multiple new files

Hi, I'd like to process multiple files. For example: file1.txt file2.txt file3.txt Each file contains several lines of data. I want to extract a piece of data and output it to a new file. file1.txt ----> newfile1.txt file2.txt ----> newfile2.txt file3.txt ----> newfile3.txt Here is... (3 Replies)
Discussion started by: Liverpaul09
3 Replies

6. UNIX for Dummies Questions & Answers

Extract common data out of multiple files

I am trying to extract common list of Organisms from different files For example I took 3 files and showed expected result. In real I have more than 1000 files. I am aware about the useful use of awk and grep but unaware in depth so need guidance regarding it. I want to use awk/ grep/ cut/... (7 Replies)
Discussion started by: macmath
7 Replies

7. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

8. Shell Programming and Scripting

Convert data to a tabular format

How can i convert the below data to a simpler format :- cat tabular.txt User 1 Details :- First Name = Tom Middle Name = Last Name = Hanks Age = 40 Address = User 2 details :- First Name = Mike Middle Name = Last Name = Tyson Age = 50 Address = (2 Replies)
Discussion started by: lazydev
2 Replies

9. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

10. Shell Programming and Scripting

Merge and Sort tabular data from different text files

I have 42 text files; each containing up to 34 lines with following structure; file1 H-01 23 H-03 5 H-05 9 H-02 14 . . file2 H-01 17 H-02 43 H-04 7 H-05 8 H-03 7 . . file3 (6 Replies)
Discussion started by: Syeda Sumayya
6 Replies
nomarch(1)							Archive Extraction							nomarch(1)

NAME
nomarch - extract `.arc' archives SYNOPSIS
nomarch [-hlptUv] [archive.arc] [match1 [match2 ... ]] DESCRIPTION
nomarch lists, extracts, or tests `.arc' archives. (An alternate extension sometimes used was `.ark'; these work too.) This is a very out- dated file format which should certainly not be used for anything new, but you may still need an extraction utility, and here it is. :-) The default action is to extract all files in the specified archive; see OPTIONS below for how to do other things instead. OPTIONS
-h give terse usage help. -l list files in archive. If verbose listings are enabled, it shows the filename, compression method, compressed/uncompressed size, date/time, and CRC; but by default, it just shows the filename, uncompressed size, and date/time. -p extract to standard output, rather than to separate files. -t test files in archive (more precisely, check file CRCs). -U use uppercase filenames; more precisely, preserve original case from archive. -v give verbose output (when used with `-l'). archive.arc the archive to operate on. match1 etc. optionally specify which archive members to list/extract/test. Those which match any of these filenames/wildcards are processed. Wildcard operators supported are shell-like `*' and `?', but don't forget to quote arguments which use these (e.g. `nomarch foo.arc '*.bar''). EXTRACTING MULTIPLE ARCHIVES
nomarch follows the `unzip'-like practice of working on only one archive per run, with further `filenames' given on the command-line actu- ally specifying files to extract (or whatever). The easiest way to work on multiple files with nomarch is simply to run it multiple times using for; for example: for i in *.arc; do nomarch $i; done The above would extract all archives in the current directory. USING THE PROGRAM FROM EMACS
Emacs's arc-mode facility lets you work with various kinds of archive file directly from the editor. Making it use nomarch for extracting `.arc' files isn't too hard. Just add the following to your ~/.emacs file: (setq archive-arc-extract '("nomarch" "-U")) BUGS
The CRC used by the format is only 16-bit, so `-t' is a less-than-perfect test. One compression method, obsolete even by `.arc' standards :-), isn't supported yet. This is partly because I've yet to find a single file which uses it, despite testing an awful lot of files. Subdirectories in Spark archives are extracted as the `.arc'-format files they really are, which may not be terribly convenient. SEE ALSO
tar(1), gzip(1), bzip2(1), lbrate(1) AUTHOR
Russell Marks (rus@svgalib.org). Version 1.4 18th June, 2006 nomarch(1)
All times are GMT -4. The time now is 12:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy