12-10-2013
How to convert values in a line to rows?
hi,
I am basically running a sql that returns me values and I have stored them to a variable for example value of the variable will be:
123 124 345
now I want to write values stored in the variable into a file as
123
124
345
thanks in advance
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
if u have a data
2 4 6 8 5 4 4 5 6
then result shud be like
2
4
6
7
5
4
4
5
6 (3 Replies)
Discussion started by: cdfd123
3 Replies
2. Shell Programming and Scripting
hi,
Apologies if this has been covered.
I have requirement where i have to convert a single column into multiple column.
My data will be like this -
2
3
4
5
6
Output required -
2 3 4 5 6 (1 Reply)
Discussion started by: Nishithinfy
1 Replies
3. Shell Programming and Scripting
Hello,
I would like to convert a list of rows to a space separated line. Any ideas?
Input file:
"Administration Tools"
"Design Suite"
"Dial-up Networking Support"
"Editors"
desired output
"Administration Tools" "Design Suite" "Dial-up Networking Support" "Editors"
Thanks,... (4 Replies)
Discussion started by: jaysunn
4 Replies
4. Shell Programming and Scripting
- I have two files (File 1 and File 2) and the contents of the files are mentioned below.
- I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2.
- I tried to modify and use... (10 Replies)
Discussion started by: Santoshbn
10 Replies
5. Shell Programming and Scripting
Hi!
Does anybody help me in converting following data:
INPUT looks like this:
20. 100.
30 200.
40. 400.
50. 100.
60. 200.
70. 400.
80. 200.
150. 210.
30. 100.
OUTPUT should look like this:
20. 100. 30 200. 40. 400. 50. 100.
60. 200. 70.... (5 Replies)
Discussion started by: lovelinux
5 Replies
6. Shell Programming and Scripting
Hi Gurus,
How to convert rows in to columns using linux shell scripting
Input is like (sample.txt)
ABC
DEF
GHI
JKL
MNO
PQR
STU
VWX
YZA
BCD
output should be (sampleoutput.csv)
ABC,DEF,GHI,JKL,MNO
PQR,STU,VWX,YZA,BCD (2 Replies)
Discussion started by: infasriniit
2 Replies
7. Shell Programming and Scripting
I have a list of columns with values that I need to transform into a row containing the range of each column. For example:
"Column A"
1
2
3
4
10
12
14
15
16
17
18
"Column B"
1
4
5
6 (4 Replies)
Discussion started by: newbio
4 Replies
8. Shell Programming and Scripting
Hi Experts,
I have a requirement to convert rows into columns.
For e.g.
Input File:
Output File should be like
Appreciate if you could suggest code snippet(may be awk) for above requirement...
Thanks in Advance for your help... (3 Replies)
Discussion started by: sai_2507
3 Replies
9. Shell Programming and Scripting
Hi all ,
I have a file with the below content
Header Section
employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep
Data section ... (1 Reply)
Discussion started by: Hypesslearner
1 Replies
10. Programming
Hi Team
I am using DB2 artisan tool and struck to handle multi values present in columns that are comma(,) separated. I want to convert those column values in separate rows .
For example :
Column 1 Column2
Jan,Feb Hold,Sell,Buy
Expected Result
Column1 ... (3 Replies)
Discussion started by: Perlbaby
3 Replies
LEARN ABOUT PHP
gupnp_service_notify
GUPNP_SERVICE_NOTIFY(3) 1 GUPNP_SERVICE_NOTIFY(3)
gupnp_service_notify - Notifies listening clients
SYNOPSIS
bool gupnp_service_notify (resource $service, string $name, int $type, mixed $value)
DESCRIPTION
Notifies listening clients that the property have changed to the specified values.
PARAMETERS
o $service
- A service identifier.
o $name
- The name of the variable.
o $type
- The type of the variable. Type can be one of the following values:
o GUPNP_TYPE_BOOLEAN - Type of the variable is boolean.
o GUPNP_TYPE_INT - Type of the variable is integer.
o GUPNP_TYPE_LONG - Type of the variable is long.
o GUPNP_TYPE_DOUBLE - Type of the variable is double.
o GUPNP_TYPE_FLOAT - Type of the variable is float.
o GUPNP_TYPE_STRING - Type of the variable is string.
o $value
- The value of the variable.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
ERRORS
/EXCEPTIONS
Issues E_WARNING with either not correctly defined type of the variable or the value is not corresponding to the defined type.
SEE ALSO
gupnp_service_freeze_notify(3), gupnp_service_thaw_notify(3).
PHP Documentation Group GUPNP_SERVICE_NOTIFY(3)