Hello - On Dataflux DMS 2.7 I am trying to run Standardization -> U.S. Address Verification within a single Data Job. Single Input and Output from and to flat files(.xlsx Input, .csv Output). In the output file I noticed that a number of rows were offset one column to the right. Upon investigation, these rows appeared to have failed Standardization, but I'm not sure why. A few example data below: 1320 N BROADWAY - Suite #3 1320 N BROADWAY #1 2211 11TH AVE APT #B 2211 11TH AVE APT #A I'm not sure if it's failing because of the # sign? I understand it is a reserved character for regex. If that is the problem, how do I fix it? If not, whats's happening and how do I fix that? Thank you much!
... View more