DSXchange

I have to convert source data by applying the abbreviation rules.

My Source Data is .

Source
2343 South Bay Street
1899 Ranch Building
345 North McArthur Road

target
2978 S Bay ST
1899 Ranch BLDG
345 North McArthur RD

Please help me with the logic

There are two says to do this.

1) Use Quality Stage and use Address Standardization.
2) Use a look up to substitute
South with S
Building with BLDG
Road with RD

Let me know if you need more information on the same.

I have recently implemented it with lookup stage in my project.

You can find official standarization lists out on the Internet if you don't already have your hands on them, including this pdf from the USPS.

You might investigate the Trans() function for your lookups against a hashed file. This allows you to specify fourth argument of "C" that returns the original code if the reference value is not found. It will save you coding a number of If..Then..Else constructs.

You will also, of course, have to parse your address into individual tokens. The Field() function is recommeded for this task.

I did use the standardization stage and it worked.

Sreedhar,
Out of curiousity,could you please explain me how I can use a lookup stage?.
If I put the values
North,N
South,S
Suite,STE
in lookup file
how do I match part of the string ex: I have 2343 South Bay Street with the values in the lookup file.

Thanks
Hope

QualityStage would do that parsing for you.

If you choose not to use QualityStage (maybe because you don't have it) then the parsing operation is something you have to do. I would recommend Field() functions into stage variables.

Is this a server job (as posted) or a parallel job (as marked)?

This is a parllel job

Then ignore my suggestion about Trans() function.

Moderator: please move to Enterprise Edition (parallel) forum

@Sreedhar

Can you please explain how did you implement this using lookup stage?