Originally posted by: rarw

Hi,

I need to do a simple MID in a type tree rule on a text field with a length of 34, but it fails. I am wondering if this is a bug.

This fails:
MID ($, 15, 2) != "MC"

These work on the same field (but are not what I want):
LEFT ($, 2) != "MC"
MID ("12345123451234512345", 15, 2) != "MC"

Thanks for your time and help.
Becky
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: LaurentB

Hi Becky,

could you be a bit more specific ? When you say it fails, what do you get exactly as a result ?

A quick test on my installation (version 8.1 build 114) shows that it runs fine from end to end with the same rule as yours

Regards
Laurent
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: rarw

Hi Laurent,

Due to the holiday, and a class, I was unable to quickly respond to your posting, sorry!

It now looks like the MID function was failing due to the need to partition the type tree into records without "MC" and records with "MC". When the MID($15,2)!="MC" logic was used in the type tree, and an MC record was read, the map failed. It did not fail if there were no "MC" records in the file.

I wish I had the insight into WTx to explain why it failed prior to partioning the type tree/records. My uneducated guess is that when it read an "MC" record (MID($15,2)!="MC" was false) there was no alternative fields allocated to read/process the record.

Thanks for your time!
Becky
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

you have to give the restart proporty to your record group if you don't want the full file.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender