Sponsored Content
Top Forums Shell Programming and Scripting Getting cut to ignore cols in middle of records Post 303007243 by apmcd47 on Tuesday 14th of November 2017 11:10:33 AM
Old 11-14-2017
Quote:
Originally Posted by wbport
I recently had to remove a number of columns from a sorted copy of a file, but couldn't get the cut command to take fields out, just what to keep. This is the only thing I could find as an example, but could it be simplified?
Code:
tstamp=`date +%H%M%S`
grep -v "T$" filename |egrep -v "^$" |sort 2>/dev/null >/usr/tmp/aaa.x$tstamp
cut -c 1-78 /usr/tmp/aaa.x$tstamp > /usr/tmp/bbb.x$tstamp
cut -c 80 /usr/tmp/aaa.x$tstamp > /usr/tmp/ccc.x$tstamp
paste -d '\0' /usr/tmp/bbb.x$tstamp /usr/tmp/ccc.x$tstamp
rm /usr/tmp/*.x$tstamp

Could this be reduced to just one cut (or some other) command? The above just took out one character so everything would appear on one line, but I had to take out much more than that.

TIA
Doesn't this work?
Code:
grep -v "T$" filename |egrep -v "^$" |sort | cut -c 1-78,80

Could the two greps also be condensed into
Code:
egrep -v 'T$|^$' filename ...

Andrew
This User Gave Thanks to apmcd47 For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

cut specific records from a file

I am trying to cut the first 10 characters from a file only if the file has 'xyz' in field 185-188. I tried this cat filename | cut -c1-10 but this gives me all the records regardless of what is in field 185-188. Is this doable ? Thanks in advance for responses. (2 Replies)
Discussion started by: jxh461
2 Replies

2. Shell Programming and Scripting

Grouping matches by cols

Dear all I have a large file w. ~ 10 million lines. The first two cols have matching partners. For example: A A A B B B or A A B A B B The matches may be separated by an unknown number of lines. My intention is to group them and add a "group" value in the last col. For... (12 Replies)
Discussion started by: gbalsu
12 Replies

3. Shell Programming and Scripting

How to find number of Cols in a file ?

Hi I have a requirement wherein the file is comma separated. Each records seems to have different number of columns, how I can detect like a row index wise, how many columns are present ? Thanks in advance. (2 Replies)
Discussion started by: videsh77
2 Replies

4. UNIX for Dummies Questions & Answers

Cut specific fields from a file containing multiline records

Hi, I am looking for a method to get column13 to column 50 data from the 1st line of a multiline reord. The records are stored in a large file and are separated by newline. sample format is (data in red is to be extracted) <header> A001dfhskhfkdsh hajfhksdhfjh... (3 Replies)
Discussion started by: sunayana3112
3 Replies

5. Programming

Curses not updating LINES/COLS

I'm working with an extremely outdated and old system at work. We do not have ncurses, but we do have curses. I need to make a user interface for users connecting with xterm. One issue I've encountered is if the user resizes the window, I'd like to provide functionality to redraw the screen with... (4 Replies)
Discussion started by: nwboy74
4 Replies

6. Shell Programming and Scripting

Ignore records with no values through awk

Hi Guys, Hope you are doing well out there. I have to format the output of a script. Current output is auktltbr.dc-dublin.de:4322 ICCIR2Test13-PB-01 active auktltbr.dc-dublin.de:8322 ICCIR2Test13-SB-02 active auktlttr.dc-dublin.de:4422 ICCIR2Test24-CB-02 active... (10 Replies)
Discussion started by: singh.chandan18
10 Replies

7. Shell Programming and Scripting

awk -- print combinations for 2 cols

Dear all, could you please help me with awk please? I have such input: Input: a d b e c f The number of lines is unknown before reading the file. I need to print possible combination between the two columns like this: Output: a d b d c d a e b e c e a f (2 Replies)
Discussion started by: irrevocabile
2 Replies

8. Shell Programming and Scripting

how to Insert values in multiple lines(records) within a pipe delimited text file in specific cols

this is Korn shell unix. The scenario is I have a pipe delimited text file which needs to be customized. say for example,I have a pipe delimited text file with 15 columns(| delimited) and 200 rows. currently the 11th and 12th column has null values for all the records(there are other null columns... (4 Replies)
Discussion started by: vasan2815
4 Replies

9. Shell Programming and Scripting

Bitwise comparison of cols

Hello, I want to compute the bitwise number of matches in pairwise fashion for all columns. The problem is I have 18486955 rows and 750 columns. Please help with code, I believe this will take a lot of time, is there a way of tracking progress? Input Org1 Org2 Org3 A A T A ... (9 Replies)
Discussion started by: ritakadm
9 Replies

10. Shell Programming and Scripting

Awk/sed/cut to filter out records from a file based on criteria

I have two files and would need to filter out records based on certain criteria, these column are of variable lengths, but the lengths are uniform throughout all the records of the file. I have shown a sample of three records below. Line 1-9 is the item number "0227546_1" in the case of the first... (15 Replies)
Discussion started by: MIA651
15 Replies
XCUTSEL(1)						      General Commands Manual							XCUTSEL(1)

NAME
xcutsel - interchange between cut buffer and selection SYNOPSIS
xcutsel [ -toolkitoption ...] [-selection selection] [-cutbuffer number] DESCRIPTION
The xcutsel program is used to copy the current selection into a cut buffer and to make a selection that contains the current contents of the cut buffer. It acts as a bridge between applications that don't support selections and those that do. By default, xcutsel will use the selection named PRIMARY and the cut buffer CUT_BUFFER0. Either or both of these can be overridden by com- mand line arguments or by resources. An xcutsel window has the following buttons: quit When this button is pressed, xcutsel exits. Any selections held by xcutsel are automatically released. copy PRIMARY to 0 When this button is pressed, xcutsel copies the current selection into the cut buffer. copy 0 to PRIMARY When this button is pressed, xcutsel converts the current contents of the cut buffer into the selection. The button labels reflect the selection and cutbuffer selected by command line options or through the resource database. When the ``copy 0 to PRIMARY'' button is activated, the button will remain inverted as long as xcutsel remains the owner of the selection. This serves to remind you which client owns the current selection. Note that the value of the selection remains constant; if the cutbuffer is changed, you must again activate the copy button to retrieve the new value when desired. OPTIONS
Xcutsel accepts all of the standard X Toolkit command line options as well as the following: -selection name This option specifies the name of the selection to use. The default is PRIMARY. The only supported abbreviations for this option are ``-select'', ``-sel'' and ``-s'', as the standard toolkit option ``-selectionTimeout'' has a similar name. -cutbuffer number This option specifies the cut buffer to use. The default is cut buffer 0. X DEFAULTS
This program accepts all of the standard X Toolkit resource names and classes as well as: selection (class Selection) This resource specifies the name of the selection to use. The default is PRIMARY. cutBuffer (class CutBuffer) This resource specifies the number of the cut buffer to use. The default is 0. WIDGET NAMES
The following instance names may be used when user configuration of the labels in them is desired: sel-cut (class Command) This is the ``copy SELECTION to BUFFER'' button. cut-sel (class Command) This is the ``copy BUFFER to SELECTION'' button. quit (class Command) This is the ``quit'' button. SEE ALSO
X(7), xclipboard(1), xterm(1), text widget documentation, individual client documentation for how to make a selection. BUGS
There is no way to change the name of the selection or the number of the cut buffer while the program is running. AUTHOR
Ralph R. Swick, DEC/MIT Project Athena X Version 11 xclipboard 1.1.2 XCUTSEL(1)
All times are GMT -4. The time now is 06:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy