Deleting certain words within a memo field

[clydejones]

Hi,

I was wondering if it is possible to delete words from within a memo field. Let's say I have the string "I talked to [Clyde PickleBerry] yesterday" in the memo field from the database. However, I want to report "I talked to [] yesterday". Any suggestions would be appreciated.

Calvin

 

[Roadkill150]

Hello,
You cannot use formulas with memo fields unfortunately.
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[FoxG]

Hi,

If you can create a view to split the memo field into string fields then you can use a formula like

local numbervar p1 := instr({view.string_part1},'[')
local numbervar p2 := instr({view.string_part1},']')
left({view.string_part1},p1+1) + mid({view.string_part1},p2)

Hope this helps,
Geoff

 

[clydejones]

Geoff,

Thanks for your reply. Now what if I had a paragraph or paragraphs with ('[' ']') in several places. How would I deal with that situation. Thanks for our help in advance.

Clyde

 

[FoxG]

Hi,

If your on CR8 or above you can use loops.
If not then its going to be difficult!

Hth,
Geoff

 

[clydejones]

Geoff,

Thanks for your help.

Clyde