Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need help with switching field/column values
Top Forums Shell Programming and Scripting Need help with switching field/column values Post 302166041 by H2OBoodle on Sunday 10th of February 2008 03:24:35 PM
Old 02-10-2008
If you wanted to automate the process, stick the commands into a file and have vim make the changes using the ex mode.

For example:

commandFile:
:% s/\(.*\) \(.*\)/\2 \1/g
:1,$ print <-- not needed, but helpful to show you the changes
:wq

datafile:
a b
a b
a b

vim -e -s < commandFile datafile

-e = ex mode
-s = silent mode

Note that the changes get written back to the datafile

You could also call "ex" directly to do this:

ex < commandFile datafile
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find top N values for field X based on field Y's value

I want to find the top N entries for a certain field based on the values of another field. For example if N=3, we want the 3 best values for each entry: Entry1 ||| 100 Entry1 ||| 95 Entry1 ||| 30 Entry1 ||| 80 Entry1 ||| 50 Entry2 ||| 40 Entry2 ||| 20 Entry2 ||| 10 Entry2 ||| 50... (1 Reply)
Discussion started by: FrancoisCN
1 Replies

2. Shell Programming and Scripting

eAdd two fields in a column if their previous field values are same

Hi All, I have two files file1: abc,def,ghi,5,jkl,mno pqr,stu,ghi,10,vwx,xyz cba,ust,ihg,4,cdu,oqw file2: ravi,def,kishore ramu,ust,krishna joseph,stu,mike I need two output file as follows If field3 in file1 is same as field3 in the next line then the field4 should add... (1 Reply)
Discussion started by: yerruhari
1 Replies

3. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Discussion started by: amigarus
6 Replies

4. Shell Programming and Scripting

adding field values if field matches

hi i have file as below , i want to add duplicate records like bell_bb to one record with valuve as 15 ( addition of both ) any oneline awk script to achive this ? header 0 CAMPAIGN_NAME 1 Bell_BB 14 Bell_MONTHLY 803 SOLO_UNBEATABLE 644 Bell_BB 1 Bell_MONTHLY 25 SOLO_UNBEATABLE... (4 Replies)
Discussion started by: raghavendra.cse
4 Replies

5. Shell Programming and Scripting

counting lines containing two column field values with awk

Hello everybody, I'm trying to count the number of consecutive lines in a text file which have two distinctive column field values. These lines may appear in several line blocks within the file, but I only want a single block to be counted. This was my first approach to tackle the problem (I'm... (6 Replies)
Discussion started by: origamisven
6 Replies

6. Shell Programming and Scripting

Transpose field names from column headers to values in one column

Hi All, I'm looking for a script which can transpose field names from column headers to values in one column. for example, the input is: IDa;IDb;IDc;PARAM1;PARAM2;PARAM3; a;b;c;p1val;p2val;p3val; d;e;f;p4val;p5val;p6val; g;h;i;p7val;p8val;p9val; into the output like this: ... (6 Replies)
Discussion started by: popesk
6 Replies

7. UNIX for Dummies Questions & Answers

shift values in one column as header for values in another column

Hi Gurus, I have a tab separated text file with two columns. I would like to make the first column values as headings for the second column values. Ex. >value1 subjects >value2 priorities >value3 requirements ...etc and I want to have a file >value1 subjects >value2 priorities... (4 Replies)
Discussion started by: Unilearn
4 Replies

8. UNIX for Dummies Questions & Answers

Switching the values in a specific column of a text file

Hi, I have a space de-limited text file. In the fifth column, I would like to switch "1"s with "2"s. How do I go about doing that? Thanks! Sample input: 0 311000259 0 0 1 1 0 311000397 0 0 1 2 0 311000491 0 0 2 1 0 311000516 0 0 2 1 0 311000541 0 0 1 1 0 311000558 0 0 2 1 0 311000566 0... (1 Reply)
Discussion started by: evelibertine
1 Replies

9. Shell Programming and Scripting

Sum up the column values group by using some field

12-11-2012,PNL,158406 12-11-2012,RISK,4564 12-11-2012,VAR_1D,310101 12-11-2012,VAR_10D,310101 12-11-2012,CB,866 12-11-2012,STR_VAR_1D,298494 12-11-2012,STR_VAR_10D,309623 09-11-2012,PNL,1024106 09-11-2012,RISK,4565 09-11-2012,VAR_1D,317211 09-11-2012,VAR_10D,317211 09-11-2012,CB,985... (7 Replies)
Discussion started by: manas_ranjan
7 Replies

10. Shell Programming and Scripting

Sum column values matching other field

this is part of a KT i am going thru. i am writing a script in bash shell, linux where i have 2 columns where 1st signifies the nth hour like 00, 01, 02...23 and 2nd the file size. sample data attached. Desired output is 3 columns which will give the nth hour, number of entries in nth hour and... (3 Replies)
Discussion started by: alpha_1
3 Replies

LEARN ABOUT ULTRIX

vimtutor

VIMTUTOR(1)                                                   General Commands Manual                                                  VIMTUTOR(1)

NAME

       vimtutor - the Vim tutor

SYNOPSIS

       vimtutor [-g] [language]

DESCRIPTION

       Vimtutor starts the Vim tutor.  It copies the tutor file first, so that it can be modified without changing the original file.

       The Vimtutor is useful for people that want to learn their first Vim commands.

       The optional argument -g starts vimtutor with gvim rather than vim, if the GUI version of vim is available, or falls back to Vim if gvim is
       not found.

       The optional [language] argument is the two-letter name of a language, like "it" or "es".  If the [language] argument is missing, the  lan-
       guage  of  the current locale will be used.  If a tutor in this language is available, it will be used.  Otherwise the English version will
       be used.

       Vim is always started in Vi compatible mode.

FILES

       /usr/share/vim/vim80/tutor/tutor[.language]
                      The Vimtutor text file(s).

       /usr/share/vim/vim80/tutor/tutor.vim
                      The Vim script used to copy the Vimtutor text file.

AUTHOR

       The Vimtutor was originally written for Vi by Michael C. Pierce and Robert K. Ware, Colorado  School  of  Mines  using  ideas  supplied  by
       Charles Smith, Colorado State University.  E-mail: bware@mines.colorado.edu.
       It was modified for Vim by Bram Moolenaar.  For the names of the translators see the tutor files.

SEE ALSO

       vim(1)

                                                                   2001 April 2                                                        VIMTUTOR(1)
All times are GMT -4. The time now is 06:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy