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 )

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

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)

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

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".

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, 201015 yr by Guest