AnsweredAssumed Answered

Formula to remove text after a space or "."

Question asked by Charlesdh on Jan 29, 2017
Latest reply on Jan 29, 2017 by user19752



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.