If text field contains the word X then replace

[Cabinetman]

Blank once again.... Calc. to replace the entire text in a field if it contains a certain predefined word.

Example: Table::Text Field ...contains "My Dog is ugly"

If (Table::Text Field ?? "ugly" ; "Removed" ; Table::Text Field )

[efen]

If ( PatternCount ( fieldname; " ugly" );"Removed"; fieldname )

[Cabinetman]

Patterncount Purpose :

Returns the number of occurrences of searchString in text.

Didn't help .....

but after I thought about it...

I added ≥ 1 and that did it..... so thanks.

If ( PatternCount ( field ; "ugly" ) ≥ 1 ;"Removed";field)

[efen]

If ( PatternCount ( fieldname; " ugly" );"Removed"; fieldname ) works for me

[comment]

I added ≥ 1 and that did it...

There's no reason for that.

Note also that

PatternCount ( field ; "ugly" )

will return true when field contains "smugly".

[Cabinetman]

Hhuuummm.... Well it didn't work until I put that in.

Not sure why unless I missed some setting on the field itself.

Edit: Although now it does so go figure...

Edited October 25, 2010 by Guest