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 is2684 ABC RD
it should return
2684 ABC ROAD,
But instead it is returning only
as the output field.
Can anybody guide me how to replace a particular variation by its standard form,keeping the ither words intact.