AnsweredAssumed Answered

Solution to split and lookup each value indivdually

Question asked by deepak.agrawal on Jan 22, 2016
Latest reply on Jan 27, 2016 by Adam Arrowsmith



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.