DATA Step, Macro, Functions and more

Perl to remove \X0A\

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 96
Accepted Solution

Perl to remove \X0A\

Hi there,

For your kind information, I am trying to remove \X0A\ with a space from my text "string" using perl in base sas.

Can someone modify my code to make it functional. Although I can use tranword funtion to do so but my desire is to use perl because in future by using escape character function, I will able to use it in variety of other situations in text mining.

 

I am using the following code: [for text substituion=s/pattern/new text/]

 

data test2;

set test1;

 string= prxchange("s/\/X0A\/ /",-1,string);

run;

 

Thank you in advance for your kind reply.

 

Regards,

Deepak

Swain

Accepted Solutions
Solution
‎04-28-2016 10:18 AM
Respected Advisor
Posts: 4,644

Re: Perl to remove \X0A\

If those \X0A\ are actual characters then

prxchange("s/\\X0A\\/ /io", -1, string)

will work. Note I assumed it is a zero between X and A. Correct if needed. 

PG

View solution in original post


All Replies
Respected Advisor
Posts: 4,644

Re: Perl to remove \X0A\

 

 

prxchange("s/\x0a/ /o", -1, string)
PG
Frequent Contributor
Posts: 96

Re: Perl to remove \X0A\

It contains the actual string for example: "Nothing abnormality\X0A\ is detected." . It may be noted that there is "\" both before and after X0A. which has to be removed also.
Swain
Respected Advisor
Posts: 3,777

Re: Perl to remove \X0A\

Does the string contain the actual sequence /X0A/ or does it contain the character='0A'x aka ascii character 10?

 

 

Frequent Contributor
Posts: 96

Re: Perl to remove \X0A\

It contains the actual string for example: "Nothing abnormality\X0\ is detected."
Swain
Frequent Contributor
Posts: 96

Re: Perl to remove \X0A\

It contains the actual string for example: "Nothing abnormality\X0A\ is detected."
Swain
Solution
‎04-28-2016 10:18 AM
Respected Advisor
Posts: 4,644

Re: Perl to remove \X0A\

If those \X0A\ are actual characters then

prxchange("s/\\X0A\\/ /io", -1, string)

will work. Note I assumed it is a zero between X and A. Correct if needed. 

PG
Frequent Contributor
Posts: 96

Re: Perl to remove \X0A\

Hi there, it works fine. Thanks a lot.
Swain
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 298 views
  • 1 like
  • 3 in conversation