Hi,
I,m writing an UDF function to pass all elements into one string in target side.
I just want to know the UDF function for Exists functionality as it available in standard function. There are 50 fileds in the input structure. All are optional and we need to concat all the fileds into one field in out put side. If the fileds are not exist then need to pass Empty value for that filed. It is too difficult to check all the filelds by Standard Graphical Exists function. SO I thought of writing an UDF for that.
Input:
http://lntinfotech.com/FieldGlass">
<PO_ACK_DETAILS>
<ZTPSYS>CRC</ZTPSYS>
<DOCNO>123</DOCNO>
<PRNO/>
<PONO>132</PONO>
<GRDetial>
<GRNo/>
<GR_Line/>
<Message>
<Test1/>
<Text2/>
</Message>
</GRDetial>
</PO_ACK_DETAILS>
</ns0:MT_POResponseOut>
Output:
<Upload>
<user> X</user>
<data>CRC;123; ;132</data>