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

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

 

Outcomes