Community

Find what: ^([0-9]+)"_
Replace with: \1_"

These are works better. Thank you very much Ak47wong.

Hello everyone,

I have following blocks:

10" wording 1"
11" wording 2"
12" wording 3"

10" wording 4"
11" wording 5"
12" wording 6"
...

I need to replace them with...

10 "wording 1"
11 "wording 2"
12 "wording 3"

10 "wording 4"
11 "wording 5"
12 "wording 6"
...

I know how to find and replace ...

Great. Thank you very much ben_josephs

I have list of variables in one column:

Q59BA
Q60BA
Q61BA
Q62BA
Q63BA
Q64BA
Q65BA
Q66BA
Q51CA

Please advise how to put them in one row like this:

Q59BA Q60BA Q61BA Q62BA Q63BA Q64BA Q65BA Q66BA Q51CA

Thanks.

Finally Done.

REARCH: /PFOOTNOTE=LEFT ".newpage"
REPLACE: /PFOOTNOTE=LEFT ".newpage"\n/TEXT A1\n/TEXT A2\n/TEXT A3\n/TEXT A4\n/TEXT A5

I have following syntaxes for more than 100 questions:

VARIABLE LABELS Q1 ''.
TABLES FORMAT=ZERO TFSPACE(0) SPACE
/PFOOTNOTE=LEFT ".newpage"
/TABLE=T+A1+A2+A3+A4+A5+A6+A7+A8+A9+A10
BY T2+Q1
/STAT=UNWT COUNT(T2(PAREN6)' ')
CPCT(Q1(PCT3)' ':
A1 A2 A3 A4 A5 A6 A7 A8 A9 A10).

So now, after this ...

Great!

Thank you Ben.

I have following data set:

2044226473 1 10.0 2.0 3.0 5.0
2044226690 1 7.0 1.0 5.0 4.0
2044228047 1 10.0 2.0 5.0 2.0
2044228660 1 9.0 1.0 5.0 5.0
2044228894 1 9.0 1.0 6.0 3.0
2044229139 1 10.0 2.0 7.0 3.0
2044229568 1 10.0 2.0 3.0 5.0

I need to add a new line with TEXT1, so final data set should be ...

Great! It works perfectly.

Thank you very much Bob.

Sorry, I have to add a new line with following text: /SORT A1

So final tables should be like this:

VARIABLE LABELS Q16 ''.
TABLES FORMAT=ZERO TFSPACE(0) SPACE NFRAME NBOX TTSPACE(1) PTSPACE(0)
/PFOOTNOTE=LEFT ".newpage"
/SORT A1
/TABLE=T+A1+A2+A3+A4+A5+A6+A7+A8+A9 BY T2+Q16
/STAT=COUNT(T2 ...

Hi Guys,

I have the following syntaxex to run about 100 tables:

VARIABLE LABELS Q16 ''.
TABLES FORMAT=ZERO TFSPACE(0) SPACE NFRAME NBOX TTSPACE(1) PTSPACE(0)
/PFOOTNOTE=LEFT ".newpage"
/TABLE=T+A1+A2+A3+A4+A5+A6+A7+A8+A9 BY T2+Q16
/STAT=COUNT(T2(PAREN6)' ') CPCT(Q16(PCT3)' ':
PRINT TABLES DEVICE ...

It works! Thank you very much...

Hi,

I have following commands in my program:

+ M2 [STDDEV F40.1]
…
+ M30 [STDDEV F40.1]
..
+ M42 [STDDEV F40.1]
…

I have to take out all this expressions from my text. I mean I would like to search and replace “+ M* [STDDEV F40.1]� with “ �.

Please advise how can I do that?

Thanks.

Thank you very much Ben.

OK. Got It. I had replaced All. Now its working. Great. Thanks.

Is there any way to put Table number too? Like after Table#1 put Table#1 - 3???

Thanks