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
@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';
$
$ 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'
$
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)
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)
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)
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)
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)
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)
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)