how to convert fix length file to csv file in python?

Question

In the file each columns have fix size.

Is there any library or function available using that we can convert easily to CSV file ?

There are four columns in the file.

1st - 1233212Q1AQYHDVCS1221
2nd - 64342343EDV53234212
3rd - 11123321111124122
4th - 52122211

Sample records :

1233212Q1AQYHDVCS1221 64342343EDV53234212 11123321111124122
52122211

1233212Q1AQYHDVCS1221 64342343EDV53234212 11123321111124122
52122211

1233212Q1AQYHDVCS1221 64342343EDV53234212 11123321111124122
52122211

1233212Q1AQYHDVCS1221 64342343EDV53234212 11123321111124122
52122211

1233212Q1AQYHDVCS1221 64342343EDV53234212 11123321111124122
52122211

I would like to convert straight forward that file to CSV.

what is 52122211 after each line? – Rahul Jul 13 '17 at 04:32 — Rahul, Jul 13 '17 at 04:32
52122211 is column .. !! – Emipro Technologies Pvt. Ltd. Jul 13 '17 at 04:33 — Emipro Technologies Pvt. Ltd., Jul 13 '17 at 04:33
your line 1 has 3 column and line 2 has 1 column and so on? – Rahul Jul 13 '17 at 04:35 — Rahul, Jul 13 '17 at 04:35

score 1 · Accepted Answer · answered Jul 13 '17 at 04:28

1

If the columns are separated by whitespace, simple sed can do it:

sed 's/[\t ]+/,/g' input.txt > output.txt

answered Jul 13 '17 at 04:28

Raunak Agarwal

7,117
6
38
62

the question has the python tag. – Jean-François Fabre Jul 13 '17 at 04:46
11123321111124122 value converted to 1.11233211111241E+016. I have tried `sed 's/[\t ]+/,/g' input.txt > output.csv` – Emipro Technologies Pvt. Ltd. Jul 13 '17 at 04:50
Both values are same, I think it might be related to how your csv editor displays the data. Try opening it with a text editor like `vim`, `nano` or `notepad` to verify – Raunak Agarwal Jul 13 '17 at 16:43

how to convert fix length file to csv file in python?

1 Answers1