Ad:

Python Discussion Thread
Marked Solved
Views: 702

Jul 6th, 2009

How to create tabs in a file??

Expand Post »

Hello everyone,

My file has text like:

gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 95 20 1 0 68 87 31017559 31017578 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 91.67 24 2 0 63 86 35247737 35247714 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 91.67 24 2 0 64 87 40549054 40549031 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 92 24 2 0 63 86 42462636 42462659 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 95 20 1 0 63 82 45774066 45774085 4.4 32.3

I want to make it tab delimited...

Can anyone suggest on this??

Thanks in advance...!!

Similar Threads

Unable to create an excel file in VB.net in VB.NET
I want to Create PDF file from Delphi,Pls help me in Pascal and Delphi
How do you create a text file? in C
how to create swf file in vb6 from bmp imgs in directory and wav file in Visual Basic 4 / 5 / 6
Create .wav file with C# in C#

joe82

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

27 posts
since Jul 2009

Permalink

Jul 6th, 2009

Re: How to create tabs in a file??

Well you can write a tab by using the escape character and t. So if you were writing a tab to a file you would go something like this:

python Syntax (Toggle Plain Text)
f = open("File.txt",'w')
f.write("\t This will be indented one tab space!")
f.close()
f = open("File.txt",'w')
f.write("\t This will be indented one tab space!")
f.close()

So the \t is the escape sequence used to indicate a tab.

Hope that helps

Last edited by Paul Thompson; Jul 6th, 2009 at 6:10 pm.

Paul Thompson

Reputation Points: 264

Solved Threads: 183

Veteran Poster

Offline

1,095 posts
since May 2008

Permalink

Jul 6th, 2009

Re: How to create tabs in a file??

Thanks for replying..

Can you please change my program given below to include tab ??

python Syntax (Toggle Plain Text)
 
from __future__ import with_statement
 
with open ('C:\\Documents and Settings\\Desktop\\file2.txt') as fil:
    f = fil.readlines()
    result = []
    for line in f:
        line = line.split()
        if len(line) >= 3:
            i = float(line[2])
            if 90 <= i < 100:
                line = ' '.join(line)
                result.append(line)
 
 
 
with open('C:\\Documents and Settings\\Desktop\\j3.txt','w')as resultfile:
     resultfile.write('\n'.join(result))
from __future__ import with_statement

with open ('C:\\Documents and Settings\\Desktop\\file2.txt') as fil:
    f = fil.readlines()
    result = []
    for line in f:
        line = line.split()
        if len(line) >= 3:
            i = float(line[2])
            if 90 <= i < 100:
                line = ' '.join(line)
                result.append(line)


                
with open('C:\\Documents and Settings\\Desktop\\j3.txt','w')as resultfile:
     resultfile.write('\n'.join(result))

in above code my output file is in the format:

gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 95 20 1 0 68 87 31017559 31017578 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 91.67 24 2 0 63 86 35247737 35247714 4.4 32.3

I want each column to be separated by a tab:

Please help..!!

Thanks in advance,...

joe82

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

27 posts
since Jul 2009

Permalink

Jul 7th, 2009

Re: How to create tabs in a file??

you can try this

python Syntax (Toggle Plain Text)
from __future__ import with_statement
fil = open('C:\\Documents and Settings\\Desktop\\file2.txt','rb')
resultfile  = open('C:\\Documents and Settings\\Desktop\\j3.txt','wb')
for line in fil:
    if len(line.split('|')) >= 3:
        i = float(line.split('|')[2])
        if 90 <= i < 100:
            resultfile.write('%s\r\n'%''.join(line.replace('|','\t')))
from __future__ import with_statement
fil = open('C:\\Documents and Settings\\Desktop\\file2.txt','rb')
resultfile  = open('C:\\Documents and Settings\\Desktop\\j3.txt','wb')
for line in fil:
    if len(line.split('|')) >= 3:
        i = float(line.split('|')[2])
        if 90 <= i < 100:
            resultfile.write('%s\r\n'%''.join(line.replace('|','\t')))

