Visit Our UNIX and Linux User Community


to remove the last column


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting to remove the last column
# 1  
Old 08-13-2009
to remove the last column

Hi Guys,

I want to remove the last column of my file..
My file looks like this..

Code:
UPDATE TRDSTG.STRDCLM2 SET C_TREAD_COMPONENT='NR', X_MEMO_REF='M:LOP8 F 2009' WHERE C_SOURCE='CSC' AND D_QTR_APPLBTY=200902 AND I_DOCUMENT=381917678 AND C_TREAD_COMPONENT='GP' AND C_SFTY_CSQ='W08J01182' AND X_MEMO_REF='G:LOP8 F 2009';

I want it as
Code:
UPDATE TRDSTG.STRDCLM2 SET C_TREAD_COMPONENT='NR', X_MEMO_REF='M:LOP8 F 2009' WHERE C_SOURCE='CSC' AND D_QTR_APPLBTY=200902 AND I_DOCUMENT=381917678 AND C_TREAD_COMPONENT='GP' AND C_SFTY_CSQ='W08J01182'

I tried cut command.. but of no use..
This is the command i tried

Code:
cut -d ' ' -f1,17

Regards,
Magesh

---------- Post updated at 07:52 PM ---------- Previous update was at 07:39 PM ----------

Guys. i did it in a very crude way...

Code:
sed 's/................................$//g' a.SQL > new_file.sql

Please let me knw if it can be done by awk..
# 2  
Old 08-13-2009
Code:
nawk -F'AND' -v OFS='AND' '{NF=NF-1;$1=$1;print}' myFile

# 3  
Old 08-13-2009
Try...

Code:
 
awk -F "AND" '!NF' inputfile

# 4  
Old 08-13-2009
Quote:
Originally Posted by malcomex999
Try...

Code:
 
awk -F "AND" '!NF' inputfile

I get nothing. Have you 'tried' it?
# 5  
Old 08-13-2009
With cut:
Code:
cut -d' '  -f1-17 file

# 6  
Old 08-13-2009
Guys,

@Vgresh99, i am still getting the whole line with the last column

Code:
p01: head -1 UPDATE.GCS.200902.LOP8.SQL |awk -F'AND' -v OFS='AND' '{NF=NF-1;$1=$1;print}'
UPDATE TRDSTG.STRDCLM2 SET C_TREAD_COMPONENT='06', X_MEMO_REF='M:LOP8 R 2008' WHERE C_SOURCE='GCS' AND D_QTR_APPLBTY=200902 AND I_DOCUMENT=386543609 AND C_TREAD_COMPONENT='GP' AND C_SFTY_CSQ='W09830102' AND X_MEMO_REF='G:LOP8 R 2008';

@malcomex, i am not getting any output itself

@ necroman,,your code worked fine..
# 7  
Old 08-13-2009
Or, with Perl:

Code:
$
$ cat mac.txt
UPDATE TRDSTG.STRDCLM2 SET C_TREAD_COMPONENT='NR', X_MEMO_REF='M:LOP8 F 2009' WHERE C_SOURCE='CSC' AND D_QTR_APPLBTY=200902 AND I_DOCUMENT=381917678 AND C_TREAD_COMPONENT='GP' AND C_SFTY_CSQ='W08J01182' AND X_MEMO_REF='G:LOP8 F 2009';
$
$ perl -lne 's/(.*) AND.*/$1/; print' mac.txt
UPDATE TRDSTG.STRDCLM2 SET C_TREAD_COMPONENT='NR', X_MEMO_REF='M:LOP8 F 2009' WHERE C_SOURCE='CSC' AND D_QTR_APPLBTY=200902 AND I_DOCUMENT=381917678 AND C_TREAD_COMPONENT='GP' AND C_SFTY_CSQ='W08J01182'
$

tyler_durden

Previous Thread | Next Thread
Test Your Knowledge in Computers #83
Difficulty: Easy
BSD, Linux, Mac OS X, and other Unix-like operating systems did not inherit aspects of the original Unix design.
True or False?

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to remove a value from first column in the second column?

HI, I have a file like this: 5_2207830114 5_2207830114,13_2207830312,15_2207830336 8_2207830145 8_2207830145,15_2207830336 10_2207830220 5_2207830114,7_2207830138,8_2207830145,10_2207830220,12_2207830244,13_2207830312,15_2207830336,16_2207830343... (4 Replies)
Discussion started by: niki0211
4 Replies

2. UNIX for Dummies Questions & Answers

Remove a column using vi editor

How do i remove a column using vi editor Assuming the file to be of format 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... (6 Replies)
Discussion started by: sp0
6 Replies

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

4. Shell Programming and Scripting

Help with remove the column that appear twice

Input file 1 S1 S2 S3 comp95_c1 1.00 comp95_c1 1.00 3.00 comp4_c0 6.00 comp4_c0 6.00 6.00 comp3_c0 0.00 comp3_c0 0.00 4.00 comp15_c1 3.00 comp15_c1 3.00 3.00... (8 Replies)
Discussion started by: perl_beginner
8 Replies

5. Shell Programming and Scripting

Remove the first character from the fourth column only if the column has four characters

I have a file as follows ATOM 5181 N AMET K 406 12.440 6.552 25.691 0.50 7.37 N ATOM 5182 CA AMET K 406 13.685 5.798 25.578 0.50 5.87 C ATOM 5183 C AMET K 406 14.045 5.179 26.909 0.50 5.07 C ATOM 5184 O MET K... (14 Replies)
Discussion started by: hasanabdulla
14 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. 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

8. Shell Programming and Scripting

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 (8 Replies)
Discussion started by: srimitta
8 Replies

9. Shell Programming and Scripting

remove a column of data

Hi my file has two columns: GAII_4:6:100:548:645/1 GTACACAACCCCCCCCCCCCACCCCACCCCCCCCCCCCCC GAII_4:6:100:1:1242/1 AGTCTGCCCCTCCCCCTNNNNNNNTCTTTTNCCTCCTCCT GAII_4:6:100:444:504/1 GTAACACACACCCTGATACTCCCCCCTCCACAACCGCTCT I want to remove the first column and keep only the scond column so it... (1 Reply)
Discussion started by: jdhahbi
1 Replies

Featured Tech Videos