Fixed length text output

[dwanjk]

Hi All,

I am writng a crystal report that needs to produce a fixed length (300bytes)output.I have read many posts regarding exporting to a .txt document and have benefitted from those posts along the way. One of my final issues is that the last 24 characters need to be blanks. In crystal the blanks are displayed, however, in notepad the .txt drops the blanks, leaving me with 276 bytes.

The formula that I am using is 'replicatestring("0",12) + replicatestring(" ",24)' to produce th following output... "000000000000 "

If there is anyone that can provide some insight into this problem I would much appreciate it

janine

 

[dwanjk]

I meant to say that the output should be "000000000000 " (or 12 "0"'s followed by 24 blanks)

 

[IanWaterman]

To pad a number with leading zeros

totext(numberfield, '000000000000', 0,"")

Ian

 

[CoSpringsGuy]

for grins i created a formula with your code (replicatestring("0",12) + replicatestring(" ",24)) and exported to text and the training spaces exported exactly as expected. How are you getting the info to notepad from your report?

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[CoSpringsGuy]

trailing*

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection