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

Hello

 

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.

Thanks
Deepak

Outcomes