how to generate an alphanumeric seq

dsproj2003 · Post by **dsproj2003** » Tue Sep 02, 2003 11:10 pm

Hi,

I have PX 6.0.

How to generate a an alphanumeric seq in a job?
for eg:-
Requirement1
-AA
-AB
-AC
-AD

Requirement2 (alphabets concated with a range of numbers, say till 3)
-AA1
-AA2
-AA3
-AB1
-AB2
-AB3..

Please reply asap.

Thanks.
Nitin

ray.wurlod · Post by **ray.wurlod** » Wed Sep 03, 2003 1:20 am

That smacks severely of non-standard custom programming to me. It's the kind of thing we consultants do (in exchange for money). If you'd like me to quote, please respond via private message. [^]

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

roy · Post by **roy** » Wed Sep 03, 2003 2:31 am

Hi,
To my understanding,Waht your asking is:
has anyone done this and is that person willing to share?

Well I haven't yet.

I think you can do it yourself, but if I'm mistaken
and no one is willing to send you such a code,
you can, as Ray said, "hire" someone to do it for you.

Good Luck,

Roy R.

degraciavg · Post by **degraciavg** » Wed Sep 03, 2003 4:04 am

Nitin,

It's easy in DS Server... you just need to play around with the ASCII codes to generate this kind of sequence.

But the PX solution may be a little bit more tricky as BASIC routines are not directly runnable in PX. The reason is PX is written in C while DS Server routines are written in UV BASIC...

A possible work-around is to write a special routine in DS Server and call it from a Shared Container in PX... or simply, create a Server job to handle this process. The DS Server engine is also available at your disposal in DSPX 6.0 anyway.

Regards,
vladimir

bigpoppa · Post by **bigpoppa** » Wed Sep 03, 2003 7:40 am

Hi.

You could build this sequence using a _sequential_ PX transformer stage. You can set a stage var to the alphabet string (e.g. "ABCDEFGH..") and use substrings to grab the letter that you need for your index. You would need two other stage vars to keep track of the indexes you pass to the substring function.

-BP

Teej · Post by **Teej** » Wed Sep 03, 2003 9:54 am

quote:Originally posted by dsproj2003
[br]Hi,

I have PX 6.0.

[discussion of requirements]

Hmm. Sounds like a Buildop stage to me.

As Ray said -- consultants love to do stuff like this.

Too bad I'm not one... yet.

-T.J.

* * *

... now if this can make breakfast, my life is complete.