Skip to Content
0
Former Member
Jun 13, 2013 at 08:51 AM

Implementing Custom Cleansing Package on BODS

26 Views

Hi All,

I am able to execute my Custom Cleansing package ,after creating it in Information Steward 4.1 and imporiting the ATL in BODS 4.1.

But there is an issue.

I want to replace RD word with Road. So I have

used the parsing strattegy as Parse data on whitespace and transitions between letters, numbers, or special characters.

for eg if the data is

2684 ABC RD

it should return

2684 ABC ROAD,

But instead it is returning only

ROAD

as the output field.

Can anybody guide me how to replace a particular variation by its standard form,keeping the ither words intact.

Thanks,

Mayank Mehta