Numeric value into words.

[Nikhil2725]

Hi All,

I have a database where the values will be stored as the numeric values in one interactivity_data_type_id(3).

Interactivity_data_type_id	Value
1	Abc
2	Def
3	4,3,2
4	Xyz
5	mno

For those numeric value text are as below.

1-Specific(Not Realistic)

2-Realistic(Not Specific)

3- Both Specific and Realistic

4-Not Specific or Realistic

Now I want to display the relevant text for those numeric value s below.

Interactivity_data_type_id	Value
1	Abc
2	Def
3	Not Specific or Realistic, Both Specific and Realistic, Realistic(Not Specific)
4	Xyz
5	mno

Kindly help me in displaying as above..

[ahmetozsari]

Hello,

Try this in script,

ReplaceMap:
MAPPING LOAD * INLINE [
Interactivity_data_type_id, def
1, Specific(Not Realistic)
2, Realistic(Not Specific)
3, Both Specific and Realistic
4, Not Specific or Realistic
];

load *,if(isnum(PurgeChar(Value,','))='-1',MapSubString('ReplaceMap', Value),Value) as Replaced;
LOAD * INLINE [
Interactivity_data_type_id, Value
1, Abc
2, Def
3, "4,3,2"
4, Xyz
5, mno
];

[Nikhil2725]

Hi Ahmetozsari,
Thanks for the reply.
One more thing is like I just want to put this logic only for the Interactivity_data_type_id=3.