Sponsored Content
Top Forums Shell Programming and Scripting Modifying col values based on another col Post 302761313 by Corona688 on Friday 25th of January 2013 12:17:07 PM
Old 01-25-2013
excel can so easily export and import tab-separated data that there's little point installing 19,000 perl modules and writing 3,000 lines of code just to write excel files.

Excel files are more complicated in several ways, too. You have to start worrying about multiple worksheets for instance, formulas, merged columns, and all of that. And the .xlsx files are particularly obnoxious.
This User Gave Thanks to Corona688 For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Help On col command

Hello Can Any1 tell me the difference between the col command and the col command with the -f option. I tried running both of them but i can't see any difference. Please guide me. (1 Reply)
Discussion started by: rahulrathod
1 Replies

2. UNIX for Dummies Questions & Answers

Info about col command

Hello every1. Can any1 help me with the col command. Wat is a reverse line feed. Which kind of files u need to use the col command. (2 Replies)
Discussion started by: rahulrathod
2 Replies

3. Shell Programming and Scripting

Awk to print distinct col values

Hi Guys... I am newbie to awk and would like a solution to probably one of the simple practical questions. I have a test file that goes as: 1,2,3,4,5,6 7,2,3,8,7,6 9,3,5,6,7,3 8,3,1,1,1,1 4,4,2,2,2,2 I would like to know how AWK can get me the distinct values say for eg: on col2... (22 Replies)
Discussion started by: anduzzi
22 Replies

4. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Hello, I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file. For example: File 1 has 1411 rows, I ignore how many columns it has (thousands) File 2 has 311 rows, 1 column Would like to... (7 Replies)
Discussion started by: sogi
7 Replies

5. Shell Programming and Scripting

i can't cut the third col

SW_dist_intr false Enable SW distribution of interrupts True autorestart true Automatically REBOOT OS after a crash True boottype disk N/A False capacity_inc 1.00 ... (7 Replies)
Discussion started by: maxim42
7 Replies

6. Shell Programming and Scripting

How to Delete the First Blank of the First Col?

Hi to all. In the following example, how can I delete the first blank of the first col? (using shell scripting) first second third fourth fifth sixth seventh eighth Thank's for reading. (5 Replies)
Discussion started by: daniel.gbaena
5 Replies

7. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

8. Shell Programming and Scripting

Printing from col x to end of line, except last col

Hello, I have some tab delimited data and I need to move the last col. I could hard code it, awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile but it would be nice to know the syntax to print a range cols. I know in cut you can do, cut -f 1,4-8,11- to print fields 1,... (8 Replies)
Discussion started by: LMHmedchem
8 Replies

9. Shell Programming and Scripting

How to mark the row based on col value.?

Hi Gurus, I have requirement to identify the records based on one column value. the sample file as below: ID AMT, AMT1 100,10, 2 100,20, 3 200,30, 0 200, 40, 0 300, 20, 2 300, 50, 2 400, 20, 1 400, 60, 0 for each ID, there 2 records, if any one record amt1 is 0, the in 4th col add... (5 Replies)
Discussion started by: ken6503
5 Replies

10. Emergency UNIX and Linux Support

Read values in each col starting 3rd row.Print occurrence value.

Hello Friends, Hope all are doing fine. Here is a tricky issue. my input file is like this 07 10 14 20 21 03 15 27 30 32 01 10 11 19 30 02 06 14 15 17 01 06 20 25 29 Logic: 1. Please print another column as "0-0-0-0-0" for the first and second rows. 2. Read the first column... (4 Replies)
Discussion started by: jacobs.smith
4 Replies
resize(1X)							     MIT X11R4								resize(1X)

Name
       resize - utility to set TERMCAP and terminal settings to current window size

Syntax
       resize [-u] [-s [row col]]

Description
       The  uitility  prints  a  shell command for setting the TERM and TERMCAP environment variables to indicate the current size of xterm window
       from which the command is run. For this output to take effect, resize must either be evaluated as part of the command  line  (usually  done
       with  a	shell alias or function) or else redirected to a file which can then be read in. From the C shell (usually known as /bin/csh), the
       following alias could be defined in the user's .cshrc:

	   % alias rs 'set noglob; `eval resize`'

       After resizing the window, the user would type:

	   % rs

       Users of versions of the Bourne shell (usually known as /bin/sh) that do not have command functions will need to send the output to a  tem-
       porary file and the read it back in with the ``.'' command:

	   $ resize >/tmp/out
	   $ . /tmp/out

Options
       The following options may be used with resize:

       -u      This option indicates that Bourne shell commands should be generated even if the user's current shell is not /bin/sh.

       -c      This option indicates that C shell commands should be generated even if the user's current shell is not /bin/csh.

       -s [rows columns]
	       This option indicates that the Sun console escape sequences will be used instead of the special xterm escape code. If rows and col-
	       umns are given, resize will ask the xterm to resize itself. However, the window manager may choose to disallow the change.

Restrictions
       The -u or -c must appear to the left of -s if both are specified.

       There should be some global notion of display size; termcap and terminfo need to be rethought in the context of window systems.	(Fixed	in
       4.3BSD, and ULTRIX-32 1.2)

Files
       For the base termcap entry to modify.

       User's alias for the command.

See Also
       csh(1), tset(1), xterm(1X)

																	resize(1X)
All times are GMT -4. The time now is 05:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy