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.
