Originally posted by: SystemAdmin

Hello

I need help in creating a index using the following data.

Bundle Identifier
aa to zz, 00 to 99, a0 to 9z, etc.

the issue is I need to use two (bytes) combination to create a unique indentifier for about 15,000 records and I'm not sure how to index using alpha numeric characters.

thank you very much.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: repanzer

Good question. And I have to break up this post, because i'm getting an error "Disallowed content detected" and I don't know what the hell it's talking about.

I don't believe you can add 1 to "A", to make it "B", but you can convert back and forth from BCD;
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: repanzer

So =TEXTTOBCD("41")
will equate to "A", TEXTTOBCD("42") = "B", and so on.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: repanzer

You can make the value for the TEXTTOBCD function a variable, and GETANDSET allows you to add a number to a numeric variable.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: repanzer

This website will not let me post my response, so it's in the attached file.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange