|
|
Sponsored Content
Top Forums
UNIX for Advanced & Expert Users
Convert column data to row data using shell script
Post 302650709 by clx on Monday 4th of June 2012 06:12:35 AM
06-04-2012
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Discussion started by: aemunathan
8 Replies
2. Shell Programming and Scripting
Hi Guys,
I have a file as follows:
a 1
b 786
c 90709
d 99
a 9875
b 989
c 887
d 111
I want:
a 1 9875
b 786 989 (3 Replies)
Discussion started by: npatwardhan
3 Replies
3. Shell Programming and Scripting
Hi Friends
I have the following input data in 2 columns.
SNo 1
I1 Value
I2 Value
I3 Value
SNo 2
I4 Value
I5 Value
I6 Value
I7 Value
SNo 3
I8 Value
I9 Value
...............
................
SNo N (1 Reply)
Discussion started by: ks_reddy
1 Replies
4. Shell Programming and Scripting
Dear friends,
Below is my program and current output. I wish to have 3 or 4 column output in order to accomodate in single page. i do have subsequent command to process after user enter the number.
Program
COUNT=1
for MYDIR in `ls /`
do
VOBS=${MYDIR}
echo "${COUNT}. ${MYDIR}"
... (4 Replies)
Discussion started by: baluchen
4 Replies
5. Shell Programming and Scripting
Hi All,
I will be getting a huge XML file with a lot of records in it. I need to convert it into multiple data files.
SAMPLE XML FILE
<ABSProductCatalog xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <ProductSalesHierachy>
- <Portfolios>
- <Portfolio productCode="P1">
... (8 Replies)
Discussion started by: ragha81
8 Replies
6. Shell Programming and Scripting
Hello,
I have an input file like the following:
11_3_4
2_1_35
3_15__
_16989
Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies
7. Shell Programming and Scripting
Hello,
I have output in the matrice form , for example:
1 2 3 4
a b c d
jim joe sue tom
how can I convert this line-column data into a row as follows
1 2 3 4 a b c d jim joe sue tom
thank you (14 Replies)
Discussion started by: rpf
14 Replies
8. Shell Programming and Scripting
Experts Good day,
I have the following data, file1
BRAAGRP1
A2X
B2X
C2X
D2X
BRBGRP12
A3X
B3X
Z10
D09
BRC1GRP2
LO01 (4 Replies)
Discussion started by: rveri
4 Replies
9. Shell Programming and Scripting
Hi
FileA.txt
E_TIM 16,
ETE 15,
EOND 26,
EEC 81,
E_1 un,
E_2 un,
E_3 un,
E_4 284,
E_TIM 17,
ETE 15,
EOND 29,
EEC 82,
E_1 un,
E_2 un,
E_3 un,
E_4 249, (6 Replies)
Discussion started by: asavaliya
6 Replies
10. UNIX for Beginners Questions & Answers
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
Discussion started by: Shubham1182
5 Replies
LEARN ABOUT DEBIAN
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)