Comma delimited row into multiple rows, repeat first value
i am building a database to keep track of unix groups.
Using the command "ypcat group"
I get an output similar to the following
I want to convert this output so it looks like this
using two sed commands i've gotten to this point
I know there is a way to preappend the group lines to the other lines with the hold function in sed but i can't seem to get it right. There is also probably an awk command to accomplish this.
The sed command should look similar to this but it has no affect:
I would like to know code that will delete multiple text from a comma delimited file. For example, how would the comma delimited file below delete the word 'PEST' in Perl language (previously an excel file that was converted to a csv and the last column was PEST):
1, 2,43,34, bosx,PEST
1,... (1 Reply)
Please advice script for changing from A to B
I'd like to Split a row to multiple rows with 4 columns using shell script.
The data of the file is in one row as below that is 28Mbyte size.
A>
cto10001 0000000 201010 10:52:13 cto10001 0000000 201011 10:52:13 cto10001 0000000 201011 10:52:13... (2 Replies)
Can somebody help me in solving this..
Input data is like
0 A
1 B
2 C
3 D
0 A1
1 B1
2 C1
3 D1
0 A2
1 B2
2 C2
3 D2
Output should be like
A B C D
A1 B1 C1 D1
A2 B2 C2 D2 (7 Replies)
Hi,
Can anyone suggest quick way to get desired output?
Sample input file content:
A 12 9
A -0.3 2.3
B 1.0 -4
C 34 1000
C -111 900
C 99 0.09
Output required:
A 12 9 -0.3 2.3
B 1.0 -4
C 34 1000 -111 900 99 0.09
Thanks (3 Replies)
Hi All,
I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Hi,
I want to convert a single row values to multiple rows, but the no. of rows are not fixed.
For example, I have a row as below
abc-def-lmn-mno-xyz
out put should be
get abc
get def
get lmn
get xyz (4 Replies)
Hello,
I have a bilingual database with the following structure
a,b,c=d,e,f
The right half is in a Left to right script and the second is in a Right to left script as the examples below show
What I need is to separate out the database such that the first word on the left hand matches the first... (4 Replies)
Hi,
I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file.
Example of the SQL will be
For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING.
I then concatenate... (2 Replies)
Hi ALL,
We have requirement in a file, i have multiple rows.
Example below:
Input file rows
01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212
01,1,102319,0,1,80,20,U,1,241,00000059420000006021
I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies
LEARN ABOUT SUNOS
ypcat
ypcat(1) User Commands ypcat(1)NAME
ypcat - print values in a NIS database
SYNOPSIS
ypcat [-kx] [-d ypdomain] mname
DESCRIPTION
The ypcat command prints out values in the NIS name service map specified by mname, which may be either a map name or a map nickname. Since
ypcat uses the NIS network services, no NIS server is specified.
Refer to ypfiles(4) for an overview of the NIS name service.
OPTIONS -k Display the keys for those maps in which the values are null or the key is not part of the value. None of the maps derived
from files that have an ASCII version in /etc fall into this class.
-d ypdomain Specify a domain other than the default domain.
-x Display map nicknames.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
|Availability |SUNWnisu |
+-----------------------------+-----------------------------+
SEE ALSO ypmatch(1), ypfiles(4), attributes(5)SunOS 5.10 23 Jan 1995 ypcat(1)