Sponsored Content
Top Forums Shell Programming and Scripting Help with remove the column that appear twice Post 302850483 by perl_beginner on Thursday 5th of September 2013 12:12:57 AM
Old 09-05-2013
Help with remove the column that appear twice

Input file 1
Code:
                    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
comp28_c0    33.00    comp28_c0      33.00     2.00
comp23_c0    4.00      comp23_c0      4.00       3.00

Desired output file 1
Code:
                    S1        S2          S3
comp95_c1    1.00      1.00       3.00
comp4_c0      6.00      6.00      6.00
comp3_c0      0.00      0.00      4.00
comp15_c1    3.00      3.00      3.00
comp28_c0    33.00    33.00     2.00
comp23_c0    4.00      4.00       3.00

Input file 2
Code:
                       S1             S2                             S3
comp5_c1         1.00           1.00       comp5_c1      3.00
comp40_c0       6.00            6.00      comp40_c0     6.00
comp31_c0       0.00            0.00      comp31_c0     4.00
comp51_c1       3.00            3.00      comp51_c1     3.00
comp82_c0       33.00          33.00     comp82_c0     2.00
comp3_c0        4.00            4.00       comp3_c0      3.00

Desired output file 2
Code:
                       S1             S2         S3
comp5_c1         1.00           1.00      3.00
comp40_c0       6.00            6.00      6.00
comp31_c0       0.00            0.00      4.00
comp51_c1       3.00            3.00      3.00
comp82_c0       33.00          33.00     2.00
comp3_c0        4.00            4.00       3.00

I hope can remove the column (compXXX) that appear twice.
All the files are tab delimited.

Thanks for any advice.
 

9 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

to remove the last column

Hi Guys, I want to remove the last column of my file.. My file looks like this.. 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... (12 Replies)
Discussion started by: mac4rfree
12 Replies

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

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

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

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

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

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

9. 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
Tk_GeometryRequest(3)					       Tk Library Procedures					     Tk_GeometryRequest(3)

__________________________________________________________________________________________________________________________________________________

NAME
Tk_GeometryRequest, Tk_SetMinimumRequestSize, Tk_SetInternalBorder, Tk_SetInternalBorderEx - specify desired geometry or internal border for a window SYNOPSIS
#include <tk.h> Tk_GeometryRequest(tkwin, reqWidth, reqHeight) Tk_SetMinimumRequestSize(tkwin, minWidth, minHeight) Tk_SetInternalBorder(tkwin, width) Tk_SetInternalBorderEx(tkwin, left, right, top, bottom) ARGUMENTS
Tk_Window tkwin (in) Window for which geometry is being requested. int reqWidth (in) Desired width for tkwin, in pixel units. int reqHeight (in) Desired height for tkwin, in pixel units. int minWidth (in) Desired minimum requested width for tkwin, in pixel units. int minHeight (in) Desired minimum requested height for tkwin, in pixel units. int width (in) Space to leave for internal border for tkwin, in pixel units. int left (in) Space to leave for left side of internal border for tkwin, in pixel units. int right (in) Space to leave for right side of internal border for tkwin, in pixel units. int top (in) Space to leave for top side of internal border for tkwin, in pixel units. int bottom (in) Space to leave for bottom side of internal border for tkwin, in pixel units. _________________________________________________________________ DESCRIPTION
Tk_GeometryRequest is called by widget code to indicate its preference for the dimensions of a particular window. The arguments to Tk_GeometryRequest are made available to the geometry manager for the window, which then decides on the actual geometry for the window. Although geometry managers generally try to satisfy requests made to Tk_GeometryRequest, there is no guarantee that this will always be possible. Widget code should not assume that a geometry request will be satisfied until it receives a ConfigureNotify event indicating that the geometry change has occurred. Widget code should never call procedures like Tk_ResizeWindow directly. Instead, it should invoke Tk_GeometryRequest and leave the final geometry decisions to the geometry manager. If tkwin is a top-level window, then the geometry information will be passed to the window manager using the standard ICCCM protocol. Tk_SetInternalBorder is called by widget code to indicate that the widget has an internal border. This means that the widget draws a deco- rative border inside the window instead of using the standard X borders, which are external to the window's area. For example, internal borders are used to draw 3-D effects. Width specifies the width of the border in pixels. Geometry managers will use this information to avoid placing any children of tkwin overlapping the outermost width pixels of tkwin's area. Tk_SetInternalBorderEx works like Tk_SetInternalBorder but lets you specify different widths for different sides of the window. Tk_SetMinimumRequestSize is called by widget code to indicate that a geometry manager should request at least this size for the widget. This allows a widget to have some control over its size when a propagating geometry manager is used inside it. The information specified in calls to Tk_GeometryRequest, Tk_SetMinimumRequestSize, Tk_SetInternalBorder and Tk_SetInternalBorderEx can be retrieved using the macros Tk_ReqWidth, Tk_ReqHeight, Tk_MinReqWidth, Tk_MinReqHeight, Tk_MinReqWidth, Tk_InternalBorderLeft, Tk_Internal- BorderRight, Tk_InternalBorderTop and Tk_InternalBorderBottom. See the Tk_WindowId manual entry for details. KEYWORDS
geometry, request Tk 8.4 Tk_GeometryRequest(3)
All times are GMT -4. The time now is 06:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy