Spaces in fields cause rejections

View previous topic View next topic Go down

Spaces in fields cause rejections

Post by kaimon on Fri Feb 17, 2017 10:29 am

We understand that spaces at the end data strings may cause NCTracks to reject the record or the entire file. To identify spaces in your scheduling software, follow these steps:

Export the fields that may cause problems from your scheduling software into Excel along with some identifier like client ID, you can then use the Find tool and search for every combination of letters and numbers that may end with a blank, like a_, then b_, then c_... until 1_, 2_. You'll have to do it 36 times, but it should work.

You may have to use the Text to Columns tool to split columns with multiple words like Main Street into multiple columns, then only keep the data associated with the last word.


kaimon

Posts : 7
Join date : 2017-02-17
Job/Organization : ITRE

View user profile

Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum