Issue in removing extra characters from string python

Question

I have a string given as:

text = """'select \\"ORDER_ID\\",\\r\\n    \\"LINE_ID\\",\\r\\n    \\"PRODUCT_ID\\",\\r\\n    \\"CUSTOMER_ID\\",\\r\\n    \\"PAYMENT_METHOD\\",\\r\\n    \\"STATUS\\",\\r\\n    \\"DATETIME_ORDER_PLACED\\",\\r\\n    \\"DATETIME_ORDER_SHIPPED\\",\\r\\n    \\"ORDER_QTY\\",\\r\\n    \\"ORDER_AMOUNT\\",\\r\\n    \\"ORDER_COST\\",\\r\\n    \\"ORDER_VAT\\",\\r\\n    \\"SHIPPING_COSR\\"\\r\\nfrom \\"DEMO\\".\\"DEMO\\".\\"ORDERS\\""

I am trying to clean this using below code:

text = text.replace("\\", '').replace('"', '')

I got the following result:

'select ORDER_ID,rn    LINE_ID,rn    PRODUCT_ID,rn    CUSTOMER_ID,rn    PAYMENT_METHOD,rn    STATUS,rn    DATETIME_ORDER_PLACED,rn    DATETIME_ORDER_SHIPPED,rn    ORDER_QTY,rn    ORDER_AMOUNT,rn    ORDER_COST,rn    ORDER_VAT,rn    SHIPPING_COSRrnfrom DEMO.DEMO.ORDERS

I cannot figure out why I am getting rn with every word. How I can get rid of this ? I even tried using text = text.strip('\r\n') but it is not working.

Pro-tip: never sanitize SQL inputs yourself. How are you getting those characters in your string in the first place? Is it feasible to clean your data upstream? — Maximilian Burszley
– Maximilian Burszley, Commented Dec 15, 2022 at 13:45
It would be better if you post your desired output. I would surely provide you a solution. — Ajay Pun Magar
– Ajay Pun Magar, Commented Dec 15, 2022 at 13:49

Nice Zombies · Accepted Answer · 2022-12-15 15:36:35Z

1

Like this:

text = query_text = 'select \\"ORDER_ID\\",\\r\\n    \\"LINE_ID\\",\\r\\n    \\"PRODUCT_ID\\",\\r\\n    \\"CUSTOMER_ID\\",\\r\\n    \\"PAYMENT_METHOD\\",\\r\\n    \\"STATUS\\",\\r\\n    \\"DATETIME_ORDER_PLACED\\",\\r\\n    \\"DATETIME_ORDER_SHIPPED\\",\\r\\n    \\"ORDER_QTY\\",\\r\\n    \\"ORDER_AMOUNT\\",\\r\\n    \\"ORDER_COST\\",\\r\\n    \\"ORDER_VAT\\",\\r\\n    \\"SHIPPING_COSR\\"\\r\\nfrom \\"DEMO\\".\\"DEMO\\".\\"ORDERS\\"'
print(text.replace('\\"', '"').replace('\\r', "\r").replace("\\n", "\n"))

Output:

select "ORDER_ID",
    "LINE_ID",
    "PRODUCT_ID",
    "CUSTOMER_ID",
    "PAYMENT_METHOD",
    "STATUS",
    "DATETIME_ORDER_PLACED",
    "DATETIME_ORDER_SHIPPED",
    "ORDER_QTY",
    "ORDER_AMOUNT",
    "ORDER_COST",
    "ORDER_VAT",
    "SHIPPING_COSR"
from "DEMO"."DEMO"."ORDERS"

You get these kinds of strings for example when you call the repr function on a string:

print(repr('''new line:
'single quotes',"double quotes"'''))

Output:

'new line:\n\'single quotes\',"double quotes"'

Escaping is commonly used on the web.

edited Dec 15, 2022 at 15:36

answered Dec 15, 2022 at 14:05

Nice Zombies

1,2051 gold badge7 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nokia mobile Over a year ago

thanks working . can you please tell any reference from which I can read this topic further ?

LinFelix · Accepted Answer · 2022-12-15 13:38:07Z

0

You will have to replace \\r\\n first. You can do that by

text = text.replace("\\r\\n", '').replace("\\", '').replace('"', '')

answered Dec 15, 2022 at 13:38

LinFelix

1,0662 gold badges15 silver badges24 bronze badges

4 Comments

nokia mobile Over a year ago

thanks for reply . I am getting SHIPPING_COSRfrom . but I want this From seprate with space. why it's not adding space here ?

LinFelix Over a year ago

There is no space in your original string, how would the space get there?

Nice Zombies Over a year ago

You've just stripped these characters from the string, but they had a purpose. You needed to unescape them

LinFelix Over a year ago

The question seems to be unclear then, I understood the question to ask how to remove the newline characters...

Collectives™ on Stack Overflow

Issue in removing extra characters from string python

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related