03-28-2009
concatenate two files with different No of rows
need a shell which perform following function
file 1 ( every time new data comes)
1212
2323
3434
4545
5656
.
.
.
.
file 2 (fixed line)
update bc_tbl set aix=data , bix=back where cix=U and serial=;
now when i execute shell it will concatinate file 1, file 2 & make file 3 as output
file 3
update bc_tbl set aix=data , bix=back where cix=U and serial=1212;
update bc_tbl set aix=data , bix=back where cix=U and serial=2323;
update bc_tbl set aix=data , bix=back where cix=U and serial=3434;
update bc_tbl set aix=data , bix=back where cix=U and serial=4545;
update bc_tbl set aix=data , bix=back where cix=U and serial=5656;
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to search a file for two values (valueA & valueB). ValueA will be on a different row than valueB, and concatenate the two together on the same row of my output.
Example: search input file for strings "node" and "OS", combine the two results into one row
input
node A
text
text
OS... (4 Replies)
Discussion started by: indianadoug
4 Replies
2. Shell Programming and Scripting
I have 2 files
FILEA
1232342
1232342
2344767
4576823
2325642
FILEB
3472328
2347248
1237123
1232344
8787890
I want the output to go into a 3rd file and look like:
FILEC
1232342 3472328 (1 Reply)
Discussion started by: unxusr123
1 Replies
3. Shell Programming and Scripting
i have a file as below and i need to load it into oracle. The problem is, some of the rows are in 2 lines.
123456_PosWlist ----- ----- IN 0/0
123456_PosWListRpt ----- ----- IN 0/0
123456_PosWListCSV
----- -----... (7 Replies)
Discussion started by: Amit.Sagpariya
7 Replies
4. Shell Programming and Scripting
Hi Guys,
I need help in modifying a large text file containing more than 1-2 lakh rows of data using unix commands. I am quite new to the unix language
the text file contains data in a pipe delimited format
sdfsdfs
sdfsdfsd
START_ROW
sdfsd|sdfsdfsd|sdfsdfasdf|sdfsadf|sdfasdf... (9 Replies)
Discussion started by: manish2009
9 Replies
5. UNIX for Dummies Questions & Answers
Hi guys;
TBH I am an absolute novice, when it comes to scripting; I do have an idea of the basic commands...
Here is my problem;
I have a flatfile 'A' containing a single column with multiple rows. I have to create a script which will use 'A' as input and then output a string in in the... (0 Replies)
Discussion started by: carlos_anubis
0 Replies
6. Shell Programming and Scripting
Hi guys;
TBH I am an absolute novice, when it comes to scripting; I do have an idea of the basic commands...
Here is my problem;
I have a flatfile 'A' containing a single column with multiple rows. I have to create a script which will use 'A' as input and then output a string in in the... (6 Replies)
Discussion started by: carlos_anubis
6 Replies
7. Shell Programming and Scripting
I have a file named "file1" which has the following data
10000
20000
30000
And I have a file named "file2" which has the following data
ABC
DEF
XYZ
My output should be
10000ABC
20000DEF (3 Replies)
Discussion started by: bobby1015
3 Replies
8. UNIX for Dummies Questions & Answers
- Concatenate files and delete source files. Also have to add a comment.
- I need to concatenate 3 files which have the same characters in the beginning and have to remove those files and add a comment and the end.
Example:
cat REJ_FILE_ABC.txt REJ_FILE_XYZ.txt REJ_FILE_PQR.txt >... (0 Replies)
Discussion started by: eskay
0 Replies
9. Shell Programming and Scripting
I need to concatenate the rows that are broken (because of carriage return and line feed) in unix.
Input
123|456|789|""
987|786|"GRT
"|""
3455|896|654|456|""
457|234|"RT"|"PR
TY"|""
Output
123|456|789|""
987|786|"GRT"|""
3455|896|654|456|""
457|234|"RT"|"PRTY"|"" (16 Replies)
Discussion started by: meet_calramz
16 Replies
10. Shell Programming and Scripting
I'm trying to find a way to concatenate consecutive rows (key is column $1 and $2) if column $5 an $6 are integers and redefine ranges in columns $3&$4 and $5&$6
Unfortunately I'm still learning the very basics so I cannot figure a way of doing this with awk.
Input file
15 30 21 21 25.0... (11 Replies)
Discussion started by: alex2005
11 Replies
LEARN ABOUT DEBIAN
blt_treenodeid
Blt_TreeNodeId(3) BLT Library Procedures Blt_TreeNodeId(3)
__________________________________________________________________________________________________________________________________________________
NAME
Blt_TreeNodeId - Returns the node serial number.
SYNOPSIS
#include <bltTree.h>
unsigned int
Blt_TreeNodeId(node)
ARGUMENTS
Blt_TreeNode node (in) Node whose ID is to be returned.
_________________________________________________________________
DESCRIPTION
This procedure returns the node serial number. The node serial number is useful for programs that export the tree data object to the Tcl
programming level. Since node labels (and therefore pathnames) are not unique, the ID can be used to uniquely identify a node.
The arguments are as follows:
node The node whose serial number is returned. The serial number of the root node for example is always 0.
RETURNS
The serial number of the node. Nodes are given a unique serial number when they are created. You can use the ID to later retrieve the
node using Blt_TreeGetNode.
EXAMPLE
The following example prints the ID of a node.
printf("root ID is %s
", Blt_TreeNodeId(node));
KEYWORDS
Tcl_TreeCreateNode, Tcl_TreeDeleteNode
BLT
2.4 Blt_TreeNodeId(3)