08-12-2008
Split a record ( in a row) and make it as new row
Hi All,
The following is the scenario
id name
--------------
1 William;Johnson
2 Azim;Abdul
3 Grasim
.
.
etc....
I need the following output
id name
--------------
1 William
1 Johnson
2 Azim
2 Abdul
3 Grasim
.
.
..etc
Please tell me the way to achieve the solution.
Thanks in advance!!!!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value .
For Eg .
if the input file has a row :
abc xyz lmn 89 lm nk o p
I would like the script to create something like... (9 Replies)
Discussion started by: aYankeeFan
9 Replies
2. UNIX for Dummies Questions & Answers
So, I have a massive file with thousands of columns
I want a list of the headers in one column in another file.
So I need to strip off the top line (can use head-1)
But how can I convert from this format:
A B C D E F G
to
A
B
C
D
E
F
G (6 Replies)
Discussion started by: polly_falconer
6 Replies
3. Shell Programming and Scripting
Hi,
I have one file with the following details,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Account_Id Date Id Balance
44 9 1000.00 30 15-10-2173 10 1000.00 42 15-10-2173 10 1200.00 53 01-01-2008 10 1200.00
I need to split up the values in to the respective fields as follows,
... (7 Replies)
Discussion started by: Kattoor
7 Replies
4. UNIX for Dummies Questions & Answers
Hello Everyone,
My issue is that I want to traverse a database table row by row and do some action on the value retrieved in each row.
I have gone through a lot of shell script questions/posts. I could find row by row traversal of a file but not a database table.
Please help.
Thanks &... (5 Replies)
Discussion started by: ahsan.asghar
5 Replies
5. Shell Programming and Scripting
Hi Friends,
I have a single column data like below.
1
2
3
4
5
I need the output like below.
0
1
2
3
4
where each row (including first row) subtracting from first row and the result should print below like the way shown in output file.
Thanks
Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies
6. Shell Programming and Scripting
HI Guys,
I have Below Input :-
RepigA_hteis522 ReptCfiEtrBsCll_aofe
MSL04_MSL2_A25_1A 0 9
MSL04_MSL2_A25_1B 0 9
MSL04_MSL2_A25_1C 0 9
RepigA ReptCfiEtrBsCll
hteis522 aofe
MSL04_MSL2_A25_1A 0 9
MSL04_MSL2_A25_1B 0 9
MSL04_MSL2_A25_1C 0 9
Split Data in two first row... (2 Replies)
Discussion started by: pareshkp
2 Replies
7. Shell Programming and Scripting
Hi,
I want to know how to place a particular field availble in a record as the columnname.
Name,Sam,Age,13,School, StJohn
Name,Rita,Age,12,School, StMichael,
Name,John,Age,14,School, StAnthony
I want the output as
Name Age School
Sam 13 StJohn
Rita 12 StMichael
John 14... (6 Replies)
Discussion started by: sidnow
6 Replies
8. UNIX for Beginners Questions & Answers
My original files are like this below and I distinguish them from the AP_ID (file1 has 572 and file2 has 544). Also, the header on file1 has “G_” pre-pended. NOTE: these are only snippets of very large files and much of the data is not present here.
Original File 1:
... (36 Replies)
Discussion started by: aachave1
36 Replies
9. Shell Programming and Scripting
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
10. UNIX for Beginners Questions & Answers
This is a question that is related to one I had last August when I was trying to sort/merge two files by millsecond time column (in this case column 6).
The script (below) that helped me last august by RudiC solved the puzzle of sorting/merging two files by time, except it gets lost when the... (0 Replies)
Discussion started by: aachave1
0 Replies
LEARN ABOUT DEBIAN
gen-ctl-io
GEN-CTL-IO(1) libctl GEN-CTL-IO(1)
NAME
gen-ctl-io - generate C interface code for libctl control files
SYNOPSIS
gen-ctl-io [OPTION]... [spec-file]
DESCRIPTION
gen-ctl-io generates C code to import/export the input/output variables used in a libctl control file. gen-ctl-io generates files like
ctl-io.h and ctl-io.c. These files define global variables, data structures, and functions for the input/output variables, classes, and
function interfaces defined in the spec-file argument, automating the interaction between C and Guile.
The arguments such as --code and --header are used to control whether ctl-io.c or ctl-io.h, etcetera, are generated. If no argument is
specified then both of these files are generated by default, for backwards compatibility.
libctl is a free library to aid in interfacing scientific software with the GNU Guile scripting and extension language. Documentation for
it may be found online at the libctl home page: http://ab-initio.mit.edu/libctl
OPTIONS
--code Generate C (or C++) source code to implement the Guile interface functions. The default output file name is ctl-io.c (in C) or ctl-
io.cpp (in C++).
--header
Generate the header file declaring the interface data types and functions. The default output file name is ctl-io.h (in C) or ctl-
io.hpp (in C++).
--swig Generate a SWIG interface definition file declaring automatic conversions for the various libctl data types. The default output
file name is ctl-io.i.
--cxx Generate C++ code instead of C code.
-o file
Use file as the output file name instead of the defaults (above).
BUGS
Send bug reports to S. G. Johnson, stevenj@alum.mit.edu.
AUTHORS
Written by Steven G. Johnson.
libctl March 27, 2006 GEN-CTL-IO(1)