Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How convert space separated list to matched columns?
Top Forums UNIX for Dummies Questions & Answers How convert space separated list to matched columns? Post 302830643 by Subbeh on Tuesday 9th of July 2013 08:07:32 AM
Old 07-09-2013
This is not the prettiest solution, but it should do the trick:

Code:
awk '
    {
        a[$1]=a[$1]?a[$1]","FILENAME:FILENAME
    }
    END{
        for(i in a)
            printf "%-35s %-35s %-35s\n",a[i]~ARGV[1]?i:"",a[i]~ARGV[2]?i:"",a[i]~ARGV[3]?i:""
    }
    ' file1 file2 file3

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert from CSV to space padded columns (.ksh)

Hello, Could someone please help me to convert a string(s) of comma separated values into space padded columns in .ksh? ex. 10-21-2008,someword,blah,127.0.0.1,8,3 10-21-2008,randomword,ick,128.0.111.128,1,0 converted to 10-21-2008 someword blah 127.0.0.1 8... (6 Replies)
Discussion started by: WhotheWhat
6 Replies

2. Shell Programming and Scripting

how to convert a line to columns, separated by | (pipe)

Hi, Plz help. input line 1;20100403;400|2;20100403;4|3;20290903;400|4;20290903;0|5;20290903;0|9;20100304;0|10;20100304;0|11;20100402;0|18;20100304;0 expected output 1;20100403;400 2;20100403;4 3;20290903;400 4;20290903;0 5;20290903;0 9;20100304;0 10;20100304;0 11;20100402;0... (4 Replies)
Discussion started by: suresh3566
4 Replies

3. Shell Programming and Scripting

Convert a tab separated file using bash

Dear all, I have a file in this format (like a matrix) - A B C .. X A 1 4 2 .. 2 B 2 6 4 .. 8 C 3 5 5 .. 4 . . . ... . X . . ... . and want to convert it into a file with this format: A A = 1 A B = 4 A C = 2 ... A X = 2 B A = 2 B B = 6 etc (2 Replies)
Discussion started by: TheTransporter
2 Replies

4. Shell Programming and Scripting

How to loop through space separated values?

How do I loop thru space separated values in a variable? I hate to use very complicated counter increment logic for this kind of simple problem. Expected result(using ksh) $>echo "aaa bbbb cccc" | <looping code here> var=aaa var=bbbb var=cccc $>echo "aaa bbbb cccc" | while IFS=" "... (12 Replies)
Discussion started by: kchinnam
12 Replies

5. UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

Hi, I have a large number of files which are written as csv (comma-separated values). Does anyone know of simple sed/awk command do achieve this? Thanks! ---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ---------- Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies

6. Shell Programming and Scripting

Convert comma separated file to fix length

Hi, I am converting a comma separated file to fixed field lenght and I am using that: COLUMNS="25 24 67 26 39 63 20 34 35 14 397" ( cat $indir/input_file.dat | \ $AWK -v columns="$COLUMNS" ' BEGIN { FS=","; OFS=""; split(columns, arr, " "); } { for(i=1; i<=NF;... (5 Replies)
Discussion started by: apenkov
5 Replies

7. Shell Programming and Scripting

Matched a pattern from multiple columns

Hi, I need to extract an info in $1 based on a matched pattern in $2,$3,$4, and $5. The sample input file as follows:- ID Pat1 Pat2 Pro1 use1 add41 M M M add87 M M M M add32 ... (16 Replies)
Discussion started by: redse171
16 Replies

8. Shell Programming and Scripting

Need Help on For Loop to pass space separated value as one value

Hi, I am having a file say list1 with a output like below jun 12 18:23 may 20 18:23 Now i want to pass the above two values into for loop,I have written a script like this. #!/bin/bash a=`cat list1` for i in $a do echo "HI $i" done expected output: HI jun 12 18:23 (3 Replies)
Discussion started by: sumanthupar
3 Replies

9. Shell Programming and Scripting

Convert column to quote and comma separated row

Hi, I have a list of tables in a file.txt C_CLAIM C_HLD C_PROVIDER I want the output to be 'C_CLAIM','C_HLD','C_PROVIDER' Currently I'm usin awk and getting output which is almost correct but still has minor defects awk -vORS="','" '{ print $1 }' file.txt The output of... (4 Replies)
Discussion started by: wahi80
4 Replies

10. Shell Programming and Scripting

Convert fixed value fields to comma separated values

Hi All, Hope you are doing Great!!!. Today i have came up with a problem to say exactly it was for performance improvement. I have written code in perl as a solution for this to cut in specific range, but it is taking time to run for files thousands of lines so i am expecting a sed... (9 Replies)
Discussion started by: mad man
9 Replies

LEARN ABOUT NETBSD

locate.conf

LOCATE.CONF(5)						      BSD File Formats Manual						    LOCATE.CONF(5)

NAME

     locate.conf -- locate database configuration file

DESCRIPTION

     The locate.conf file specifies the behavior of locate.updatedb(8), which creates the locate(1) database.

     The locate.conf file contains a list of newline separated records, each of which is composed of a keyword and arguments, which are separated
     by white space.  Arguments with embedded shell metacharacters must be quoted in sh(1) style.  Lines beginning with ``#'' are treated as com-
     ments and ignored.  However, a ``#'' in the middle of a line does not start a comment.

     The configuration options are as follows:

     ignore pattern ...
	     Ignore files or directories.  When building the database, do not descend into files or directories which match one of the specified
	     patterns.	The matched files or directories are not stored to the database.

	     Default: Not specified.

     ignorecontents pattern ...
	     Ignore contents of directories.  When building the database, do not descend into files or directories which match one of the speci-
	     fied patterns.  The matched files or directories themselves are stored to the database.

	     Default: Not specified.

     ignorefs type ...
	     Ignore file system by type, adding type to the default list.  When building the database, do not descend into file systems which are
	     of the specified type.  The mount points are not stored to the database.  If a ``!'' is prepended to type, the meaning is negated,
	     that is, ignore file systems which do not have the type.  As a special case, if ``none'' is specified for type, the ignorefs list is
	     cleared and all file systems are traversed.

	     type is used as an argument to find(1) -fstype.  The sysctl(8) command can be used to find out the types of file systems that are
	     available on the system:

		   sysctl vfs.generic.fstypes

	     Default: !local cd9660 fdesc kernfs procfs

     searchpath directory ...
	     Specify base directories to be put in the database.

	     Default: /

     workdir directory
	     Specify the working directory of locate.updatedb, in which a temporary file is placed.  The temporary file is a list of all files,
	     and you should specify a directory that has enough space to hold it.

	     Default: /tmp

     Refer to find(1) for the details of pattern (see -path expression) and type (see -fstype expression).

FILES

     /etc/locate.conf		   The file locate.conf resides in /etc.

SEE ALSO

     find(1), locate(1), locate.updatedb(8), sysctl(8)

HISTORY

     The locate.conf file format first appeared in NetBSD 2.0.

AUTHORS

     ITOH Yasufumi

BSD
								   July 10, 2011							       BSD
All times are GMT -4. The time now is 04:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy