I am working with a simple DataMigrator flow that is extracting from an Excel source file and writing output to a text file. Running into an issue using RPAD with spaces. RPAD works with any printable character, but when using RPAD to pad with spaces - for example, RPAD(FIELD, 5,' ') - the padding does not render. Also, LPAD works with spaces just fine.This message has been edited. Last edited by: Edward,
WebFOCUS 8 Windows, All Outputs
October 23, 2019, 06:21 PM
Edward
Fixed with PRESERVESPACE=YES in the master file synonym access file.