AnsweredAssumed Answered

"Whitespace Trim" String Function doesn't work?

Question asked by AndrewSchooley1591 on Jul 27, 2015
Latest reply on Jul 27, 2015 by ManuThommes7331

I have a process that captures candidate data from my Recruiting system (Taleo) and puts it into a Flat File for import into my HR/Payroll system (ADP). A surprisingly common issue is that candidates will accidentally add a superflous space at the end of their mailing address when they apply for jobs. If their address ends with a space on the import file, ADP will actually reject the record. I attempted to resolve this issue by adding a "Whitespace Trim" string function but it doesn't seem to be working...With this function in place, I'm testing a value that comes through on my files as "23804 Eagle Pass Rd ". Am I missing something?