Configuration Command

Set the field separator for subsequent queries.

fs [STRING] 

STRING 

A string value representing the text you want displayed as the field separator. If you omit STRING, the field separator is set to a null string.

The default is "".

Description

When this command is issued, STRING consists of the rest of the command line, including white space, up to the statement terminator. This means the fs string can be more than one word. To enter leading spaces or tabs, use the backspace (\) character.

Be sure to choose a field separator value that will not appear in the returned data. If you do not, it will be impossible to distinguish between data and separators when parsing the result. ASCII control characters (for example, Ctrl-B) are useful as field separators, since it is unlikely that these characters will appear in the returned data. For example, Alt+2 (keypad) will generate Ctrl-B and the character will appear as J

Example

response to Query

   send "fs |\n" to SQL

   send "select * from org" to SQL 

 

response to line from SQL

   extract from input

   take to "|" FirstColumn