SOLVED - Search / Replace syntax

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

SOLVED - Search / Replace syntax

Mark Webb-5
  Sorry to waste your time - the solution is actually simple.

if b5s = "+" b5s="".
exe.

Wrap a do repeat/end repeat around this for many variables.


   I have a string variable containing brand names ending with a +. If
there is no brand there is still a +.
I want to remove the + when there is NO brand name.
Example - I have -
Record Brand
1             Abc+
2             +
3             Xyz+
I want -
1             Abc+
2
3             Xyz+

I can do this in data view - edit/replace/entire cell......
I looked for the syntax in the log but it does not register.
Is there search/replace/entire cell syntax available as the data view
version needs to be done 1 variable at a time&  I have many variables?
Looked at the Replace String Function but can't get the "entire cell"
option I require.
Any suggestions?

--
Mark Webb

Line +27 (21) 786 4379
Cell +27 (72) 199 1000
Fax to email +27 (86) 5513075
Skype  webbmark
Email  [hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD