I have a filemaker solution that extracts website html from different sites and puts them into a field and it would be SO much easier to use the html in that field if all the spaces and carriage returns throughout the field were gone, I've tried like the trim4 custom function, but couldn't make it work. Any suggestions, I've attached a sample file below.

SampleB.fp7.zip

Removing all spaces and carriage returns in a field is very easy; however I am not sure that is really what you want, as it will also change:

Frigidaire FPES3085KF Professional 30 Slide-In Electric Range - Stainless Steel

into:

FrigidaireFPES3085KFProfessional30Slide-InElectricRange-StainlessSteel

Actually is that is exactly what I want. No spaces at all

you could filter the field in a couple of ways. see if this custom function does what you want. http://www.briandunning.com/cf/922

Actually is that is exactly what I want. No spaces at all

Well, then =

Substitute ( HTML ; [ " " ; "" ] ; [ ¶ ; "" ] ; [ Char (10) ; "" ] )

should work for you.

Well, then =

Substitute ( HTML ; [ " " ; "" ] ; [ ¶ ; "" ] ; [ Char (10) ; "" ] )

should work for you.

I'm not sure this will eliminate double (or triple) spaces so the TRIMALL function might be useful if you think this might occur.

Substitute ( trimALL(HTML,1,3) ; [ ¶ ; "" ] ; [ Char (10) ; "" ])