05-21-2013
Hi all,
It worked, thanks. But now i realized that even the whole .txt file is tab delimited the first row is space delimited and this is causing me a lot of problems.
Is there any way to change the whole first row to be tab delimited instead of space delimited?
Thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
$ cat log.txt
Name Age Sex Lcation nfld alias xsd
CC 25 M XYZ asx KK Y
BB 21 F XAS awe SS N
SD 21 M AQW rty SD A
How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column?
so that the final output will become:
Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies
2. Shell Programming and Scripting
Hello all,
We are trying to run a script in Oracle DB from AIX.
We need to set the Column Header while executing the query to generate the Output.
For eg.
select city, name from emp;
It need to generate report in .csv format as
CITY NAME
atla tom
cincin jack
How I... (1 Reply)
Discussion started by: velappangs
1 Replies
3. Shell Programming and Scripting
using awk to substitute data in a column delimited text file
hello i would like to use awk to do the following calculation from the following snippet.
input file
C;2390 ;CV BOUILLOTTE 2L 2FACES NERVUREES ;1.00 ;3552612239004;13417 ;25 ;50 ; 12;50000 ; ; ... (3 Replies)
Discussion started by: iindie
3 Replies
4. Shell Programming and Scripting
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies
6. Shell Programming and Scripting
Hi,
I have a file which has multiple columns in and i want to replace first column with : in between them.
input_file
21000012343456 asdf
21000012343478 asd3
21000012343423 asdf
21000012343445 asdf
21000012343489 asdf
output file
21:00:00:12:34:34:56 asdf
21:00:00:12:34:34:78 asd3... (6 Replies)
Discussion started by: jpkumar10
6 Replies
7. Shell Programming and Scripting
A file
2400 2800 PSC000289
3200 3896 PCS000289
3333 3666 PCS000221
222 1000 PCS000222
3299 3600 PSC000289
Question is while if third column is PCS000289
and first column should be greater than 3000, then replace PCS000289 by YES,
remaining the others column same.
... (1 Reply)
Discussion started by: cdfd123
1 Replies
8. Shell Programming and Scripting
Hi,
I have an input like this
1 2 3 4
2 3 4 5
4 5 6 7
I would like to count the no. of columns and print a header with a prefix "Col".
I would also like to count the no. of rows and print as first column with each line number with a prefix "Row"
So, my output would be
... (2 Replies)
Discussion started by: jacobs.smith
2 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have files with lines that look like
HSQ1008:141:D0CC8ACXX:3:1106:17255:124378 163 chr14
I'm wondering how I can output a file that appends /1 if the second column is 99 or 83 and a /2 if the second column is 163 or 147. Also I want to put \n + \n between each the second... (1 Reply)
Discussion started by: jyu429
1 Replies
10. Shell Programming and Scripting
Hello,
I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically
I/p
c1,c2,c3,c4,c5
10,20,30,40,50
20,30,40,50,60
If i want to find sum only column c1, c3 and output it as c6,c7
O/p
c1,c2,c3,c4,c5,c6,c7
10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies
CATMAN(8) Manual pager utils CATMAN(8)
NAME
catman - create or update the pre-formatted manual pages
SYNOPSIS
catman [-dhV] [-M path] [-C file] [section] ...
DESCRIPTION
catman is used to create an up to date set of pre-formatted manual pages known as cat pages. Cat pages are generally much faster to dis-
play than the original manual pages, but require extra storage space. The decision to support cat pages is that of the local administra-
tor, who must provide suitable directories to contain them.
The options available to catman are the manual page hierarchies and sections to pre-format. The default hierarchies are those specified as
system hierarchies in the man-db configuration file, and the default sections are either the colon-delimited contents of the environment
variable $MANSECT or the standard set compiled into man if $MANSECT is undefined. Supplying catman with a set of whitespace-delimited sec-
tion names will override both of the above.
catman makes use of the index database cache associated with each hierarchy to determine which files need to be formatted.
OPTIONS
-d, --debug
Print debugging information.
-M path, --manpath=path
Specify an alternate colon-delimited manual page hierarchy search path. By default, this is all paths indicated as system hierar-
chies in the man-db configuration file.
-C file, --config-file=file
Use this user configuration file rather than the default of ~/.manpath.
-h, --help
Print a help message and exit.
-V, --version
Display version information.
ENVIRONMENT
MANSECT
If $MANSECT is set, its value is a colon-delimited list of sections and it is used to determine which manual sections to search and
in what order.
MANPATH
If $MANPATH is set, its value is interpreted as the colon-delimited manual page hierarchy search path to use.
FILES
/etc/manpath.config
man-db configuration file.
/usr/man/index.(bt|db|dir|pag)
A traditional global index database cache.
/var/catman/index.(bt|db|dir|pag)
An alternate or FSSTND compliant global index database cache.
SEE ALSO
man(1), manpath(5), mandb(8).
AUTHOR
Wilf. (G.Wilford@ee.surrey.ac.uk).
Fabrizio Polacco (fpolacco@debian.org).
Colin Watson (cjwatson@debian.org).
2.6.0.2 2011-04-13 CATMAN(8)