how to avoiding splitting string python?

Question

I am reading data from file inputfile.txt:

inputfile.txt:

    sch,tab,"select no,name,place from test"
    sch1,tab1,"select no,name,place from test1"

file1 = open('inputfile.txt', 'r')
Lines = file1.readlines()
[sch,tab,query]=line.split(",")
print(query)

It is printing like :'select no'

My expected output is : 'select no,name,place from test'

how to print complete query instead of sub query.

Unless you are specifically asking about how to solve a cross-version compatibility problem (in which case your question should obviously describe that problem) you should not mix the python-2.7 and python-3.x tags. I have removed the former. — tripleee
– tripleee, Commented May 3, 2021 at 11:08
If your actual question is how to avoid splitting quoted strings, probably look into the csv module, which does exactly this. — tripleee
– tripleee, Commented May 3, 2021 at 11:09

Rakesh · Accepted Answer · 2021-05-03 10:58:39Z

2

Use csv module with quotechar='"'

Ex:

import csv

with open('inputfile.txt') as infile:
    reader = csv.reader(infile, quotechar='"')
    for line in reader:
        sch,tab,query =line
        print(query)

Output:

select no,name,place from test
select no,name,place from test1

answered May 3, 2021 at 10:58

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

Comments

Arpit Choudhary · Accepted Answer · 2021-05-03 11:02:20Z

1

Split into 3 parts using second parameter to split()

[sch,tab,query]=line.split(",", 2)

answered May 3, 2021 at 11:02

Arpit Choudhary

1081 silver badge10 bronze badges

Comments

marc_s · Accepted Answer · 2021-05-04 19:22:16Z

0

If you split by , it will consider it from query as well.

You can split by select and use the last string as query check below example:

query = 'select ' + line.split('select')[-1]

or if your pattern is fix then you can do like this:

query = ','.join(line.split(',')[2:])

edited May 4, 2021 at 19:22

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered May 3, 2021 at 10:58

Amit Nanaware

3,3961 gold badge8 silver badges19 bronze badges

Comments

Finnbar M · Accepted Answer · 2021-05-04 19:24:51Z

0

All the other answers are correct but from what I think you're trying to do, check out the shlex module on python.org: https://docs.python.org/3/library/shlex.html

answered May 4, 2021 at 19:24

Finnbar M

1781 gold badge1 silver badge6 bronze badges

Collectives™ on Stack Overflow

how to avoiding splitting string python?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related