Last edited by baki100; Jul 7th, 2009 at 6:32 am. Reason: errors

baki100

Reputation Points: 12

Solved Threads: 14

Junior Poster in Training

Offline

79 posts
since Apr 2009

Permalink

Jul 7th, 2009

Re: How to create tabs in a file??

python Syntax (Toggle Plain Text)
 
from __future__ import with_statement
 
with open ('C:\\Documents and Settings\\Desktop\\file2.txt') as fil:
    f = fil.readlines()
    result = []
    for line in f:
        line = line.split()
        if len(line) >= 3:
            i = float(line[2])
            if 90 <= i < 100:
                line = ' '.join(line)
                result.append(line)
 
 
 
with open('C:\\Documents and Settings\\Desktop\\j3.txt','w')as resultfile:
     resultfile.write('\n'.join(result))
from __future__ import with_statement

with open ('C:\\Documents and Settings\\Desktop\\file2.txt') as fil:
    f = fil.readlines()
    result = []
    for line in f:
        line = line.split()
        if len(line) >= 3:
            i = float(line[2])
            if 90 <= i < 100:
                line = ' '.join(line)
                result.append(line)


                
with open('C:\\Documents and Settings\\Desktop\\j3.txt','w')as resultfile:
     resultfile.write('\n'.join(result))

is taking input file ( which has tabs exactly as i explained above)

gnl|dbSNP|rs13484116 gi|62750812|ref|NC_005111.2|NC_005111 100 16 0 0 300 460 28912367 28912382 4.4 32.3
gnl|dbSNP|rs13484116 gi|62750812|ref|NC_005111.2|NC_005111 95 20 1 0 300 387 31017559 31017578 4.4 32.3

and result file is:
gnl|dbSNP|rs13484116 gi|62750812|ref|NC_005111.2|NC_005111 95 20 1 0 300 387 31017559 31017578 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 91.67 24 2 0 63 86 35247737 35247714 4.4 32.3

i just want my result file to be tab delimited as my input file so that i can put it in xl sheet and do whatever i have to ..or can parse it again for many different things for which i already have codes...

Please help me on this...

Many Thanks...

joe82

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

27 posts
since Jul 2009

Permalink

Jul 7th, 2009

Re: How to create tabs in a file??

You mean something like this:

python Syntax (Toggle Plain Text)
# data string read from a file
data = """\
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 95 20 1 0 68 87 31017559 31017578 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 91.67 24 2 0 63 86 35247737 35247714 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 91.67 24 2 0 64 87 40549054 40549031 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 92 24 2 0 63 86 42462636 42462659 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 95 20 1 0 63 82 45774066 45774085 4.4 32.3
"""
 
new_data = ""
for line in data.split('\n'):
    # replace each space with a tab
    line = line.replace(" ", "\t")
    new_data += line + '\n'
 
# test only ...
print(new_data)
 
# now write new_data string to a file
# data string read from a file
data = """\
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 95 20 1 0 68 87 31017559 31017578 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 91.67 24 2 0 63 86 35247737 35247714 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 91.67 24 2 0 64 87 40549054 40549031 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 92 24 2 0 63 86 42462636 42462659 4.4 32.3
gnl|dbSNP|rs13484118 gi|62750812|ref|NC_005111.2|NC_005111 95 20 1 0 63 82 45774066 45774085 4.4 32.3
"""

new_data = ""
for line in data.split('\n'):
    # replace each space with a tab
    line = line.replace(" ", "\t")
    new_data += line + '\n'

# test only ...
print(new_data)

# now write new_data string to a file

Ene Uran

Reputation Points: 625

Solved Threads: 211

Posting Virtuoso

Offline

1,704 posts
since Aug 2005

Permalink

Jul 7th, 2009

Re: How to create tabs in a file??

Thank you....

joe82

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

27 posts
since Jul 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Python Forum Timeline: Hello World! Computer Programming for Kids and Other Beginners

Next Thread in Python Forum Timeline: Don't you love newbie Questions ??

DaniWeb Message

Cancel Changes

User Name
Password