Export to Fixed Length Text

HCL Domino Domino Forum
1

Is it possible to export the Notes documents fields to a FIXED LENGTH file? I have used the other Export features and was very satisfied with the result.I am now sending our information to another agency and they wiill only receive the data in Fixed length.

Thanks for your time

JA

2

Subject: Export to Fixed Length Text

You mean fixed length record, not fixed length file, right?To get fixed length records you can pad all columns with a padding character * or space.

Add @Repeat formula to all columns in the view which you export.

FieldValue + @Repeat(“*”; ColumnWidth - @Length(FieldValue); ColumnWidth)

Regards,

Litty Joseph

3

Subject: RE: Export to Fixed Length Text

Thanks for the reponse.I am trying to export 20 fields into a Fixed length Text file.

If the field, say DollarValue is 4 characters wide, and the amount is 500 the text file must hold the 4 characters.

The file will look like 0000 500ABC with the space being the first blank space of the Dollar Value Field plus the 500. If a field is blank, but is 2 charcters wide, it must hold the space. Such as 0000ABC00 12345, the space is a 2 character field from a document that is blank.

Thanks for your time.