Remove All Spaces and All Carriage Returns From HTML Field

[Jredeemer14]

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

[comment]

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

[Jredeemer14]

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

[Lee Smith]

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

[comment]

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

Well, then =

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

should work for you.

[Aussie John]

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) ; "" ])