Spaces in my imported data

[tryphe]

I am trying to import data as a .csv and it is coming in with extra spaces in some of the fields. Is there a way int he import script or another script or calculation to have it delete unnecessary spaces in all the records?

Thanks

[QuinTech]

Hi tryphe, the Trim and Substitute functions should help you out. Trim removes leading and trailing spaces, and you can use Substitute to substitute one space for two, or one space for three, or whatever number you are encountering.

HTH,

Jerry

[tryphe]

Thank you the Trim function worked like a charm I didn't know that is what it did I am still figuring out all the new stuff on FM 7