replace one word with another word

[friend01]

Hi All,

I have a .DBF with over 4 million records with 2 fields:
1 field = Memo Field called "SRC1".
1 field = Character field called "TYP"

I need to 'look' in every record in the field called "SRC1" and replace the word "Outbound" with the word "Inbound" for TYP$"3003*3007".

Any suggestions of how to code efficiently? Please let me know.


Thanks,
F1

 

[friend01]

I forgot to mention that the word "Outbound" cal be anywhere in the memo field and that I need to keep the text which is around it. Example, if the Memo field now contains:
"Regan Road_555/555-1234 Outbound Calls", I need it to say:
"Regan Road_555/555-1234 Inbound Calls". Another example, if the Memo field now contains:
"Outbound Calls for Jack Tripper", I need it to say:
"Inbound Calls for Jack Tripper". Just thought I'd mention that as I know it makes a difference.

Thanks again,
F1

 

[JRB-Bldr]

Have you looked at the STRTRAN() function in your VFP Help?

REPLACE ALL SRC1 WITH STRTRAN(SRC1,"Outbound","Inbound");
FOR TYP $ "3003,3007"

Good Luck,
JRB-Bldr

 

[Mike Lewis]

Hi Friend01,

JRB-Bldr has given you the correct answer, but don't expect it be quick. TYP$"3003*3007" is not optimisable, and so your code will have to look inside both memo fields in every one of those 4 million records.

There's no way to avoid that delay given your existing table structure. You might need to re-think how you organise your data.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[friend01]

thanks guys. I'll give it a try. apprecaite it.

 

[jimstarr]

If TYP is a 4-character field and you're just looking for the occurrence of either 3003 or 3007, then it would be faster to say

FOR TYP = '3003' OR TYP = '3007'

rather than

FOR TYP $ "3003*3007

 

[friend01]

jimstarr,

Absolutely right. It does make things quickrer.


Thanks
f1

 

[falconsight]

You can also use the expression:

 at([3000],memofieldname)>0

for evaluating inside the memo field and only work those that contain the desired data

 

[Mike Lewis]

Falconsight,

You're right that that's possible, but it's no quicker than using the $ operator. In both cases, the expresssion is non-optimisable.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business