Converting Pivot file to flat file

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting csv file to flat file

Hi All, I have a csv file which is comma seperated. I need to convert to flat file with preferred column length country,id Australia,1234 Africa,12399999 Expected output country id Australia 1234 Africa 12399999 the flat file should predefined length on respective...

2. Shell Programming and Scripting

Pivot file using shellscript

Hi, I am new at using shell scripting. So I have a question for the more experienced Linux users. I would like to perform some kind of pivot on a file. Example Input file COL1,"2001-01-01","2001-03-01","2001-03-24" A1,22,,44 B1,56,78,12 C2,5,, I would like to have to following output...

3. Shell Programming and Scripting

Oracle table extract: all columns are not converting into pipe delimited in flat file

Hi All, I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far. 1. Table.txt ==> database extract file 2. flat.txt ==> pipe delimited after some manipulation of the original db...

4. Shell Programming and Scripting

Pivot file content

Hi All , I have a file as below . A "1" B "2" C "3" D "4" E "5" F "6" A "11" B "21" C "31" D "41" E "51" F "61" And the output should be like A B C D E F 1 2 3 4 5 6 11 21 31 41 51

5. Shell Programming and Scripting

Help with converting XML to Flat file

Hi Friends, I want to convert a XML file to flat file. Sample I/p: <?xml version='1.0' encoding='UTF-8' ?> <DataFile xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' contactCount='4999' date='2012-04-14' time='22:00:14' xsi:noNamespaceSchemaLocation='gen .xsd'> <Contact...

6. UNIX for Dummies Questions & Answers

Script to pivot flat file

Hi to all, I have a file with a list of values: v1,v2,v3....,v9 need file in this format: Name1: v1 Name2: v2 Name3: v3 ... Name9: v9 Please help me out.

7. UNIX for Advanced & Expert Users

Converting the date format in a flat file

Hi All, I am new to this forum, could any one help me out in resolving the below issue. Input of the flat file contains several lines of text for example find below: 5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2 5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1...

8. Shell Programming and Scripting

Converting a flat file in XML

Hello Friends, I am new to UNIX shell scripting. Using bash....Could you please help me in converting a flat file into an XML style output file. Flat file: (Input File entries looks like this) John Miller: 617-569-7996:15 Bunting lane, staten Island, NY: 10/21/79: 60600 The...

9. Shell Programming and Scripting

Pivot file contents

Hi All, I am trying to pivot the contents in a file. Ex: I have a file sample.txt with data "A B C D", i need the contents to pivot & resulting file should look like "A B C ...

10. Shell Programming and Scripting

Converting Column to Rows in a Flat file

Hi, Request To guide me in writing a shell program for the following requirement: Example:if the Input File contains the follwing data Input File Data: 80723240029,12,323,443,88,98,7,98,67,87 80723240030,12,56,6,,,3,12,56,6,7,2,3,12,56,6,7,2,3,88,98,7,98,67,87...

LEARN ABOUT OPENSOLARIS

conv_lpd

conv_lpd(1M)						  System Administration Commands					      conv_lpd(1M)

NAME

       conv_lpd - convert LPD configuration

SYNOPSIS

       conv_lpd [-c printers | -c printcap] [-n] file

DESCRIPTION

       conv_lpd  converts   LPD  printer  configuration information from  file to a printers.conf or a	printcap file (see printers.conf(4)). file
       specifies the name of the input file, and can be either in printers.conf or  printcap format. If  file is in  printers.conf format, it con-
       verts it to a printcap file. If	file is in  printcap format, it converts it to a printers.conf file.

OPTIONS

       The following options are supported:

       -c printers | -c printcap    Specifies  the  type  of output file produced by the conversion. -c printers converts to a printers.conf file.
				    -c printcap converts to a printcap file. -c printers is the default.

       -n			    Preserves the namelist during the conversion.

OPERANDS

       The following operands are supported:

       file    The file to be converted.

EXAMPLES

       Example 1 Converting a printcap file to a  printers.conf file.

       The following example converts a  printcap file to a  printers.conf file.

	 example% conv_lpd /etc/printcap

       Example 2 Converting a  printcap file to a printers.conf file and preserving the namelist.

       The following example converts a  printcap file to a printers.conf file and preserves the namelist.

	 example% conv_lpd -c printers -n /etc/printcap

       Example 3 Converting a  printers.conf file to a	printcap file and preserving the namelist.

       The following example converts a  printers.conf file to a  printcap file and preserves the namelist.

	 example% conv_lpd -c printcap -n /etc/printers.conf

EXIT STATUS

       The following exit values are returned:

       0	   Successful completion.

       non-zero    An error occurred.

FILES

       /etc/printers.conf    System printer configuration database.

       /etc/printcap	     SunOS 4.x printer capability database.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWpcu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       lpset(1M), printers.conf(4), attributes(5)

SunOS 5.11							    9 Sep 1996							      conv_lpd(1M)

Shell Programming and Scripting