Hi Wise UNIX Crew,
I want to add 3 different columns to the file in which:
1. The first new column pulls in today's date and time
2. Second column one has a '0'
3. Third column has the word 'ANY' going down the column
If my file content is as follows:
"7","a","abc",123"... (1 Reply)
Hi,
I have a script which creates and modifies a csv file.
I have managed to do everything I need to do apart from 1 thing. I need to append a trailer record to the file. I need this line to hold the total of an entire column of the csv file (skipping the 1st line which is a header).
Can... (2 Replies)
Hi Everyone:
My shell script creates multiple csv files (~30) in for loop. I want to compile (or merge) 3rd column from each (all) of these files to another file (in loop). Please help. Thanks. (3 Replies)
Hi experts
I have a .csv file which contains
the csv is comma seperated file
col1 col2
1 2
3 4
5 6
7 8
I want the colums to be added and the output must be
col1 col2 col3
1 2 3
3 4 7
5 6 11
7 8 15
Please help:( (1 Reply)
I saved the csv file in a comma delimited format.
Sample input
input.csv
1 abc 2
2 def 4
3 ghi 6
4 jkl 8
5 mno 10
output.csv should look like this with single quotes around each field
'1' 'abc' '2'
'2' 'def' '4'
'3' 'ghi' '6'
'4' 'jkl' '8'
'5' 'mno' '10'
Please help me :confused:... (3 Replies)
Trying in this forum. Not sure if it is permitted.... but in need of help.
Please find the requirements in the below link.
https://www.unix.com/unix-dummies-questions-answers/191503-add-extra-commas-csv-file-2.html#post302665179
Thanks in Advance. (1 Reply)
Hi,
Can anyone please explain me how can I add a new column to a Csv file ?
Actaully I am setting one set of commands and creating a CSV file with 4 columns.
I am executing another command and it's output should be added as column 5 with a column heading ?
Can anyone explain how can... (26 Replies)
There are files in a directory and I have to move multiple files adding datetimestamp before the file type.
/Data/
abc.csv
def.csv
ghi.csv
I have to move this files to archive directory adding datatimestamp before .csv
/archive/
abc_YYYYMMDDHHMMSS.csv
def_YYYYMMDDHHMMSS.csv... (7 Replies)
Discussion started by: eskay
7 Replies
LEARN ABOUT OPENDARWIN
times
times(1) User Commands times(1)NAME
times - shell built-in function to report time usages of the current shell
SYNOPSIS
sh
times
ksh
times
DESCRIPTION
sh
Print the accumulated user and system times for processes run from the shell.
ksh
Print the accumulated user and system times for the shell and for processes run from the shell.
On this man page, ksh(1) commands that are preceded by one or two * (asterisks) are treated specially in the following ways:
1. Variable assignment lists preceding the command remain in effect when the command completes.
2. I/O redirections are processed after variable assignments.
3. Errors cause a script that contains them to abort.
4. Words, following a command preceded by ** that are in the format of a variable assignment, are expanded with the same rules as a vari-
able assignment. This means that tilde substitution is performed after the = sign and word splitting and file name generation are not
performed.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO ksh(1), sh(1), time(1), attributes(5)SunOS 5.10 15 Apr 1994 times(1)