Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Editing memo fields
Message
From
05/12/2005 09:49:17
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01074921
Message ID:
01074928
Views:
24
>Hi
>
>I want to edit the content of a memo field inserting ... before any no blank line - how do I do it?

You can edit the text one line at a time. alines() will convert a text to an array, making it easy to manipulate.

So, the basic outline might be:
  • Fetch the memo field into a variable.
  • Convert to an array with alines().
  • Replace the memo field with "" (empty text).
  • Analyze each line in the array. Manipulate as desired, and write it back to the memo field.

    Or write to a temporary variable first, and then do a single REPLACE.
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform