Sometimes you need to export RedShift to Fixed-Width Text, you can use Withdata DBToFile as RedShift to fixedwidth Exporter (Unloader / Extractor / Dumper).
Works GREAT on Windows, Mac and Linux.
Support Windows, Linux, and macOS.
Can run in CLI (Command Line Interface), for Scheduled Tasks and Streams, for Automation.
After exporting RedShift to Fixed-Width Text in GUI, and Saving "RedShift to Fixed-Width Text" session, then you can:
After exporting RedShift to Fixed-Width Text in Command Line, then you can schedule and automate "RedShift to Fixed-Width Text" conversion task by: