Python - remove spaces and indents from string

Question

I have a sql query string

query_for_update = 
f'''
update {db_name}.{schema_name}.{self.table_name}
set {self.updated_field} = {self.updated_field}
where {self.key_field} in ({ids});
'''

But when I try to write this query to file f.write(query_for_update) I get following result:

update store_1.dbo.[my_table]
            set [Trusted Plan] = [Trusted Plan]
            where [Entry No_] in (1472371,
1472375,
1472377,
1472379,
1472373,
);

Code that creates string:

ids_string = ',\n'.join(["'" + str(item) + "'" for item in result.id])
query_for_update = mssql_table.get_update_query('dbo', mssql_db_name, ids_string).strip()
with open(mssql_server_name + '.sql', 'a') as f:
    f.write(query_for_update)

How can i remove indents for strings in this case?

You should include the code which actually writes this f-string to file. — Tim Biegeleisen
– Tim Biegeleisen, Commented Jul 8, 2022 at 6:46

mousetail · Accepted Answer · 2022-07-08 06:51:00Z

2

You can use textwrap.dedent (standard library):

import textwrap

query = textwrap.dedent(f"""\
    update {db_name}.{schema_name}.{self.table_name}
    set {self.updated_field} = {self.updated_field}
    where {self.key_field} in ({ids});
""")

print(query)

This will remove all leading spaces that are common between every line. Useful for tipple quoted strings.

answered Jul 8, 2022 at 6:51

mousetail

8,1696 gold badges31 silver badges53 bronze badges

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

Comments

ignacio · Accepted Answer · 2022-07-08 17:44:23Z

1

You can use the str.strip() function with a for loop to fix it.

for x in list: 

  if x.strip():

    list2.append(x)

then you can use list2 as your new usable list

edited Jul 8, 2022 at 17:44

ignacio

1,1972 gold badges16 silver badges29 bronze badges

answered Jul 8, 2022 at 7:35

CompressedSquid

631 silver badge10 bronze badges

Comments

Pieter Geelen · Accepted Answer · 2022-07-08 06:52:42Z

0

you can use the str.stip method https://www.w3schools.com/python/ref_string_strip.asp

For indentations and breaks you need to consider that you might need to use \n. There is also a dedent method in the textwrap library that could be interesting for you. https://docs.python.org/3/library/textwrap.html

I hope this helps :)

answered Jul 8, 2022 at 6:52

Pieter Geelen

5482 silver badges12 bronze badges

Collectives™ on Stack Overflow

Python - remove spaces and indents from string

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related