8 Replies Latest reply on Jan 29, 2017 7:55 PM by user19752

    Formula to remove text after a space or "."




      I found this formula.


      Left(ImageName, Position(ImageName;" ";1;1) -1)



      which works. However, it will remove the text if it's format is with out a space after the name. Ie

      If the field is "12345" the formula will remove it. Thus showing a blank.

      Also if the image name is "12345.jpg" it does not remove the ".jpg". Which I believe the formula needs to be modified for this situation.