Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to add a line feed character

Status
Not open for further replies.

zencalc

IS-IT--Management
Feb 27, 2002
67
US
I'm using Crystal to export data into a character separated values file. Does anyone know a way to create a formula to add a line feed character at the end of a set of fields? Or possibly a special character I can add to the design view in the appropriate place? This is only important for adding the formatting once its out of Crystal. As of now, without the line feed, the fields are separated by characters, true, but its awfully hard to read and troubleshoot. Thanks in advance,
Brian
 
Line feed is chr(10)
Return is chr(13)

Jim Broadbent
 
A chr(13) in a formula won't help if you're doing a CSV export.

Consider changing the delimiter to a tilde ~, and then post process alter it or leverage it as being purdy dang unique...

Another option is to use the Text export, or the Comma or Tab delimited export.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top