Sponsored Content
Top Forums Shell Programming and Scripting Sort and join multiple columns using awk Post 302764173 by quincyjones on Thursday 31st of January 2013 09:19:20 AM
Old 01-31-2013
@Scrutinizer: Is it possible to apply your code even on unsorted file ?
@Neutron: Your code making all 0.* values as 0 ?

@Neutron : Is it possible to define the number of value-columns for a key column, when I run the script? In the above example (1 key and 1 value). This example (1 key 5 value cols)

Code:
a1	0	1	1	0	1	a1	1	1	1	0	1	a1	1	1	1	1	1	a1	0	0	0	0	1	a1	1	1	1	1	1	1
a2	1	0	1	0	1	a4	1	1	1	1	1	a4	0	0	1	1	1	a4	0	0	0	0	1	a4	1	1	1	1	1	1
a3	1	0	1	0	1	d1	1	1	1	0	1	d1	1	1	0	0	1	d1	0	0	0	0	1	d1	1	1	1	1	1	1
a4	1	0	1	0	1	c4	1	1	1	0	0	c4	1	1	1	0	0	c4	0	0	0	0	1	c4	1	1	1	1	1	1
b1	1	0	1	0	1																									
b2	1	1	1	0	1																									
c4	1	1	1	0	1																									
d1	1	1	1	0	1

---------- Post updated at 09:19 AM ---------- Previous update was at 04:50 AM ----------
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk or python to join alternating columns

Hi, here is my input TEST-SAM-A6ZZ SM-S6KV 0 0 2 1 2 3 3 3 2 2 2 2 1 1 2 2 1 3 1 3 1361 SM-HA4Q 0 0 2 1 3 3 3 3 2 2 2 2 1 1 2 2 1 3 3 3 4 2 4 2 2 276217 SM-H9ZG 0 0 2 2 3 3 3 3 2 2 2 2 1 1 2 2 3 3 1 3 2 2 2 2 GC15458 SM-HAQX 0 0 2 1 2 3 1 3 2 2 2 2 1 1 2 2 1 3 1 3 2 2 2 18331 SM-HA5E 0 0 2 2... (2 Replies)
Discussion started by: genehunter
2 Replies

2. UNIX for Dummies Questions & Answers

Join 2 files with multiple columns: awk/grep/join?

Hello, My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns: File A: (tab-delimited) PDB CHAIN Start End Fragment 1avq A 171 176 awyfan 1avq A 172 177 wyfany 1c7k A 2 7... (3 Replies)
Discussion started by: InfoSeeker
3 Replies

3. Shell Programming and Scripting

sort by based on multiple columns

Hi, Is there any way to sort a file in cshell by sort command, sorting it by multiple fields, like to sort it first by the second column and then by the first column. Thanks forhead (1 Reply)
Discussion started by: Takeeshe
1 Replies

4. Shell Programming and Scripting

sort on multiple columns

Howdy! Need to sort a large .txt file containing the following, using sort. First based on the 1st column, and then on the 2nd column: Group01.01 1000500 31 0.913 -1.522974494 Group01.01 1001500 16 0.684 -0.967496041 Group01.01 36500 19 0.476 na Group01.02 365500 15 0.400 na... (1 Reply)
Discussion started by: sramirez
1 Replies

5. Shell Programming and Scripting

sort on multiple columns

hi all, i have a file , having few columns. i wanted to sort it based on 2nd column and then based on 1st column. But i have some problem in first column. first column have characters and numbers, but problem is number of characters are not same in all rows. Few rows have 13 characters and then... (3 Replies)
Discussion started by: deepakiniimt
3 Replies

6. Programming

Ls -ltr Sort multiple columns

Hi All, I have one requirement, where I need to have output of ls -l command sorted on 1) first on filename 2) last modified time ( descending ) - latest change first. I am not able to figure out how to do it.. Also I dont have a way to change Date display for ls -ltr command.. I am... (1 Reply)
Discussion started by: freakabhi
1 Replies

7. Shell Programming and Scripting

Join two files combining multiple columns and produce mix and match output

I would like to join two files when two columns in each file matches with each other and then produce an output when taking multiple columns. Like I have file A 1234,ABCD,23,JOHN,NJ,USA 2345,ABCD,24,SAM,NY,USA 5678,GHIJ,24,TOM,NY,USA 5678,WXYZ,27,MAT,NJ,USA and file B ... (2 Replies)
Discussion started by: mady135
2 Replies

