Sponsored Content
Top Forums Shell Programming and Scripting Remove first column from file Post 302372737 by Scrutinizer on Wednesday 18th of November 2009 03:37:01 PM
Old 11-18-2009
Quote:
Originally Posted by proactiveaditya

How can this be achieved using awk?
Code:
awk '{sub(/\| \|/,"")}1' infile

Code:
awk -F'\| \|' '{print $2}' infile

Code:
awk -F'\| \|' '{$0=$2}1' infile

 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Remove duplicate rows of a file based on a value of a column

Hi, I am processing a file and would like to delete duplicate records as indicated by one of its column. e.g. COL1 COL2 COL3 A 1234 1234 B 3k32 2322 C Xk32 TTT A NEW XX22 B 3k32 ... (7 Replies)
Discussion started by: risk_sly
7 Replies

2. Shell Programming and Scripting

Remove part of a column in a text file

I have a text file with delimiter "|" and sometimes the zipcode is in "5th" column or "6th" column. I want to scan the file and remove the "-2323" from the zipcode which has zip+4 digits From blah|blah|foo|bar||blah|945523-232|USA blah|blah|foo|bar||blah|foo|94555-2323|USA To... (8 Replies)
Discussion started by: gubbu
8 Replies

3. UNIX for Dummies Questions & Answers

How to remove a string from a specific column in a file

Hello, A basic query. How can I remove a string from a specific column. For example, remove "abcd" just from column 2 in example file: abcd abcd1 abcd abcd2 abcd abcd3 to get output: abcd 1 abcd 2 abcd 3 Thank you!:) (4 Replies)
Discussion started by: auburn
4 Replies

4. Shell Programming and Scripting

Remove Specific Column in a File using awk

Hi, I would like to ask your expertise to remove specific column no. 8 in the below file using but I don't have an idea on how to simply do this using awk command. Appreciate your help in advance. Input f: ABC 1 1XC CDA 1 2YC CCC 1 3XC AVD 1 3XA Expected output file: ABC 1 1C CDA... (9 Replies)
Discussion started by: zzavilz
9 Replies

5. Shell Programming and Scripting

How to remove mth and nth column from a file?

Hi, i need to remove mth and nth column from a csv file. here m and n is not a specific number. it is a variable ex. m=2 n=5 now i need to remove the 2nd and 5th line.. Please help how to do that. Thanks!!! (18 Replies)
Discussion started by: zaq1xsw2
18 Replies

6. 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

7. Shell Programming and Scripting

How to remove duplicated column in a text file?

Dear all, How can I remove duplicated column in a text file? Input: LG10_PM_map_19_LEnd 1000560 G AA AA AA AA AA GG LG10_PM_map_19_LEnd 1005621 G GG GG GG AA AA GG LG10_PM_map_19_LEnd 1011214 A AA AA AA AA GG GG LG10_PM_map_19_LEnd 1011673 T TT TT TT TT CC CC... (1 Reply)
Discussion started by: huiyee1
1 Replies

8. Shell Programming and Scripting

Remove duplicate values in a column(not in the file)

Hi Gurus, I have a file(weblog) as below abc|xyz|123|agentcode=sample code abcdeeess,agentcode=sample code abcdeeess,agentcode=sample code abcdeeess|agentadd=abcd stereet 23343,agentadd=abcd stereet 23343 sss|wwq|999|agentcode=sample1 code wqwdeeess,gentcode=sample1 code... (4 Replies)
Discussion started by: ratheeshjulk
4 Replies

9. UNIX for Advanced & Expert Users

How to remove the delimiter from the column value within a file?

Hello All, we have some 10 files wherein we are using the ASCII NULL as separator which is nothing but '^@' and we need to change it to pipe delimited file before loading to database. Most of the data seems to be fine but there are instances where this separator tends to appear in the middle of... (9 Replies)
Discussion started by: dJHa
9 Replies
rancid-cvs(1)						      General Commands Manual						     rancid-cvs(1)

NAME
rancid-cvs - initialize CVS or Subversion and rancid group files and directories SYNOPSIS
rancid-cvs [-V] [group [group ...]] DESCRIPTION
rancid-cvs creates the directories and router.db(5) for each rancid group and handles the revision control system (CVS or Subversion) set- up. It must be run after installation and whenever a rancid group is added. rancid-cvs reads rancid.conf(5) to configure itself, then proceeds with the initialization. First of the CVS or Subversion repository, if necessary, and then for each of the rancid groups listed on the command-line or those in the variable LIST_OF_GROUPS from rancid.conf(5), if the argument is omitted. Running rancid-cvs for groups which already exist will not cause problems. If the group's directory already exists, the import into the revision control system will be skipped, and if it's router.db(5) already exists, it will not be altered. The command-line options are as follows: -V Prints package name and version strings. The best method for adding groups is add the group name to LIST_OF_GROUPS in rancid.conf(5), then run rancid-cvs. Do not create the directories manually, allow rancid-cvs to do it. SEE ALSO
cvs(1), rancid.conf(5), router.db(5), svn(1) 5 October 2006 rancid-cvs(1)
All times are GMT -4. The time now is 07:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy