I have a string of races like "White;Asian" which is semi-colon separated. But in the flat file I need to transform White to "W" and Asian to "A". So in the output I will need a string like "W;A".
Does anyone know a quick and clean solution for my problem? I need something that is scalable for 200+ values.
I appreciate anyone who can spare some time and provide a solution.