Split column data if the table has n number of column's with some record Post: 302958271

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting Split column data if the table has n number of column's with some record Post 302958271 by Priti2277 on Tuesday 20th of October 2015 05:06:37 PM

Old

10-20-2015

Registered User

Quote:

Originally Posted by MadeInGermany

The following shell script works with any amount of whitespace-delimited columns

Code:

#!/bin/sh
awk '


NR==1 {x=NF/2}
{
  line=$0
  if (NR==FNR) {
    sub("[[:space:]]+$","",line)
    for (i=NF; i>x; i--) sub("[[:space:]]+[^[:space:]]+$", "", line)
  } else {
    for (i=1; i<=x; i++) sub("[^[:space:]]+[[:space:]]+", "", line)
  }
  print line
}
' "$1" "$1"

The shell script takes the file name as parameter.

Sorry not explain properly
Table

Code:

col1 col2 col3 col4 col5 col6    
drwxr-xr-x 4096 Oct 12 07:51 Templates
drwxr-xr-x 4096 Oct 12 07:51 Public
drwxr-xr-x 4096 Oct 12 07:51 Pictures
drwxr-xr-x 4096 Oct 12 07:51 Music
drwxr-xr-x 4096 Oct 12 07:51 Downloads

output should be display col1 and col2 below col1 and col2
col3 col4 col5 col6 should be display.

Code:

col1 col2
drwxr-xr-x 4096 
drwxr-xr-x 4096 
drwxr-xr-x 4096 
drwxr-xr-x 4096 
drwxr-xr-x 4096 
col3 col4 col5 col6
Oct 12 07:51 Templates
Oct 12 07:51 Public
Oct 12 07:51 Pictures
Oct 12 07:51 Music
Oct 12 07:51 Downloads

---------- Post updated at 02:36 AM ---------- Previous update was at 02:09 AM ----------

can I add 3 different awk statement make a single awk statement first statement output using the second statement and second statement output using the third awk statement

Last edited by Don Cragun; 10-20-2015 at 06:09 PM.. Reason: code tags, please

Priti2277

View Public Profile for Priti2277

Find all posts by Priti2277

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split single file into multiple files based on the number in the column

Dear All, I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...): ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ...

2. Windows & DOS: Issues & Discussions

Split Data in one column into 2 column in Excel using DOS or VBScript

Hi I have some data in my Excel File.However all the data is in one single column.I want to split it into two columns. Current Data: 1,Hi Everyone,I am 7,New To Dos,And 17,VB Script,i could 110,have tried this thing 1800,in UNIX Desired Output CELL1|CELL 2 1 |Hi...

3. UNIX for Advanced & Expert Users

Data from table to column

Hi All, in bash I have a text file which is something like 7.96634E-07 1.0000 0.00000E+00 0.0000 0.00000E+00 0.0000 1.59327E-06 0.7071 2.23058E-05 0.1890 6.61207E-05 0.1098 1.13919E-04 0.0865 1.47377E-04 0.0747 .... .... 0.00000E+00 0.0000 0.00000E+00 0.0000 ...

4. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters...

5. Shell Programming and Scripting

Problem to print out record got smallest number in specific column

Hi, Anybody know how to print out the record that shown smallest number among column 3 and column 4 Case 1 Input : 37170 37196 77 51 37174 37195 73 52 37174 37194 73 53 Case 1 Output : 37170 37196 77 51 Case 2 Input : 469613 469660 73 ...

6. Shell Programming and Scripting

Problem facing to compare different column and print out record with smallest number

Hi, Input file 1 : 37170 37196 77 51 37174 37195 73 52 37174 37194 73 53 Desired Output file 1 : 37170 37196 77 51 Input file 2 : 37174 37195 73 0 37170 37196 77 0 Desired Output file 2 : 37174 37195 73 0

7. UNIX for Dummies Questions & Answers

Match sum of values in each column with the corresponding column value present in trailer record

Hi All, I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record. For example, let's assume for column D...

8. Shell Programming and Scripting

Split column into two on first occurence of any number

Input : abc def 1 xyz zzz bca cde 2 yyy xxx Expected output : abc def |1 xyz zzz bca cde |2 yyy xxx I have tried the command below and losing the number. Any help is greatly appreciated 1. sed 's//|/' num.txt Result: abc def | xyz zzz bca cde |...

9. Shell Programming and Scripting

Split column data if the table has n number of column's

please write a shell script Table -------------------------- 1 2 3 a b c 3 4 5 c d e 7 8 9 f g h Output should be like this --------------- 1 2 3 3 4 5 7 8 9 a b c c d e f g h

10. Shell Programming and Scripting

awk split columns to row after N number of column

I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end Source file will have 001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C Need Output from every 5 tab and remove the comma from end of each row ...

LEARN ABOUT OSX

tabify

textutil::tabify(n)				    Text and string utilities, macro processing 			       textutil::tabify(n)

__________________________________________________________________________________________________________________________________________________

NAME

       textutil::tabify - Procedures to (un)tabify strings

SYNOPSIS

       package require Tcl  8.2

       package require textutil::tabify  ?0.7?

       ::textutil::tabify::tabify string ?num?

       ::textutil::tabify::tabify2 string ?num?

       ::textutil::tabify::untabify string ?num?

       ::textutil::tabify::untabify2 string ?num?

_________________________________________________________________

DESCRIPTION

       The package textutil::tabify provides commands that convert between tabulation and ordinary whitespace in strings.

       The complete set of procedures is described below.

       ::textutil::tabify::tabify string ?num?
	      Tabify  the string by replacing any substring of num space chars by a tabulation and return the result as a new string. num defaults
	      to 8.

       ::textutil::tabify::tabify2 string ?num?
	      Similar to ::textutil::tabify this command tabifies the string and returns the result as a new string. A different algorithm is used
	      however. Instead of replacing any substring of num spaces this command works more like an editor. num defaults to 8.

	      Each line of the text in string is treated as if there are tabstops every num columns. Only sequences of space characters containing
	      more than one space character and found immediately before a tabstop are replaced with tabs.

       ::textutil::tabify::untabify string ?num?
	      Untabify the string by replacing any tabulation char by a substring of num space chars and return the result as a  new  string.  num
	      defaults to 8.

       ::textutil::tabify::untabify2 string ?num?
	      Untabify	the  string  by  replacing  any  tabulation  char by a substring of at most num space chars and return the result as a new
	      string. Unlike textutil::tabify::untabify each tab is not replaced by a fixed number of space characters.  The command overlays each
	      line  in	the  string  with tabstops every num columns instead and replaces tabs with just enough space characters to reach the next
	      tabstop. This is the complement of the actions taken by ::textutil::tabify::tabify2. num defaults to 8.

	      There is one asymmetry though: A tab can be replaced with a single space, but not the other way around.

BUGS, IDEAS, FEEDBACK
       This document, and the package it describes, will undoubtedly contain bugs and other problems.  Please report such in the category textutil
       of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you may have for
       either package and/or documentation.

SEE ALSO

       regexp(n), split(n), string(n)

KEYWORDS

       formatting, string, tabstops

CATEGORY

       Text processing

textutil								0.7						       textutil::tabify(n)