completing a result

incognico · Post by **incognico** » Tue Sep 12, 2006 5:20 am

Hello !

I have a question.
a.JO_NUM = "RI"
i have this in sql server
a.JO_NUM+replicate(space(1),6-LEN(a.JO_NUM))
result : "RI "

with datastage i try this:
Fmt(Extraction.JO_Num, "6-Len(Extraction.JO_Num)'Space(1)'U")

But the result is not good.
result "RI"

if you have a idea ..... thanks.

Nick

loveojha2 · Post by **loveojha2** » Tue Sep 12, 2006 5:31 am

Try

Code: Select all

Fmt(Extraction.JO_Num,6-Len(Extraction.JO_Num) : ' L')

incognico · Post by **incognico** » Tue Sep 12, 2006 5:40 am

argh...

No the result is "RI " with 2 blank and not "RI " with 4 blank (6-len=>4)

kduke · Post by **kduke** » Tue Sep 12, 2006 6:47 am

I would use spaces() or str(). Should do what replicate used to do.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 12, 2006 6:57 am

Seems too complex to me. I'd use:

Code: Select all

Fmt(a.JO_NUM, "L#6")

incognico · Post by **incognico** » Tue Sep 12, 2006 7:02 am

Thank's Ray !
It's OK. :D