Fixed length record - Plain Text - Forum - Rollbase - Progress Community

Fixed length record - Plain Text

 Forum

Fixed length record - Plain Text

This question is not answered

How to export data to text file with fixed record length?

for instance:

120161109XYZbbbbbbbbbbZ000100

120161109ABCbbbbbbbbbbZ000150

120161009ABCbbbbbbbbbbZ000090

Any idea

All Replies
  • I think you should be able to use a formula field and add the padding/leading characters using code.

    You may then export the formula field.

    ex.

    var test = "{!field#value}";

    while (test.length != 20) {

    test += "0"; //add character 0 until the length is 20.

    }

    return test;

    Hope that helps.