Combine columns from many files but keep them aligned in columns-shorter left column issue Post: 302738837

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Output columns needs to be aligned

Hi All I'm running a shell script and the output is something like: Col1 Col2 Col3 aaaa aaaaaaa aaaaa bbbbb bbbbb bbbbbb ccc cccccc ccccccc But I require the output to printed as given below: Col1 Col2 Col3 aaaa ...

2. Shell Programming and Scripting

How to combine 2 files into 1 file with 2 columns

Hi Guys, I want to combine 2 files and and put together in 1 file and make two columns out it. See below desired output. Any help will be much appreciated. inputfile1.txt 12345 67890 24580 inputfile2.txt AAAAA BBBBB CCCCC

3. UNIX for Dummies Questions & Answers

How to combine 2 files with 6 columns?

This may seem obvious but I am having problems doing this as columns get converted to rows when i try to write a script. I have 2 files text1.txt and text2.txt each of which have 6 columns of numbers separated by a space. I need to combine the 2 files so that the output file text3.txt maintains...

4. Shell Programming and Scripting

Combine columns from multiple files

Can anybody help on the script to combine/concatenate columns from multiple files input1 4 135 5 185 6 85 11 30 16 72 17 30 21 52 22 76 input2 2 50 4 50 6 33 8 62 10 25 12 46 14 42 15 46output

5. Shell Programming and Scripting

Merging columns based on one or more column in two files

I have two files. FileA.txt 30910 rs7468327 36587 rs10814410 91857 rs9408752 105797 rs1133715 146659 rs2262038 152695 rs2810979 181843 rs3008128 182129 rs3008131 192118 rs3008170 FileB.txt 30910 1.9415219673 0 36431 1.3351312477 0.0107191428 36587 1.3169171182...

6. UNIX for Dummies Questions & Answers

Combine columns from 100 files with same structure

Hi, I have a bunch of files with the following format. PUR.1.9 30910 0.024 0.926 0.050 36587 0.024 0.927 0.049 91857 0.023 0.928 0.049 105797 0.024 0.927 0.049 146659 0.024 0.927 0.049 152695 0.024 0.927 0.049 192118 0.022 0.930 0.048 193310 0.018 0.936 0.046 PUR.2.9 30910 0.028...

7. Shell Programming and Scripting

Merge two columns from two files into one if another column matches

I have two text files that look something like this: A:B:C 123 D:E:F 234 G:H:I 345 J:K:L 123 M:N:O 456 P:Q:R 567 A:B:C 456 D:E:F 567 G:H:I 678 J:K:L 456 M:N:O 789 P:Q:R 890 I want to find the line where the first column matches and then combine the second columns into a single...

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'...

9. Shell Programming and Scripting

Adding columns from 2 files with variable number of columns

I have two files, file1 and file2 who have identical number of rows and columns. However, the script is supposed to be used for for different files and I cannot know the format in advance. Also, the number of columns changes within the file, some rows have more and some less columns (they are...

10. Shell Programming and Scripting

Join, merge, fill NULL the void columns of multiples files like sql "LEFT JOIN" by using awk

Hello, This post is already here but want to do this with another way Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files file1.csv: 1|abc 1|def 2|ghi 2|jkl 3|mno 3|pqr file2.csv: 1|123|jojo 1|NULL|bibi...

LEARN ABOUT SUSE

vgs

VGS(8)							      System Manager's Manual							    VGS(8)

NAME

       vgs - report information about volume groups

SYNOPSIS

       vgs  [-a|--all] [--aligned] [-d|--debug] [-h|-?|--help] [--ignorelockingfailure] [--nameprefixes] [--noheadings] [--nosuffix] [-o|--options
       [+]Field[,Field]] [-O|--sort [+|-]Key1[,[+|-]Key2[,...]]]  [-P|--partial] [--rows] [--separator Separator]  [--unbuffered]  [--units  hHbB-
       sSkKmMgGtTpPeE] [--unquoted] [-v|--verbose] [--version] [VolumeGroupName [VolumeGroupName...]]

DESCRIPTION

       vgs produces formatted output about volume groups.

OPTIONS

       See lvm for common options.

       --all  List all volume groups.  Equivalent to not specifying any volume groups.

       --aligned
	      Use with --separator to align the output columns.

       --nameprefixes
	      Add  an  "LVM2_" prefix plus the field name to the output.  Useful with --noheadings to produce a list of field=value pairs that can
	      be used to set environment variables (for example, in udev (7) rules).

       --noheadings
	      Suppress the headings line that is normally the first line of output.  Useful if grepping the output.

       --nosuffix
	      Suppress the suffix on output sizes.  Use with --units (except h and H) if processing the output.

       -o, --options
	      Comma-separated ordered list of columns.	Precede the list with '+' to append to the default selection of columns.

	      Use -o vg_all to select all volume group columns.

	      Use -o help to view the full list of columns available.

	      Column names include: vg_fmt, vg_uuid, vg_name, vg_attr, vg_size, vg_free, vg_sysid, vg_extent_size, vg_extent_count, vg_free_count,
	      max_lv, max_pv, pv_count, lv_count, snap_count, vg_seqno, vg_tags, vg_mda_count, vg_mda_free, and vg_mda_size.

	      Any  "vg_"  prefixes  are  optional.  Columns mentioned in either pvs (8) or lvs (8) can also be chosen, but columns cannot be taken
	      from both at the same time.

	      The vg_attr bits are:

	      1  Permissions: (w)riteable, (r)ead-only

	      2  Resi(z)eable

	      3  E(x)ported

	      4  (p)artial: one or more physical volumes belonging to the volume group are missing from the system

	      5  Allocation policy: (c)ontiguous, c(l)ing, (n)ormal, (a)nywhere, (i)nherited

	      6  (c)lustered

       -O, --sort
	      Comma-separated ordered list of columns to sort by.  Replaces the default selection. Precede any column with - for a reverse sort on
	      that column.

       --rows Output columns as rows.

       --separator Separator
	      String to use to separate each column.  Useful if grepping the output.

       --unbuffered
	      Produce output immediately without sorting or aligning the columns properly.

       --units hHbBsSkKmMgGtTpPeE
	      All  sizes  are  output  in  these  units: (h)uman-readable, (b)ytes, (s)ectors, (k)ilobytes, (m)egabytes, (g)igabytes, (t)erabytes,
	      (p)etabytes, (e)xabytes.	Capitalise to use multiples of 1000 (S.I.) instead of 1024.  Can also specify custom units e.g. --units 3M

       --unquoted
	      When used with --nameprefixes, output values in the field=value pairs are not quoted.

SEE ALSO

       lvm(8), vgdisplay(8), pvs(8), lvs(8)

Sistina Software UK					 LVM TOOLS 2.02.67(2) (2010-06-04)						    VGS(8)