1 Reply Latest reply on Jan 27, 2016 4:18 PM by macwombat

    Remove Text from Field Script

    DorianAskew

      Looking to create a script which will search a field for a word and remove it if it's there. I need the script to remove only the word (pre-determined) it's looking for, not the entire field.

        • 1. Re: Remove Text from Field Script
          macwombat

          You can use this step in a script:

          Set Field [Notes::Note; Substitute ( Lower ( Notes::Note ) ; "extraneous " ; "" )]

           

          NB:  1.  Replace Notes::Note with your tablename::fieldname

          2.  The substitute function is case sensitive so the Lower function controls for that.

          3.  Replace "extraneous" with the word you are trying to get rid of.  Include a space after the word (inside the inverted commas) and your remaining text won't end up with two spaces between words.

           

          HTH.  Chris