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

line breaks in a variable
 

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

wrote in message
...
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