Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Remove a column using vi editor
Top Forums UNIX for Dummies Questions & Answers Remove a column using vi editor Post 302893558 by Don Cragun on Wednesday 19th of March 2014 06:19:48 PM
Old 03-19-2014
First note that every field delimiter character matters to the cut utility, so the output from the command:
Code:
cut -d" " -f1-6,8- filename

(with your sample input) is:
Code:
1:  010 0xad45  sp1  11:29:51.498583949 500249144  Event1 rst bcfe jhv rgc
456:  010 0xadb  sp2  11:29:51.498600605     4464  Event0abcrd adabc aasd
45:  010 0x10 sp0 - 11:29:51.498614165    13560   Back adxca msg to end
4969:  010 0xjill  spx  11:29:51.498632789    18624  global service desk to the rescue

which is not even close to what you said you wanted when the 7th field is deleted.

I can produce output similar to what you said you want (although the number of spaces are different on some lines around the deleted field) with the vi commands:
Code:
:g/\([^[:space:]]*[[:space:]]*[^[:space:]]*[[:space:]]*[^[:space:]]*[[:space:]]*[^[:space:]]*[[:space:]]*[^[:space:]]*[[:space:]]*[^[:space:]]*[[:space:]]*\)[^[:space:]]*/s//\1/

to remove the 7th field, and
Code:
:g/\([^[:space:]]*[[:space:]]*[^[:space:]]*[[:space:]]*[^[:space:]]*[[:space:]]*[^[:space:]]*[[:space:]]*[^[:space:]]*[[:space:]]*[^[:space:]]*[[:space:]]*\)\([^[:space:]]*\)/s//\2 \1/

to move the 7th field to the start of the line.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

VI editor,column postion

In VI editor ctrl + g is used indicate the line number on which the cursor is placed...similarly is there a way to determine the column number of the cursor position..? (1 Reply)
Discussion started by: vijay_0209
1 Replies

2. Shell Programming and Scripting

Vi editor, copy one column?

This is an vi editor question. I do not know is this a right place to ask this question or not? I have a file with the following contents, 10 11 20 21 30 31 I want to copy first column that is 10,20,30 after second column, so that output will look like the following, 10 11 10 20 21 20... (3 Replies)
Discussion started by: MeetP
3 Replies

3. UNIX for Dummies Questions & Answers

Delete a specific column using vi editor?

Hello Experts, I'm a newbie so please excuse any wrong doings. I have a file that looks like this. abc def ghi jkl mno def abc ghi mno jkl ghi def mno jkl abc I would like the file to look like this abc def ghi jklmno def abc ghi mnojkl ghi def mno jklabc in other... (3 Replies)
Discussion started by: fnebiolo
3 Replies

4. Ubuntu

How to remove multiple spaces in between word? (VI EDITOR)?

What last line mode command allows me to remove extra spaces in between words in a text? (1 Reply)
Discussion started by: rabeel
1 Replies

5. Shell Programming and Scripting

need to remove duplicates based on key in first column and pattern in last column

Given a file such as this I need to remove the duplicates. 00060011 PAUL BOWSTEIN ad_waq3_921_20100826_010517.txt 00060011 PAUL BOWSTEIN ad_waq3_921_20100827_010528.txt 0624-01 RUT CORPORATION ad_sade3_10_20100827_010528.txt 0624-01 RUT CORPORATION ... (13 Replies)
Discussion started by: script_op2a
13 Replies

6. Shell Programming and Scripting

remove brackets and put it in a column and remove repeated entry

Hi all, I want to remove the remove bracket sign ( ) and put in the separate column I also want to remove the repeated entry like in first row in below input (PA156) is repeated ESR1 (PA156) leflunomide (PA450192) (PA156) leflunomide (PA450192) CHST3 (PA26503) docetaxel... (2 Replies)
Discussion started by: manigrover
2 Replies

7. UNIX for Dummies Questions & Answers

Removing 2nd Column in Vi Editor

I have text like this M83-306 132 797 M83-312 145 685 M83-315 321 479 M83-319 654 193 M83-350 556 1184 M83-303 222 199 and I want to make it like this M83-306 797 M83-312 685 M83-315 ... (9 Replies)
Discussion started by: muhnandap
9 Replies

8. UNIX for Dummies Questions & Answers

Swapping column in vi editor

is there any command in vi editor to turn this 986.000 4.026.000 775.328.625 9.319.003.000 986.000 4.036.000 775.328.625 9.318.803.000 986.000 4.046.000 775.328.625 9.318.603.000 986.000 4.056.000 775.328.625 9.318.403.000 become this... (5 Replies)
Discussion started by: muhnandap
5 Replies

9. Shell Programming and Scripting

Remove the values from a certain column without deleting the Column name in a .CSV file

(14 Replies)
Discussion started by: dhruuv369
14 Replies

LEARN ABOUT ULTRIX

df

df(1)							      General Commands Manual							     df(1)

Name
       df - display free and used disk space

Syntax
       df [-i] [-l] [-n] [filesystem...] [file...]

Description
       The command displays the amount of disk space available on the specified file system, for example, It also displays the amount of available
       disk space on the file system in which the specified file is contained, for example, If a device is given that has no file systems  mounted
       on  it,	displays  the  information  for  the  root file system.  Without any arguments or options, displays shows all mounted filesystems,
       including those manually mounted without use of the file.  The numbers are reported in kilobytes.

       Unless the -n option is specified, updates the statistics stored in memory for the file system specified, before it  returns  the  informa-
       tion.

Options
       -i   Also report the number of used and free inodes.

       -l   Reports on locally mounted disks only.

       -n   Do	not  update the file system statistics stored in memory.  Instead, return whatever statistics are stored in memory.  This prevents
	    from hanging in the event that a server containing the specified file system is down.

Restrictions
       You cannot use the command to find free space on an unmounted file system using the block or character special device name.   Instead,  use
       the command.

Examples
       % df
       Filesystem     Total    kbytes  kbytes	%
       node	      kbytes   used    free	used	Mounted on
       /dev/ra1a       7429    2085    4602	31%    /tmp
       /dev/ra0e      30519   14817   12651	54%    /usr/spool
       /dev/ra0h     313233  122858  159052	44%    /usr/staff1

       The  total  disk  space is the total space that was created during the making of the file system.  The addition of the used space, the free
       space and a percentage of reserved space is the total space.  The default value for the reserved space is 10%.

Files
       List of mounted file systems

See Also
       getmnt(2), fstab(5), dumpfs(8), icheck(8), mkfs(8), newfs(8), quot(8)

																	     df(1)
All times are GMT -4. The time now is 05:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy