Visit Our UNIX and Linux User Community


Remove first column from file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove first column from file
# 1  
Old 11-18-2009
Remove first column from file

Hi,

This is how data in test.txt file
| |abc|zxcv|xy12|
| |cvs|zzvc|a23p|

How can remove first column.
abc|zxcv|xy12|
cvs|zzvc|a23p|

Thanks
srimitta
# 2  
Old 11-18-2009
One way:

Code:
sed 's/^| |//' file > newfile

# 3  
Old 11-18-2009
Code:
sed 's/^| |//' infile

# 4  
Old 11-18-2009
Perfect it's working.

Thanks
srimitta
# 5  
Old 11-18-2009
Code:
cat test.txt |cut -f3,4,5,6 -d'|'



---------- Post updated at 03:19 PM ---------- Previous update was at 02:59 PM ----------

How can this be achieved using awk?
# 6  
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

# 7  
Old 11-18-2009
Thanks,

Code:
cat test.txt |awk '{sub(/\| \|/,"")}1'


Previous Thread | Next Thread
Test Your Knowledge in Computers #499
Difficulty: Medium
The term 'self-documenting' code means the compiler has advanced A.I. which documents what each line of code actually does.
True or False?

9 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

Featured Tech Videos