Fixed Width variable question.

2004-12-06 Thread Jeff Waris
Does anyone have a good technique they use to make a fixed width variable to insert into a text file? For example I have an order number, it can be 3,4,5 or 6 characters long Lets say: 123 1234 12345 123456 ...and I need to format them at 9 characters long by inserting 0's in the beginning:

RE: Fixed Width variable question.

2004-12-06 Thread Katz, Dov B (IT)
I think #numberFormat(num,0)# should do the trick. -dbk -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 1:50 PM To: CF-Talk Subject: Fixed Width variable question. Does anyone have a good technique they use to make a fixed width

Re: Fixed Width variable question.

2004-12-06 Thread Greg Morphis
Use numberformat #numberformat(num1,0)# On Mon, 6 Dec 2004 13:50:01 -0500, Jeff Waris [EMAIL PROTECTED] wrote: Does anyone have a good technique they use to make a fixed width variable to insert into a text file? For example I have an order number, it can be 3,4,5 or 6 characters

RE: Fixed Width variable question.

2004-12-06 Thread Jeff Waris
column start and finsh in the text file... Hope I was more clear this time.. :) Jeff -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 1:54 PM To: CF-Talk Subject: RE: Fixed Width variable question. I think #numberFormat(num

RE: Fixed Width variable question.

2004-12-06 Thread Katz, Dov B (IT)
a certain column start and finsh in the text file... Hope I was more clear this time.. :) Jeff -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 1:54 PM To: CF-Talk Subject: RE: Fixed Width variable question. I think

RE: Fixed Width variable question.

2004-12-06 Thread Marlon Moyer
RJustify(string, length) -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 1:06 PM To: CF-Talk Subject: RE: Fixed Width variable question. Maybe I didn't explain this good enough... LOL Its Monday I know that I can format

RE: Fixed Width variable question.

2004-12-06 Thread Jeff Waris
That did the trick... Thanks! Jeff -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 2:26 PM To: CF-Talk Subject: RE: Fixed Width variable question. RJustify(string, length) -Original Message- From: Jeff Waris