General information
Category:
Coding, syntax & commands
Title:
Formatting a text file
The contents of expression ALLTRIM(field1) is "info 01 ABCD". If I send this expression to a text file by the code: SELECT ALLTRIM (field1) FROM table1 TO FILE myfile PLAIN, it places "info 01 ABCD" into the text file but with unwanted spaces before and after. What I need is the exact expression "info 01 ABCD", a carriage return and no empty spaces after. For example if I send four ALLTRIM(field1)’s to the text file one after the other it will be formatted as
info 01 ABCD
info 01 ABCD
info 01 ABCD
info 01 ABCD
Is this possible? Can I control formatting in a text file to that extent?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only