Action Statement

Change the row delimiter used in text strings.

change TABLE_NAME row delimiter to STRING

TABLE_NAME

The identifier for a table.

STRING

The printable character you want to use as a row delimiter when converting multiple rows to and from text strings. The csv and tab column delimiter formats automatically set the row delimiter to be new line, but your application can also define its own string for the row delimiter.

Description

Use this statement to change the row delimiter used when converting rows to and from text strings.

Example

 

if (InputOK_BV) then

 copy "change Table row delimiter to \"" Str_SV "\""

   to MsgStr_SV

 action SendMsg

 if (Str_SV = "\\t") then

         copy "\t" to Str_SV

 end if

 if (Str_SV = "\\n") then

         copy "\n" to Str_SV

 end if

 change Table_TBL row delimiter to Str_SV

end if # InputOK

See Also

change column delimiter Action Statement

read Action Statement

table Object Definition

write Action Statement