Stringing Text in SQR

You can use the commands string, by, and into in SQR to string together text by a particular character and put it into a file reference variable. Probably the most useful application for this is in creating a delimited file such as a CSV file.

Here's an example of the syntax

string $seq $emplid $lastname $firstname 'Y' by ',' into $testfile

The above code strings together the variables $emplid, $lastname, and $firstname as well as the constant value Y by a comma and stores the result into the $testfile file reference variable.

For a detail example, see this article on generating a CSV file from SQR.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License