Address parsing issue with MNS stage

akonda · Post by **akonda** » Tue Jan 31, 2012 4:40 pm

I'm trying to parse below address using MNS stage but City column is populated with incorect value.

MARTONVASAR H-2462 HUNGARY

After parsing:
City = MARTONVASAR H
country code = HU

Is there anything that needs to be done in MNS stage or before MNS stage to parse address ??

rjdickson · Post by **rjdickson** » Wed Feb 01, 2012 4:06 am

Hi,

MNS does not support Hungry. Please see http://publib.boulder.ibm.com/infocente ... d%6e%22%20 for a list of countries.

Your best bet may be to use Address Verification Interface (AVI). However, AVI is an additional cost component.

rjdickson · Post by **rjdickson** » Wed Feb 01, 2012 4:59 am

Hi,

MNS does not support Hungry. Please see http://publib.boulder.ibm.com/infocente ... d%6e%22%20 for a list of countries.

Your best bet may be to use Address Verification Interface (AVI). However, AVI is an additional cost component.

akonda · Post by **akonda** » Wed Feb 01, 2012 9:43 am

since AVI stage is not available, is there any other way to handle this address with MNS stage or any other Quality stage stages ?

akonda · Post by **akonda** » Wed Feb 01, 2012 1:33 pm

Is it possible to remove invalid address part ("H-2462") from address column using MNS stage or Standardization stage ?

address: MARTONVASAR H-2462 HUNGARY

ray.wurlod · Post by **ray.wurlod** » Wed Feb 01, 2012 2:53 pm

You might look at an input pattern override. I presume that the H-2462 is a postal code of some kind. An input pattern override could parse this into a postal code field or discard it (whichever is appropriate).

You could edit the pattern-action language to achieve the same result, but that would mean you're creating a new rule set.