help help help

[ronitreddy]

I have 2 files namely INPUT and OUTPUT

For the file INPUT, it takes the following format

MNT-[b]BANK-NUMBERO:006[/b],00:N
MNT-515-[b]ACCOUNT-NUMBERO[/b]:[b]018[/b],00:N
MNT-515-DESCRIPTIONO:045:C
.
.

For the file OUTPUT, it takes the following format

D-CHECK-NUM:012:C
D-COMMENT-LINE1:020:C
D-COMMENT-LINE2:020:C
D-COMMENT-LINE3:020:C
D-TRAN-ORDER:012:C
MON-[b]ACCOUNT:018[/b],00:N
MON-[b]BANK-NBR:006[/b],00:
MON-BLK-ITEM-SEQ:006,00:N
MON-BLK-SEQ:004,00:N
.
.



Here, for the file INPUT we have 3 fields MNT-BANK-NUMBERO:006,00:N, MNT-515-ACCOUNT-NUMBERO:018,00:N and MNT-515-DESCRIPTIONO:045:C and so on.

For MNT-BANK-NUMBERO:006,00:N field, the bank number is of 6(1-6) characters in length.
For MNT-515-ACCOUNT-NUMBERO:018,00:N field, the account number is of 18(7-24) characters in length.

And for the file OUTPUT we have 2 fields MON-ACCOUNT:018,00:N, MON-BANK-NBR:006,00:N:018,00:N and so on.

For MON-ACCOUNT:018,00:N field, the account number is of 18(86-103) characters in length.
For MON-BANK-NBR:006,00:N:018,00:N field, the bank number is of 6(104-109) characters in length.

Now my requirment is to find the starting position of each BANK NUMBER and the ACCOUNT NUMBER side by side

Typical Output takes the following format

[b]INPUT,1,7,
OUTPUT, 86, 104[/b]

Please help me out in solving this.  CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@

[dkchinnari]

CITI#H@ CITI#H@ CITI#H@
asalu deniki sambadinchindhi..sql aaa  sCo_^Y

[krldr871]

ee language..oka sample input ivvuu..asalu ne INPUT file format lo format undi kani aa account number, bank numbers ekkada unnayo ardam ayyi savatle nakaithe 

[ronitreddy]

UNIX lo baa..

bold lo pettanu kada ACCOUNT NUM inka BANK num  cry@fl cry@fl cry@fl

[krldr871]

[quote author=ronitreddy link=topic=216572.msg2664395#msg2664395 date=1311693395]
UNIX lo baa..

bold lo pettanu kada ACCOUNT NUM inka BANK num  cry@fl cry@fl cry@fl
[/quote]
cut command tho cheyyachu idi..kani adedo MNT DESCRIPTION field undi kada..ela differentiate chestav daanni and ac no/bank no ni? based on character length aa..2 min wait cheyi command chepta rough ga

[topulake topu]

exactly q'n ardam kaled baa.. kani ltt

[ronitreddy]

baa prathi file lo BANK NUMBER inka ACCOUNT NUM diff ga unnayi and positioning of the fields kuda diff ga unnayi..for example
[b]FILE1 [/b]lo RPT-BANK-NUMBERO:006,00:N
RPT-515-ACCOUNT-NUMBERO:018,00:N

[b]FILE2 [/b]lo MON-ACCOUNT:018,00:N
MON-BANK-NBR:006,00:N

manam basically bank num, account number length(characters length) kanukovali

adi ee format lo ravali

FILE1 1,6,7,18(1-6 emo bank number oka length and 7-18 emo account number length)
FILE2 86,103,104,109( 86-103 emo account number length and 104-109 emo bank number length)

[ronitreddy]

[quote author=topulake topu link=topic=216572.msg2664424#msg2664424 date=1311693911]
exactly q'n ardam kaled baa.. kani ltt
[/quote] cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl

[ronitreddy]

[quote author=John Galt link=topic=216572.msg2664411#msg2664411 date=1311693612]
cut command tho cheyyachu idi..kani adedo MNT DESCRIPTION field undi kada..ela differentiate chestav daanni and ac no/bank no ni? based on character length aa..2 min wait cheyi command chepta rough ga
[/quote]

but cut command naku thelsu kani manaki akkada starting positions ending positions side by side ravali and with corresponding ACCOUNT numbers, BANK numbers thoo CITI#H@ CITI#H@ CITI#H@

[ronitreddy]

cry@fl cry@fl cry@fl

[ronitreddy]

CITI#H@ CITI#H@ CITI#H@ CITI#H@