python code to remove spaces between double quote string

Question

CREATE TABLE "USER "."ACT" ( "ACTNO" SMALLINT NOT NULL, "ACTKWD" CHAR(6 OCTETS) NOT NULL, "ACTDESC" VARCHAR(20 OCTETS) NOT NULL) IN "USERSPACE1" ORGANIZE BY ROW;

I need to replace or trim spaces between the double quotes "user ", how do I do it in python.

The expected output for the given input string is

CREATE TABLE "USER"."ACT" ( "ACTNO" SMALLINT NOT NULL, "ACTKWD" CHAR(6 OCTETS) NOT NULL, "ACTDESC" VARCHAR(20 OCTETS) NOT NULL) IN "USERSPACE1" ORGANIZE BY ROW;

If you see in the output after the string "user" space was removed.

This looks like data that should be fixed at the source. Where does it come from? — Klaus D., Jun 01 '21 at 06:39
@programandoconro but that would replace even the space before the quotes. — Sid, Jun 01 '21 at 06:39
We couldn't fix it in the source, as the ddl is generated in a single command — MageshJ, Jun 01 '21 at 06:52

score 1 · Answer 1 · answered Jun 01 '21 at 06:44

1

use strip()
var="user "
print(var.strip())

answered Jun 01 '21 at 06:44

Himanshu Tripathi

13
1

Thanks for the quick response, but 'user ' is not fixed, it may vary, only create or replace table is fixed. the goal is to remove string between double quotes – MageshJ Jun 01 '21 at 06:50

ThePyGuy · Accepted Answer · 2021-06-01T07:06:43.123

0

You can use regex to find double-quoted occurrences first and then remove the spaces accordingly

import re
words = re.findall(r'".*?"', text)
for word in words:
    text = text.replace(word, word.replace(" ", ""))

OUTPUT:

'CREATE TABLE "USER"."ACT" ( "ACTNO" SMALLINT NOT NULL, "ACTKWD" CHAR(6 OCTETS) NOT NULL, "ACTDESC" VARCHAR(20 OCTETS) NOT NULL) IN "USERSPACE1" ORGANIZE BY ROW;'

edited Jun 01 '21 at 07:06

answered Jun 01 '21 at 06:57

ThePyGuy

13,387
4
15
42

score -2 · Answer 3 · answered Jun 01 '21 at 06:42

-2

As I understand you want to get rid of the whitespace at the ends of a string. The function .strip() does this. Example:

var = "  user  "
new_var = var.strip()
print(new_var)

Output:

'user'

answered Jun 01 '21 at 06:42

Party-with-Programming

165
2
8

Thanks for quick response, but 'user ' is not fixed, it may vary, only create or replace table is fixed. the goal is to remove string between double quotes – MageshJ Jun 01 '21 at 06:49
@MageshJ Does that mean you want just the whitespace in `'user '` (so `' '`) or do you want to turn `'user '` into a completely empty string (`''`)? If you just want the whitespace, slicing the string would work. – Party-with-Programming Jun 01 '21 at 06:55
I need to remove or trim space between double quote "user "."tablename" should be "user"."tablename" – MageshJ Jun 01 '21 at 06:59
@MageshJ is the period between `user` and `tablename` supposed to be part of the string, so `'user .tablename'` (and that you want it to be `'user.tablename'`?) or is the period supposed to be between strings? This link might be helpful https://stackoverflow.com/questions/8270092/remove-all-whitespace-in-a-string – Party-with-Programming Jun 01 '21 at 07:10

python code to remove spaces between double quote string

3 Answers3