Removing Noise wordss

[#1]

Hello,

I have a field in a table that has names of people/company. This field will also have noise words like 'Not Applicable', 'Unknown'....

There is a complete list of such noise words. Is there way I can remove all these noise words from the field.

Thanks in advance

[#2]

Have you tried using replace?

Replace(NameField,'NoiseWord','')

/Martin

[Anonymous]

If I understand correctly you have a list of proper names with words like 'Not applicable' mixed in. You also have a list of these words.

If you want to replace the values with something else I would suggest reading up on Mapping Loads.

If you wish to simply remove the values that contain 'Not Applicable' and other similar things I would first load the list of Noise words and then load the Name field itself and in that load statement use a Where Not Exists condition to only load those rows where the name does not occur on the noise list.

[#4]

Hi Manju,

You can able to achieve this by using exists() function.

There are different ways of using exists() function.

Attached application will help you solve your problem.

Regards

Sridhar

[#5]

Thanks you all

[rwunderlich]

I think this may be easiest to do with MapSubstring().

NoiseMap:
MAPPING LOAD *, null()
;
LOAD * INLINE [
x
Terminated
Unknown
Not Applicable
where's waldo?
]
;
Names:
LOAD MapSubString('NoiseMap', Name) as Name
;
LOAD * INLINE [
Name
Company A Inc
Company B Terminated
Paul Not Applicable Smith
where's waldo? Jack Unknown Jones
]
;

-Rob