Re: [sqlite] Limit Column Width

2008-04-07 Thread Fred J. Stephens
Dennis Cote wrote: > You can use the replace() function to strip the newlines from your > strings. You could replace the newlines with empty strings or with a > single space. The trick is entering the newlines. You can enter them > directly in an sql script file. > > select

Re: [sqlite] Limit Column Width

2008-04-07 Thread Dennis Cote
Fred J. Stephens wrote: > How can I limit the width of column returned by a query? > In a bash script I am returning an ID, and a text field from a table. > The text field can be any length, contain newlines, etc. The problems is > if a row of results contains a new line, the "grid" of rows and

[sqlite] Limit Column Width

2008-04-06 Thread Fred J. Stephens
How can I limit the width of column returned by a query? In a bash script I am returning an ID, and a text field from a table. The text field can be any length, contain newlines, etc. The problems is if a row of results contains a new line, the "grid" of rows and columns is messed up. I can