Mapsubstring or Mapping case sensitive fieldvalues

[#1]

I have two fieldvalues coming from different Sources and they are

Pasteur Opwarmen and Pasteur opwarmen. These values are both same. How can I adjust them.

I tried Mapsubstring like this

M_MappingID:
Mapping
LOAD * INLINE [
 F1, F2
 Pasteur Opwarmen, Pasteur opwarmen
];

Table:
Load....
.....
Mapsubstring('M_MappingID','Pasteur Opwarmen'),
applymap(...)
From
files/...
;

I dont see any change.

Any ideas??

Thanks

sravan

[Miguel_Angel_Baeyens · Accepted solution]

Hello Sravan,

Using

ApplyMap('M_MappingID', OldFieldName) AS NewFieldName

where OldFieldName is the name of the field that stores the old value and NewFieldName is the name you want to use the new changed value in the table should work.

Is this what you are looking for?

Regards

EDIT: If you are working with names, you may use function Capitalize, should all words in that field begin with capital letter, so

Capitalize(FIELD)

where FIELD contains 'aaa bbb' will return 'Aaa Bbb'

[#3]

Thanks capitalize worked..