Originally posted by: SystemAdmin

I have a senario whrere I need to count no of characters present in a xml structure without Namespace characters.
<pc:Strd>
<pc:CdtrRefInf><pc:Tp><pc:CdOrPrtry><pc:Cd>SCOR</pc:Cd></pc:CdOrPrtry><pc:Issr>ISO</pc:Issr></pc:Tp><pc:Ref>RF1234567890123456</pc:Ref></pc:CdtrRefInf>
</pc:Strd>
In the above data I need to count the length of entire data. But while counting I need to excule the namespace like 'pc:' here.
I can do a SUBSTITUE("pc:","") for this purpose. But I am not sure that always 'pc:' will come as Namespace.
So is there any Function in WTX which I can use for replacing Namespaces?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: thorstenhirsch

Sure you can - just copy the input card to the output and remove the namespace prefix in the output card's settings.
But that's a ridiculous task. I don't think that you really want to do that.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: Dhiren.Ghelani

the xml should have a namespace declaration. you can use word function around it to know the namespace.. again not sure why you have to do it and it sounds daft.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

I need to count the no of characters in the <Strd>xxxx</Strd> without Namespace characters.
Thats the reason I want to remove the Namespace for a particular group and not for entire data.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender