line breaks in a variable

  • Thread starter Thread starter lance-news
  • Start date Start date
L

lance-news

IO currently have the following variable in one continuous line:

sTables = "* Basic Tables. TEMPORARY. NUMERIC T0000000. LEAVE T0000000.
VARIABLE LABEL T0000000 'Table Total'. VALUE LABELS T0000000 0 ' '.
TABLES /FORMAT BLANK MISSING('.') /OBSERVATION " & myVars4ANOVA & "
/TABLES (" & myVars4Table & ") BY (" & Groupvar & "+ T0000000) >
(STATISTICS) /STATISTICS mean( ( F7.2 ))."

The program I am passing the variable sTables to needs sTables to look
exactly like:

sTables = "* Basic Tables.
TEMPORARY.
NUMERIC T0000000.
LEAVE T0000000.
VARIABLE LABEL T0000000 'Table Total'.
VALUE LABELS T0000000 0 ' '.
TABLES /FORMAT BLANK MISSING('.') /OBSERVATION " &
myVars4ANOVA & " /TABLES (" & myVars4Table & ") BY (" & Groupvar
& "+ T0000000) > (STATISTICS) /STATISTICS mean( ( F7.2 ))."

so that there is a line break after each period mark.
I cannot figure out how to create line breaks within the parentheses?


Lance
 
sTable = Application.Substitute(sTable,".", vbNewLine & ".")

you might also try vbCr or vbLf in place of vbNewline (vbNewline is
equivalent to vbCRLF in windows).

Regards,
Tom Ogilvy
 
Back
Top