Originally posted by: SystemAdmin
Hi All,
I have encountered a strange bahaviour of the text FIND function of the WTX.
I use funcational map:
=NUMBERTOTEXT(FIND(SERIESTOTEXT(EXTRACT(NarrativeVal_S SubField:Narrative_C Class:inputCard,q Narrative_C AttValue:Narrative_C AttList:Narrative_C Class:inputCard="PACO" )), "OWNT"))
And the result is "0".
Bua a functional map like this:
=SERIESTOTEXT(EXTRACT(NarrativeVal_S SubField:Narrative_C Class:inputCard,q Narrative_C AttValue:Narrative_C AttList:Narrative_C Class:inputCard="PACO"))
returns the text:
BENE/LSTS/INDVBENE/RESD/YOWNT/OWNE
that is text string "OWNT/OWNE" should be found in the first functional map.
I can't understant this.
Will be very appreciate for your help.
I need your knowledge ASAP.
#IBM-Websphere-Transformation-Extender#IBMSterlingTransformationExtender#DataExchange