Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scanning a field and replacing
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Scanning a field and replacing
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01019759
Message ID:
01019759
Views:
76
I have a field named planextra2 whihc is a general comments field. When somebody uploads a picture using my program it will enter the comments 'Img Submit'. But the same comments field is allowed for users to add other information. Therefore I have a problem.

If the comments field is empty:

a) If the field is empty then the comments will be shown as 'Img Submit'
b) If the field has the value of 'Img Submit' then I want to replace it with 'Img Re-Submit'

If the comments field has comments in already then I need to somehow scan the field to see if 'Img Submit' or 'Img Re-Submit' is there. If its not there then append 'Img Submit'. If 'Img Submit' is there then replace 'Img Submit' with 'Img Re-submit'. For example:

Updated yesterday. Img Submit. Colours Red or Black

I would like this to be changed to:

Updated yesterday. Img Re-Submit. Colours Red or Black

I basically dont know how to scan the field and differentiate the comments I have added from the comments they might add.

Can anybody help me please
Neil Lewis
IT R&D Manager
Velmore Ltd
Next
Reply
Map
View

Click here to load this message in the networking platform