8. Shell Programming and Scripting

Join columns across multiple lines in a Text based on common column using BASH

Hello, I have a file with 2 columns ( tableName , ColumnName) delimited by a Pipe like below . File is sorted by ColumnName. Table1|Column1 Table2|Column1 Table5|Column1 Table3|Column2 Table2|Column2 Table4|Column3 Table2|Column3 Table2|Column4 Table5|Column4 Table2|Column5 From... (6 Replies)
Discussion started by: nv186000
6 Replies

9. Shell Programming and Scripting

Join and merge multiple files with duplicate key and fill void columns

Join and merge multiple files with duplicate key and fill void columns Hi guys, I have many files that I want to merge: file1.csv: 1|abc 1|def 2|ghi 2|jkl 3|mno 3|pqr file2.csv: (5 Replies)
Discussion started by: yjacknewton
5 Replies

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... (2 Replies)
Discussion started by: yjacknewton
2 Replies
JED(1)								   User Manuals 							    JED(1)

NAME
Jed - programmers editor SYNOPSIS
jed --version jed-script --version xjed --version jed [--secure] [--batch|--script|--help] [options] file ... jed-script [--secure] script file [script options] ... xjed [--secure] [X options] [--batch|--script|--help] [options] file ... DESCRIPTION
Jed - programmers editor Features: Color syntax highlighting. Emulation of Emacs, EDT, Wordstar, and Brief editors. Extensible in a language resembling C. Completely cus- tomizable. Editing TeX files with AUC-TeX style editing (BiBTeX support too). Folding support, and much more... For complete documentation, see GNU info files, this manual only provides brief tutorial. OPTIONS
major options --version prints the version and compiletime variables. --help prints usage information. --secure runs Jed in secure mode, e.g. you can't run any external commands with system() or run_shell_cmd(). --batch run Jed in batch mode. This is a non-interactive mode. --script this is a mode like --batch but jed does not eval the startup files. It behaves like slsh. You must give the file that should be evaluated as second argument. It's the same as calling jed-script. minor options -n do not load .jedrc file. -a 'file' load file as user configuration file instead of .jedrc. + 'n' goto line n in buffer (notice that in order to this option to take effect, if must appear before the file name in the command line, like 'jed +3 file') -g 'n' goto line n in buffer (notice that in order to this option to take effect, if must appear after the file name in the command line, like 'jed file -g 3') -l 'file' load file as S-Lang code. -f 'function' execute S-Lang function named function -s 'string' search forward for string -2 split window -i 'file' insert file into current buffer. X options xjed accapts the common options like -display, -name, -fn and -geometry. Additionaly it accepts -facesize SIZE, -fs SIZE if build with XRENDERFONT support, selects the font size SIZE. Use it with the option -fn to select a scalable font. -foreground COLOR, -fg COLOR sets the foreground color. -background COLOR, -bg COLOR sets the background color. -fgMouse COLOR, -mfg COLOR sets the foreground color of the mouse pointer. -bgMouse COLOR, -mbg COLOR sets the background color of the mouse pointer. -Iconic, -ic start iconified. -title NAME sets the window title to NAME. For more options look at xterm.c. CONFIGURATION
Emulating Other Editors JED's ability to create new functions using the S-Lang programming language as well as allowing the user to choose key bindings, makes the emulation of other editors possible. Currently, JED provides reasonable emulation of the Emacs, EDT, and Wordstar editors. Emacs Emulation Emacs Emulation is provided by the S-Lang code in emacs.sl. The basic functionality of Emacs is emulated; most Emacs users should have no problem with JED. To enable Emacs emulation in JED, make sure that the line: () = evalfile ("emacs"); is in your jed.rc (.jedrc) startup file. JED is distributed with this line already present in the default jed.rc file. EDT Emulation For EDT emulation, edt.sl must be loaded. This is accomplished by ensuring that the line: () = evalfile ("edt"); is in present in the jed.rc (.jedrc) Startup File. Wordstar Emulation wordstar.sl contains the S-Lang code for JED's Wordstar emulation. Adding the line () = evalfile ("wordstar"); to your jed.rc (.jedrc) startup file will enable JED's Wordstar emulation. RUN TIME
Status line and Windows JED supports multiple windows. Each window may contain the same buffer or different buffers. A status line is displayed immediately below each window. The status line contains information such as the JED version number, the buffer name, mode, etc. Please beware of the fol- lowing indicators: ** buffer has been modified since last save. %% buffer is read only. m Mark set indicator. This means a region is being defined. d File changed on disk indicator. This indicates that the file associated with the buffer is newer than the buffer itself. s spot pushed indicator. + Undo is enabled for the buffer. [Narrow] Buffer is narrowed to a region of LINES. [Macro] A macro is being defined. Mini-Buffer. The Mini-Buffer consists of a single line located at the bottom of the screen. Much of the dialog between the user and JED takes place in this buffer. For example, when you search for a string, JED will prompt you for the string in the Mini-Buffer. The Mini-Buffer also provides a direct link to the S-Lang interpreter. To access the interpreter, press Ctrl-X Esc and the S-Lang> prompt will appear in the Mini-Buffer. Enter any valid S-Lang expression for evaluation by the interpreter. It is possible to recall data previously entered into the Mini-Buffer by using the up and down arrow keys. This makes it possible to use and edit previous expressions in a convenient and efficient manner. Basic Editing Editing with JED is pretty easy - most keys simply insert themselves. Movement around the buffer is usually done using the arrow keys or page up and page down keys. If edt.sl is loaded, the keypads on VTxxx terminals function as well. Here, only the highlights are touched upon (cut/paste operations are not considered `highlights'). In the following, any character prefixed by the ^ character denotes a Control character. On keyboards without an explicit Escape key, Ctrl-[ will most likely generate and Escape character. A prefix argument to a command may be generated by first hitting the Esc key, then entering the number followed by pressing the desired key. Normally, the prefix argument is used simply for repetition. For example, to move to the right 40 characters, one would press Esc 4 0 followed immediately by the right arrow key. This illustrates the use of the repeat argument for repetition. However, the prefix argu- ment may be used in other ways as well. For example, to begin defining a region, one would press the Ctrl-@ key. This sets the mark and begins highlighting. Pressing the Ctrl-@ key with a prefix argument will abort the act of defining the region and to pop the mark. The following list of useful keybindings assumes that emacs.sl has been loaded. Ctrl-L Redraw screen. Ctrl-_ Undo (Control-underscore, also Ctrl-X u'). Esc q Reformat paragraph (wrap mode). Used with a prefix argument. will justify the paragraph as well. Esc n narrow paragraph (wrap mode). Used with a prefix argument will justify the paragraph as well. Esc ; Make Language comment (Fortran and C) Esc Trim whitespace around point Esc ! Execute shell command Esc $ Ispell word Ctrl-X ? Show line/column information. ` quoted_insert --- insert next char as is (backquote key) Esc s Center line. Esc u Upcase word. Esc d Downcase word. Esc c Capitalize word. Esc x Get M-x minibuffer prompt with command completion Ctrl-X Ctrl-B pop up a list of buffers Ctrl-X Ctrl-C exit JED Ctrl-X 0 Delete Current Window Ctrl-X 1 One Window. Ctrl-X 2 Split Window. Ctrl-X o Other window. Ctrl-X b switch to buffer Ctrl-X k kill buffer Ctrl-X s save some buffers Ctrl-X Esc Get "S-Lang>" prompt for interface to the S-Lang interpreter. Esc . Find tag Ctrl-@ Set Mark (Begin defining a region). Used with a prefix argument aborts the act of defining the region and pops the Mark. FILES
JED_ROOT/lib/*.sl these are the default runtime jed slang files (packages like jed-extra can define additional slang library directories) JED_ROOT/lib/site.sl This is the default startup file. /etc/jed.d/*.sl The system wide configuration files (this is a special Debian feature). ~/.jedrc Per user configuration file, or ~/.jed/jed.rc per user configuration file if the Jed_Home_Directory ~/.jed/ exists. AUTHOR
John E. Davis <davis@space.mit.edu> Jed's Author --- This document was translated to nroff by "Boris D. Beletsky" <borik@isracom.co.il> Debian OCT 1996 JED(1)
All times are GMT -4. The time now is 11:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy