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
CVS-SWITCHROOT(1)					    BSD General Commands Manual 					 CVS-SWITCHROOT(1)

NAME
cvs-switchroot -- change repository or tag in a cvs working copy SYNOPSIS
cvs-switchroot [-T] newroot [file ...] cvs-switchroot [-T] - srcpath [file ...] DESCRIPTION
The cvs-switchroot utility manipulates a CVS working copy directly, modifying the information stored in the administrative subdirectory and saving space by hardlinking if possible. If the -T option is given, the sticky tag is operated on, otherwise, the repository path (CVSROOT). The information (Tag or Root) is set to the same as in srcpath if the first non-option argument newroot is a sole dash ('-'), the literal value newroot otherwise. EXAMPLES
Change all Root information in the current sandbox to /cvs: $ cvs-switchroot /cvs . Set all roots in the current working directory and all its subdirectories to the Root of the parent directory: $ cvs-switchroot - .. . Hardlink the Tag information in the current working directory, for example /usr/src, and /usr/ports with each other: $ cvs-switchroot -T - . . /usr/ports SEE ALSO
cvs(1) HISTORY
cvs-switchroot has existed in the MirBSD source tree since 2005. It was added to Debian's cvs package in 2011. CAVEATS
cvs-switchroot depends on mksh. BSD
June 10, 2011 BSD
All times are GMT -4. The time now is 02:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy