how to remove the hyphen in a string variable

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

how to remove the hyphen in a string variable

thara vardhan-2
Dear List Members

I have string variable PremSTyp with the following values:

MINE-OPEN CUT
MINE-UNDERGROUND
HOUSE-DETACHED
HOUSE-SEMI DETACHED
HOUSE-TERRACE
HOUSE-VILLA/TOWNHOUSE
RESIDENTIAL-ACCOMMODATION
RESIDENTIAL-DWELLING
RESIDENTIAL-NON DWELLING
SCHOOL-PUBLIC PRIMARY
SCHOOL-PUBLIC SECONDARY

How do I remove the hyphen between the two words?

Any help is much appreciated.

thanks
regards
Thara Vardhan
Senior Statistician
Performance Improvement & Planning

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

The information contained in this email is intended for the named recipient(s)
only. It may contain private, confidential, copyright or legally privileged
information.  If you are not the intended recipient or you have received this
email by mistake, please reply to the author and delete this email immediately.
You must not copy, print, forward or distribute this email, nor place reliance
on its contents. This email and any attachment have been virus scanned. However,
you are requested to conduct a virus scan as well.  No liability is accepted
for any loss or damage resulting from a computer virus, or resulting from a delay
or defect in transmission of this email or any attached file. This email does not
constitute a representation by the NSW Police Force unless the author is legally
entitled to do so.

=====================
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
Reply | Threaded
Open this post in threaded view
|

AW: how to remove the hyphen in a string variable

Mario Giesel
Hello, Thara,

please check the REPLACE function:

COMPUTE new = REPLACE(old,"-"," ").

Good luck,
Mario



________________________________
Von: Thara Vardhan <[hidden email]>
An: [hidden email]
Gesendet: Donnerstag, den 4. Dezember 2008, 05:10:59 Uhr
Betreff: how to remove the hyphen in a string variable

Dear List Members

I have string variable PremSTyp with the following values:

MINE-OPEN CUT
MINE-UNDERGROUND
HOUSE-DETACHED
HOUSE-SEMI DETACHED
HOUSE-TERRACE
HOUSE-VILLA/TOWNHOUSE
RESIDENTIAL-ACCOMMODATION
RESIDENTIAL-DWELLING
RESIDENTIAL-NON DWELLING
SCHOOL-PUBLIC PRIMARY
SCHOOL-PUBLIC SECONDARY

How do I remove the hyphen between the two words?

Any help is much appreciated.

thanks
regards
Thara Vardhan
Senior Statistician
Performance Improvement & Planning

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

The information contained in this email is intended for the named recipient(s)
only. It may contain private, confidential, copyright or legally privileged
information.  If you are not the intended recipient or you have received this
email by mistake, please reply to the author and delete this email immediately.
You must not copy, print, forward or distribute this email, nor place reliance
on its contents. This email and any attachment have been virus scanned. However,
you are requested to conduct a virus scan as well.  No liability is accepted
for any loss or damage resulting from a computer virus, or resulting from a delay
or defect in transmission of this email or any attached file. This email does not
constitute a representation by the NSW Police Force unless the author is legally
entitled to do so.

=====================
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





====================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
Mario Giesel
Munich, Germany