|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Split column data if the table has n number of column's with some record
Post 302958182 by RudiC on Tuesday 20th of October 2015 06:50:15 AM
10-20-2015
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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 ... (3 Replies)
Discussion started by: tomasl
3 Replies
2. Windows & DOS: Issues & Discussions
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 Replies)
Discussion started by: dashing201
3 Replies
3. UNIX for Advanced & Expert Users
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 ... (6 Replies)
Discussion started by: f_o_555
6 Replies
4. Shell Programming and Scripting
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 Replies)
Discussion started by: prashob123
5 Replies
5. Shell Programming and Scripting
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 ... (4 Replies)
Discussion started by: cpp_beginner
4 Replies
6. Shell Programming and Scripting
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 (1 Reply)
Discussion started by: cpp_beginner
1 Replies
7. UNIX for Dummies Questions & Answers
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... (9 Replies)
Discussion started by: tpk
9 Replies
8. Shell Programming and Scripting
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 |... (7 Replies)
Discussion started by: kbsuryadev
7 Replies
9. Shell Programming and Scripting
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 (1 Reply)
Discussion started by: Priti2277
1 Replies
10. Shell Programming and Scripting
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
... (4 Replies)
Discussion started by: ranjancom2000
4 Replies
LEARN ABOUT MOJAVE
git-column
GIT-COLUMN(1) Git Manual GIT-COLUMN(1) NAME
git-column - Display data in columns SYNOPSIS
git column [--command=<name>] [--[raw-]mode=<mode>] [--width=<width>] [--indent=<string>] [--nl=<string>] [--padding=<n>] DESCRIPTION
This command formats its input into multiple columns. OPTIONS
--command=<name> Look up layout mode using configuration variable column.<name> and column.ui. --mode=<mode> Specify layout mode. See configuration variable column.ui for option syntax. --raw-mode=<n> Same as --mode but take mode encoded as a number. This is mainly used by other commands that have already parsed layout mode. --width=<width> Specify the terminal width. By default git column will detect the terminal width, or fall back to 80 if it is unable to do so. --indent=<string> String to be printed at the beginning of each line. --nl=<N> String to be printed at the end of each line, including newline character. --padding=<N> The number of spaces between columns. One space by default. GIT
Part of the git(1) suite Git 2.17.1 10/05/2018 GIT-COLUMN(1)