I have a csv file looking like:
echo,w-cai,w-cai-ssl
echo,countrywide,countrywide-ssl
haystack,intranet3,intranet3-ssl
haystack,pnf,pnf-ssl
Basically, I want to process this file row by row assigning each word delimited by a comma to a variable.
ie. for the first row, $variable1=echo... (5 Replies)
I have written an script which will excluded some records from .csv file and put it on another excluded file from primary file.This is working very fine.Now the problem is that I want to delete those excluded lines from Primary file but not able to delete it.
I have stored the line number in... (1 Reply)
Hello
So I understand when I do the following
used_ports=$(netstat -nat |cut -d : -f 2 |cut -d ' ' -f 1)
that the output will look like this
Active Proto 5298 22 631 55012 56093 39672 43196 56619 39677 36103
38453 41413 56137 37902 41410 41414 43195 38426 49253 38420 34273 ... (1 Reply)
Hello,
Does anyone have a one-liner to remove lines of a csv file if the value in a specific column is zero? For example, I have this file,
12345,COM,5,0,N,29.95,Y
12345,MOM,1,0,N,29.95,Y
12345,COM,4,0,N,9.99,Y
12345,MOM,0,2,N,9.99,Y
12345,REN,0,1,N,9.99,Y
and I want to remove lines... (4 Replies)
Hi Fellows,
I have been struggling to fix an issue in csv records to compose sql statements and have been really losing sleep over it. Here is the problem:
I have csv files in the following pipe-delimited format:
Column1|Column2|Column3|Column4|NEWLINE
Address Type|some descriptive... (4 Replies)
Hi,
I have the following test script I'm working with:
date +"%m-%d-%y">>test.log
grep eth0 /proc/net/dev | awk '{print ",",$2/1024/1024,",",$10/1024/1024}'>>test.log
The output looks like this:
02-25-12
, 19.3581 , 84.2826
02-25-12
, 19.3587 , 84.283
02-25-12
, 19.3587 ,... (4 Replies)
Hi Guys,
Would need your expert help with the following situation..
I have a comma seperated .csv file, with a header row and data as follows
H1,H2,H3,H4,H5..... (header row)
0,0,0,0,0,1,2.... (data rows follow)
0,0,0,0,0,0,1
.........
.........
i need a code... (10 Replies)
have written a combined sed+awk to perform a lookup operation which works but looking to enhance it.
looking to match a record using any of the comma separated values + return selected fields from the record - including the field header. so:
cat foo
make,model,engine,trim,value... (6 Replies)
Hi,
I want to duplicate lines of a csv file with header if a column has multiple values. The csv uses semicolon as separator while multiple values are separated with comma. Only the type3 column can have multiple values.
input:
type1;type2;type3
a1;b1;x,y
a2;b2;z
output:
a1;b1;x... (2 Replies)
Hi..
I need some help in converting the below horizontal lines to vertical lines format.
can anyone help me on this.
input file
Hour,1,2,3,4,5
90RT,106,111,111,112,111
output file
Hour,90RT
1,106
2,111
3,111
4,112
5,111 (3 Replies)
Discussion started by: Raghuram717
3 Replies
LEARN ABOUT SUNOS
pkgproto
pkgproto(1) User Commands pkgproto(1)NAME
pkgproto - generate prototype file entries for input to pkgmk command
SYNOPSIS
pkgproto [-i] [-c class] [path1]
pkgproto [-i] [-c class] [path1=path2...]
DESCRIPTION
pkgproto scans the indicated paths and generates prototype(4) file entries that may be used as input to the pkgmk(1) command.
If no paths are specified on the command line, standard input is assumed to be a list of paths. If the pathname listed on the command line
is a directory, the contents of the directory is searched. However, if input is read from stdin, a directory specified as a pathname will
not be searched.
OPTIONS -i Ignores symbolic links and records the paths as ftype=f (a file) versus ftype=s (symbolic link).
-c class Maps the class of all paths to class.
OPERANDS
path1 Pathname where objects are located.
path2 Pathname which should be substituted on output for path1.
EXAMPLES
Example 1: Examples of the use of pkgproto.1.
The following two examples show uses of pkgproto and a partial listing of the output produced.
Example 1:
example% pkgproto /bin=bin /usr/bin=usrbin /etc=etc
f none bin/sed=/bin/sed 0775 bin bin
f none bin/sh=/bin/sh 0755 bin daemon
f none bin/sort=/bin/sort 0755 bin bin
f none usrbin/sdb=/usr/bin/sdb 0775 bin bin
f none usrbin/shl=/usr/bin/shl 4755 bin bin
d none etc/master.d 0755 root daemon
f none etc/master.d/kernel=/etc/master.d/kernel 0644 root daemon
f none etc/rc=/etc/rc 0744 root daemon
Example 2:
example% find / -type d -print | pkgproto
d none / 755 root root
d none /bin 755 bin bin
d none /usr 755 root root
d none /usr/bin 775 bin bin
d none /etc 755 root root
d none /tmp 777 root root
EXIT STATUS
0 Successful completion.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO pkgmk(1), pkgparam(1), pkgtrans(1), prototype(4), attributes(5)
Application Packaging Developer's Guide
NOTES
By default, pkgproto creates symbolic link entries for any symbolic link encountered (ftype=s). When you use the -i option, pkgproto cre-
ates a file entry for symbolic links (ftype=f). The prototype(4) file would have to be edited to assign such file types as v (volatile), e
(editable), or x (exclusive directory). pkgproto detects linked files. If multiple files are linked together, the first path encountered is
considered the source of the link.
By default, pkgproto prints prototype entries on the standard output. However, the output should be saved in a file (named Prototype or
prototype, for convenience) to be used as input to the pkgmk(1) command.
SunOS 5.10 6 Nov 2000 pkgproto(1)