× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.





 
My pf(masterf) has descr1 (30 char), value(15 8) field
I would like to change description  DESCR1 as shown below .
 DESCR1                           LOC    BRANCH          VALUE
ABC  01FEB 13 AXA INS LHRTD       91     LON             45.00000000
ABC  01MAR 13 AXA INS LHRTD       91     LON             41.00000000
ABC  04MAR 13 AXA INS LHRTD       91     LON             42.00000000
BALL 05MAR 13 AXA INS LHRTD       91     LON             43.00000000
BALL 06MAR 13 AXA INS LHRTD       91     LON             44.00000000
 
====================changed as below===========================
DESCR1                           LOC     BRANCH          VALUE
A  01FEB 13 AXA INS LHR  4500    91     LON              45.00000000            
A  01MAR 13 AXA INS LHR  4100    91     LON              41.00000000
A  04MAR 13 AXA INS LHR  4200    91     LON              42.00000000
B  05MAR 13 AXA INS LHR  4300    91     LON              43.00000000
B  06MAR 13 AXA INS LHR  4400    91     LON              44.00000000
 
I have  updated one by one as I am not sure how to apply logic to whole bunch of records(basically two types as below) for which I want to seek your help. I also attached a notepad incase if the format does sit right:).
Thank you and appreciate your help!
 If you take first example
UPDATE masterf set descr1 ='A 01FEB 13 AXA INS LHR  4500'
where loc='91' and branch='LON' and VALUE = 45.00000000
where DESCR1 ='ABC  01FEB 13 AXA INS LHRTD'

I removed BC and adjusted space and appended 45.00*100(4500)
 
UPDATE masterf set descr1 ='B 06MAR 13 AXA INS LHR 4400'
where loc='91' and branch='LON' and VALUE = 44.00000000
where DESCR1 ='BALL 06MAR 13 AXA INS LHRTD'
I removed ALL and adjusted space and appended 44.00*100(4400) DESCR1 LOC BRANCH VALUE
ABC 01FEB 13 AXA INS LHRTD 91 LON 45.00000000
ABC 01MAR 13 AXA INS LHRTD 91 LON 41.00000000
ABC 04MAR 13 AXA INS LHRTD 91 LON 42.00000000
BALL 05MAR 13 AXA INS LHRTD 91 LON 43.00000000
BALL 06MAR 13 AXA INS LHRTD 91 LON 44.00000000



===============================================
DESCR1 LOC BRANCH VALUE
A 01FEB 13 AXA INS LHR 4500 91 LON
A 01MAR 13 AXA INS LHR 4100 91 LON 41.00000000
A 04MAR 13 AXA INS LHR 4200 91 LON 42.00000000
B 05MAR 13 AXA INS LHR 4300 91 LON 43.00000000
B 06MAR 13 AXA INS LHR 4400 91 LON 44.00000000




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.