Construct 3 column table from one column list Post: 302541994

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

file in to the column of the table

Hi I am ETL person. I have a table in Oracle having one of its column defined as BLOB where it can hold huge data. When i generate a file in DataStage and place it in a path. and i would like dump the file in to the column of the table having datatype as BLOB.

2. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12...

3. UNIX for Dummies Questions & Answers

average of a column in a table

Hello, Is there a quick way to compute the average of a column data in a numerical tab delimeted file? Thanks, Gussi

4. UNIX for Advanced & Expert Users

Data from table to column

Hi All, in bash I have a text file which is something like 7.96634E-07 1.0000 0.00000E+00 0.0000 0.00000E+00 0.0000 1.59327E-06 0.7071 2.23058E-05 0.1890 6.61207E-05 0.1098 1.13919E-04 0.0865 1.47377E-04 0.0747 .... .... 0.00000E+00 0.0000 0.00000E+00 0.0000 ...

5. Shell Programming and Scripting

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2 file 1 sample SNDK 80004C101 AT XLNX 983919101 BB NETL 64118B100 BS AMD 007903107 CC KLAC 482480100 DC TER 880770102 KATS ATHR 04743P108 KATS...

6. Shell Programming and Scripting

From column to table

Hi, I have an ascii file containing information. This file is n x m lines. Is there a way to generate an ascii file where the information is stored as n x m table instead? The m columns should be tab separated. Thanks a lot, Sarah

7. Shell Programming and Scripting

Difference of the same column when two other column matches and one column differs less than 1 hour

This is my input file : # cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9 This is the required output ...

8. UNIX for Dummies Questions & Answers

Creating a two column list of date pairs form a single column list

Hi all, looking for some help here. I'm what you'd call a dirty programmer. my shell scripts might be ugly, but they (usually) function... Say I have a single column text file with a list of dates (yyyymmdd) that represent the elevation of a point on that date (I work with land subsidence, so...

9. Shell Programming and Scripting

Split column data if the table has n number of column's

please write a shell script Table -------------------------- 1 2 3 a b c 3 4 5 c d e 7 8 9 f g h Output should be like this --------------- 1 2 3 3 4 5 7 8 9 a b c c d e f g h

10. Shell Programming and Scripting

Split column data if the table has n number of column's with some record

Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records Table --------- Col1 col2 col3 col4 ....................col20 1 2 3 4 .................... 20 a b c d .................... v ...

LEARN ABOUT OSF1

auconvert

AUCONVERT(1)						      General Commands Manual						      AUCONVERT(1)

NAME

       auconvert - perform various conversion operations on sound files

SYNOPSIS

       auconvert  [-file  <format>]  [-data  <format>] [-rate <sample rate>] [-comment <comment>] [-raw <data format> <num tracks>] [-volume <per-
       cent>|`max'] [-?] [<input file>] [<output file>]

DESCRIPTION

       The auconvert program can be used to convert from one sound file format, and/or data format to another.	It can also  change  the  comment,
       sampling  rate,	and volume of a sound file.  Finally, auconvert can be used to convert raw audio data into a sound file.  If no input file
       name is given, standard input will be used.  If no output file name is given, the original file will be replaced by the converted  file	or
       standard out will be used if the input is coming from standard input.

OPTIONS

       The following options may be used with auconvert:

       -file format
	       The output file format.	The -? option will display a list of valid file formats.

       -data format
	       The  output  data  format.   The  -? option will display a list of valid data formats.  Note that each file format may only support
	       selected data formats.

       -rate sample rate
	       The output sampling rate (in hertz).

       -comment comment
	       The comment to be stored in the output file.

       -volume <percent>|`max'
	       The volume option can be used in two ways.  If the argument is a percentage, the output file volume will be converted to the speci-
	       fied  percentage of the input volume.  If the argument is the string `max', the output file volume will be converted to its maximum
	       level.

       -raw <data format> <num tracks>
	       This option is used to convert raw audio data into a sound file.  <data format> is the data format of the raw data.   <num  tracks>
	       specifies the number of tracks in the raw data.	You must also use the -file and -rate options when converting raw data.

       -?      Displays a usage message and a list of supported file and data formats.

SEE ALSO

       nas(1), auedit(1)

COPYRIGHT

       Copyright 1993, 1994 Network Computing Devices, Inc.

AUTHOR

       Greg Renda, Network Computing Devices, Inc.

								       1.9.3							      AUCONVERT(1)