Data extraction and manipulation in jython

Question

For a given file

For ex : 11 ,345 , sdfsfsfs , 1232

i need to such above records from a file , read 11 to delimiter and strip the white space and store in the another file , similarly 345 to delimiter strip the while space and store in the file. This way i need to do for multiple rows.

so finally in the other file the data should look like

11,345,sdfsfsfs,1232

Please suggest me the way. Thanks for your help.

Answer 1

Open the input file (1) and the output file (2) for reading and writing respectively.

file1 = open('file1', 'r')
file2 = open('file2', 'w')

Iterate over the input file, getting each line. Split the line on a comma. Then re-join the line using a comma, but first stripping the whitespace (using a list comprehension).

for line in file1:
   fields = line.split(',')
   line = ",".join([s.strip() for s in fields])
   file2.write(line + "\n")

Finally, close the input and output files.

file1.close()
file2.close()

I'm not sure of jython's capabilities when it comes to generators, so that is why I used a list comprehension. Please feel free to edit this (someone who knows jython better).

Answer 2

One approach you could take would be to remove all whitespace using the string.translate function.

import string

#makes a 256 character string that will be used in the translate function
trans_table = string.maketrans('', '')

file1 = open('file1', 'r')
file2 = open('file2', 'w')

for line in file1:
    file2.write(line.translate(trans_table, string.whitespace) + '\n')

    #Or the above could be written as:
#    line = line.translate(trans_table, string.whitespace)
#    file2.write(line + '\n')

file1.close()
file2.close()