Thanks for your replies.
The translate filter is what i use for this kind of thing but since the data is like what i said above i cannot iterate through the data to map each of it to it appropriate data.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.