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

    Formula to remove text after a space or "."

    Charlesdh

      Hi,

       

      I found this formula.

      [quote]

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

      [/quote]

       

      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.

       

       

      Thanks

      Charles