View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] lance-news@augustmail.com is offline
external usenet poster
 
Posts: 22
Default line breaks in a variable

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