adding columns Post: 12741

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Adding columns in csv

I have the following data in FILE1.CSV: code: Amount1: Amount2: xxxxx ,, 200 ,,400 yyxxa ,,200 bbcgu ,,2500 ,,300 i want to be able to produce the following FILE2.CSV: code: Amount xxxxx ,, 600...

2. UNIX for Dummies Questions & Answers

I want to select the first column from a daily file called foo.csv. The result is written to file foo.txt. Currently the following script is used for that: cut -d, -f 1 foo.csv > foo.txt A typical result would yield : A12 A45 B11 B67 What needs to happen in addition is that two columns...

3. Shell Programming and Scripting

Adding columns of two files

Hello everyone, I have two files containing 6 columns and thousands of rows. I want to add them (i.e. first column of first file + first column of second file and so on) and print the output in a third file. Can you please help me. Thanks a lot

4. UNIX for Dummies Questions & Answers

Adding lines and columns to a file

Hi everybody, I've got two simples file1 like: aaa aaa aaa bbb bbb bbb ccc ccc ccc and file2 like: 111 111 111 222 222 222 333 333 333 I need to: 1) add a line say "new line" as the first line of the file 2)add a column from file2 (say column3) to file1; the new column should...

5. UNIX for Dummies Questions & Answers

Adding loads of columns

Hi All, I've got file1 like this: aaa bbb ccc ddd eee fff ggg hhh kkk ppp mmm nnn and file 2 like this: aaa qqq www ddd fff ggg ggg sss zzz ppp vvv yyy and file 3 like this: aaa ggg ppp I need to match the first column of file3 and file1, then add the rest of the file 1 to...

6. Shell Programming and Scripting

sorting and adding columns

i have a file with two columns, and i want to uniquely sort the values in fist column and add the corresponding values in the second columns eg file a contents tom 200 john 300 sow 500 tom 800 james 50 sow 300 output shpould be in file b as tom 1000 john 300 sow 800 james 50

7. Shell Programming and Scripting

Adding columns of time

Hello all, I'm in the process of writing a script, and I need to be able to add columns of time in the following format (time elapsed Net Backup logs): 000:01:03 000:00:58 000:00:49 Does anyone have a way of converting and/or adding timestamps such as these accurately? Thanks in...

8. Shell Programming and Scripting

Help with ask adding columns

Hello, I am using AWK in UBUNTU 12.04. I have a dataset as follows: 1 2 12 1 4 1 4 1 7 9 4 6 1 2 4 5 7 8 45 7 4 5 7 5 What I want to do is to add the values of some columns to each other and print it in the same file as the new column while omitting the previous two columns to have...

9. Shell Programming and Scripting

Adding columns with values dependent on existing columns

Hello I have a file as below chr1 start ref alt code1 code2 chr1 18884 C CAAAA 2 0 chr1 135419 TATACA T 2 0 chr1 332045 T TTG 0 2 chr1 453838 T TAC 2 0 chr1 567652 T TG 1 0 chr1 602541 ...

10. Shell Programming and Scripting

Adding columns from 2 files with variable number of columns

I have two files, file1 and file2 who have identical number of rows and columns. However, the script is supposed to be used for for different files and I cannot know the format in advance. Also, the number of columns changes within the file, some rows have more and some less columns (they are...

LEARN ABOUT OSF1

mkmanifest

mkmanifest(1)						      General Commands Manual						     mkmanifest(1)

NAME

       mkmanifest - mtools utility to create a shell script to restore UNIX file names from DOS

SYNOPSIS

       mkmanifest [files]

OPTIONS

       None

OPERANDS

       A list of UNIX file names to be converted to DOS name format.

DESCRIPTION

       The  mkmanifest	command creates a shell script that aids in the restore of UNIX file names that were overwritten by DOS file name restric-
       tions.  DOS file names are uppercase only, cannot exceed 8 character names, 3 character extensions and do not support device names or  non-
       alphanumeric characters.

       Not all UNIX file names are supported in the DOS world.	The mtools commands may have to change UNIX names to fit the DOS file name conven-
       tions.  Most commands provide the verbose option (-v), that displays new file names if they have been changed. The  following  table  shows
       some examples of file name conversions:

       -----------------------------------------------
       UNIX name     DOS name	Reason for the change
       -----------------------------------------------
       thisisatest   THISISAT	file name too long
       file.stuff    FILE.STU	extension too long
       prn.txt	     XRN.TXT	PRN is a device name
       .abc	     X.ABC	null file name
       hot+cold      HOTXCOLD	illegal character
       -----------------------------------------------

EXIT STATUS

       The following exit values are returned: Success.  Failure.

EXAMPLES

       Assume you have the following UNIX files that you want to copy to a DOS diskette using the mcopy command.

       very_long_name 2.many.dots illegal: good.c prn.dev Capital

       The mcopy command converts these file names to the following:

       very_lon 2xmany.dot illegalx good.c xprn.dev capital

       To restore the previous file names, use the mkmanifest command as follows: mkmanifest very_long_name 2.many.dots illegal:       
				  good.c prn.dev Capital > manifest

       The  previous  mkmanifest command line produces the following: mv very_lon very_long_name mv 2xmany.dot 2.many.dots mv illegalx illegal: mv
       xprn.dev prn.dev mv capital Capital

       The good.c file name did not require conversion, hence it was not included in the output.

       If these files were copied from diskette to another UNIX system, and you wanted to restore the original names, retain a copy of	the  mani-
       fest file (captured output) so that it can be used to convert the file names again.

FILES

       Executable file

SEE ALSO

       Commands: mcopy(1), mtools(1)

																     mkmanifest(1)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Adding columns in csv

Discussion started by: chachabronson

2. UNIX for Dummies Questions & Answers

Adding columns to a file

Discussion started by: figaro