06-26-2009
I have this data now,(Bolded is the primary key for each set and I want that to be included on the corresponding consecutive rows)
F51010141TK1070000483L4058S462 34329094 0232384840 381892 182 5690
F51020141FIRST CLEARING, LLC A/C 3432-9094
F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6
F51040141VALBO 81892 SWEDEN AIRMAIL 000000000
F51090141 0000 0
F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690
F51020141FIRST CLEARING, LLC A/C 8637-4984
F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN
F510401412801 MARKET STREET SAINT LOUIS MO 63103
and I wanted it to be
A4058S462 34329094 F51010141TK1070000483A4058S462 34329094 0232384840 381892 182 5690
A4058S462 34329094 F51020141FIRST CLEARING, LLC A/C 3432-9094
A4058S462 34329094 F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6
A4058S462 34329094 F51040141VALBO 81892 SWEDEN AIRMAIL 000000000
A4058S462 34329094 F51090141 0000 0
L4058T155 86374984 F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690
L4058T155 86374984 F51020141FIRST CLEARING, LLC A/C 8637-4984
L4058T155 86374984 F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN
L4058T155 86374984 F510401412801 MARKET STREET SAINT LOUIS MO 63103
Thanks
---------- Post updated at 02:29 AM ---------- Previous update was at 02:23 AM ----------
F51010141TK1070000483L4058S462 34329094 0232384840 381892 182 5690
F51020141FIRST CLEARING, LLC A/C 3432-9094
F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6
F51040141VALBO 81892 SWEDEN AIRMAIL 000000000
F51090141 0000 0
F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690
F51020141FIRST CLEARING, LLC A/C 8637-4984
F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN
F510401412801 MARKET STREET SAINT LOUIS MO 63103
Bolded is the record type, like wise each set mite have 01 to 12...so I have to append the primary key as mentioned earlier till I reach next 01 to 12...
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Good day!
I am trying to learn how to use the "sed" editor, to perform multiple edits on multiple files in multiple directories.
I have one script that tries to call up each file and process it according to the edits listed in a second script. I am using a small input text to test these, at... (12 Replies)
Discussion started by: kielitaide
12 Replies
2. UNIX for Dummies Questions & Answers
Dear Experts
Why we always hear that unix operating system is Multi User and Multi task. What does these two means. I have looked at some books and documents but couldn't find aclear explenation. Can we say Windows operating system is also multi user and multi task??
Thanks for your help in... (6 Replies)
Discussion started by: Reza Nazarian
6 Replies
3. Shell Programming and Scripting
I have a fixed width source file like this( it has 5 different record types identified by bolded numbers)
N5101ABCD 9820398 2983287
N5102 9s9923 00000000 00
N5103
N5101TTT 9843438 9494994
N5104 sdsd
N5101YYY 7777777 1111111
I need to have like this:
N5101ABCD ... (2 Replies)
Discussion started by: saravanamr
2 Replies
4. Shell Programming and Scripting
Hi,
I have a input file with the following entries:
1one
2two
3three
1four
2five
3six
1seven
1eight
1nine
2ten
The output should be
1one
2two
3three
1four
2five
3six (2 Replies)
Discussion started by: supchand
2 Replies
5. Shell Programming and Scripting
Hi,
I have a problem where I need to make this input:
nameRow1a,text1a,text2a,floatValue1a,FloatValue2a,...,floatValue140a
nameRow1b,text1b,text2b,floatValue1b,FloatValue2b,...,floatValue140b
look like this output:
nameRow1a,text1b,text2a,(floatValue1a - floatValue1b),(floatValue2a -... (4 Replies)
Discussion started by: nricardo
4 Replies
6. Shell Programming and Scripting
Hi! all
can any one tell me how to compare current record of column with next and previous record in awk without using array
my case is like this
input.txt
0 32
1 26
2 27
3 34
4 26
5 25
6 24
9 23
0 32
1 28
2 15
3 26
4 24 (7 Replies)
Discussion started by: Dona Clara
7 Replies
7. Shell Programming and Scripting
I have test.xml
<emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp>
<Join><id>101</id><city>london</city><date>06/06/14 2011</date></join>
<Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join>
<Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies
8. Programming
I am trying to write a large X app. I have successfully modified my xorg.conf to setup 4 monitors on an NVIDIA Quatro5200. I am trying to modify a simple hello world application to open a window on three of the four monitors. depending on the changes to loop the window creation section and event... (2 Replies)
Discussion started by: advorak
2 Replies
9. Shell Programming and Scripting
Hi,,
I have requirement that i need to get DISTINCT values from a table and if there are two records i need to update it to one record and then need to submit INSERT statements by using the updated value as a parameter. Here is the example follows..
SELECT DISTINCT ID FROM OFFER_GROUP WHERE... (1 Reply)
Discussion started by: Samah
1 Replies
10. Shell Programming and Scripting
Input File:
>Seq1
ASDADAFASFASFADGSDGFSDFSDFSDFSDFSDFSDFSDFSDFSDFSDFSD
>Seq2
SDASDAQEQWEQeqAdfaasd
>Seq3
ASDSALGHIUDFJANCAGPATHLACJHPAUTYNJKG
......
Desired Output File
>Seq1
ASDADAFASF
ASFADGSDGF
SDFSDFSDFS
DFSDFSDFSD
FSDFSDFSDF
SD
>Seq2 (4 Replies)
Discussion started by: patrick87
4 Replies
LEARN ABOUT CENTOS
ng_atmllc
NG_ATMLLC(4) BSD Kernel Interfaces Manual NG_ATMLLC(4)
NAME
ng_atmllc -- ATM LLC netgraph node type
SYNOPSIS
#include <netgraph/ng_atmllc.h>
DESCRIPTION
The atmllc node type translates frames in to and out of ATM LLC encapsulation, as specified by RFC 1483. In LLC encapsulation the protocol
of a given protocol data unit (PDU) is specified by an IEEE 802.2 LLC header, possibly followed by an IEEE 802.1a SubNetwork Attachment Point
(SNAP) header. This node currently handles the Ethernet and FDDI protocols.
The node transmits and receives ATM PDUs on the atm hook. Received PDUs are decoded and forwarded to the ether or fddi hooks as appropriate.
Data received on the ether or fddi hooks are assumed to be full Ethernet or FDDI packets as appropriate and are encapsulated into a PDU and
transmitted via the atm hook.
HOOKS
This node type supports the following hooks:
atm ATM connection. Typically, this hook would be connected to a ng_atm(4) node, which handles transmission of ATM PDUs over an ATM
device.
ether Ethernet connection. This hook sends and receives Ethernet frames. This would normally be connected to an ng_eiface(4) node if in
use.
fddi FDDI connection. This hook sends and receives FDDI frames.
CONTROL MESSAGES
This node type supports the generic control messages.
SHUTDOWN
This node shuts down upon receipt of a NGM_SHUTDOWN control message, or when all hooks have been disconnected.
SEE ALSO
netgraph(4), ng_atm(4), ng_eiface(4), ngctl(8)
J. Heinanen, Multiprotocol Encapsulation over ATM Adaptation Layer 5, RFC 1483.
AUTHORS
Benno Rice <benno@FreeBSD.org>
BSD
March 8, 2004 BSD