Most Viewed Topics
Latest topics
Top posting users this week
| No user |
Affiliates
Spaces in fields cause rejections
Page 1 of 1
Spaces in fields cause rejections
by kaimon 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.
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
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Medicaid ID #'s
» Video Surveillance System
» 2017 NCPTA Conference at Concord
» How to upload an attachment?
» Where do I go/how to I start a claim?
» Trading Partner Guide
» DSS Contract for Medicaid Transportation
» Repairs to LTV's too early
» TrIP_Maker Success with 837 Billing