Harmonize value of 'map' field

[SanderND]

The field 'map' from NewRecruit is filled with 'Map A1'. From Warhall it's 'A1'. Can this be harmonized so that all entries use the same registration? E.g. 'A1'.

[SanderND]

Currently i need this formula to harmonize the values in the 'map' field:

IF ((isnull([Map])=TRUE) or [Map]="OTHER" or [Map]="Custom Map") THEN "No map info"
ELSEIF([data_source]="NEW_RECRUIT") THEN SPLIT([Map]," ",2)
ELSE [Map]
END