Hello all.

I have two fields Ordernumber and line number. I want to join them together to become one number but its a bit more special than that.

order:5082544

line:050

what i want =0005082544000050

order:5082544

line:500

what i want =0005082544000500

order:5082544

line:5000

what i want =0005082544005000

Although not a great way of doing it I was doing this with some if statemants depending on the length on the ordernumber but something tells me this is not the best way of doing it.

Any thoughts.

Jord

Well after a bit of laying about I went with this

Right ( "000" & ccg_3::order_number ; 10 )& Right ( "0000" & ccg_3::line_number ; 6 )

Which appears to do what I want , still not sure if its the proper way of doing it though

Try:

SerialIncrement ( "0000000000000000" ; 10^6 * order + line )

Edited June 19, 200916 yr by Guest
Corrected a typo (thanks to LaRetta for catching it!)