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 DEBIAN

rnano

RNANO(1)						      General Commands Manual							  RNANO(1)

NAME

       rnano - Restricted mode for Nano's ANOther editor, an enhanced free Pico clone

SYNOPSIS

       rnano [OPTIONS] [[+LINE,COLUMN] FILE]...

DESCRIPTION

       This manual page briefly documents the rnano command.

       nano is a small, free and friendly editor which aims to replace Pico, the default editor included in the non-free Pine package. Rather than
       just copying Pico's look and feel, nano also implements some missing (or disabled by  default)  features  in  Pico,  such  as  "search  and
       replace" and "go to line and column number".

       rnano  is  a  restricted  version of nano, which only edits specific files and doesn't allow the user access to the filesystem or a command
       shell.

       In restricted mode, nano will not:

       o read or write to any file not specified on the command line;

       o read any nanorc files;

       o allow suspending;

       o allow a file to be appended to, prepended to, or saved under a different name;

       o use backup files or spell checking.

OPTIONS

       +LINE,COLUMN
	      Places cursor at line number LINE and column number COLUMN (at least one of which must be specified)  on	startup,  instead  of  the
	      default of line 1, column 1.

       -?     Same as -h (--help).

       -h (--help)
	      Show a summary of command line options and exit.

       -V (--version)
	      Show the current version number and exit.

       See the nano(1) manpage for the complete documentation of nano.

BUGS

       Please send any comments or bug reports to nano@nano-editor.org.

       The nano mailing list is available from nano-devel@gnu.org.

       To subscribe, email to nano-devel-request@gnu.org with a subject of "subscribe".

HOMEPAGE

       http://www.nano-editor.org/

AUTHOR

       Chris  Allegretta  <chrisa@asty.org>,  et  al  (see  AUTHORS  for  details).   This  manual  page was originally written by Thijs Kinkhorst
       <thijs@kinkhorst.com>, for the Debian system (but may be used by others).

August 23, 2007 						   version 2.0.0							  RNANO(1)
All times are GMT -4. The time now is 08:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy