...

View Full Version : Changing the file format of .csv



chrisiboy
10-29-2012, 08:45 AM
Hi Guys,

How would I take a csv file and change the format of it?

I have the following : It's a CSV file that looks exactly like the below


IMSI, ICCID, MSISDN
901112112542731, 898709912412543000, 870772332028

I want it to look like the below : >Only it should be saved as an excel file

IMSI,901112112542731
ICCID,898709912412543000
MSISDN,870772332028

chrisiboy
10-29-2012, 12:24 PM
To be exact...

I have a csv file that looks like below :


IMSI ICCID MSISDN FAX ISDN56 ISDN64 APN
901112112542731 898709912412543000 870772332028 870782546182 870782548300 870782551182 c2c.bgan.inmarsat.com
901112112542731 898709912412543000 870772332028 870782546182 870782548300 870782551182 c2c.bgan.inmarsat.com



Basically I want it to look as follow : It must be saved then as a normal text

======= Package 1 ==========

IMSI 901112112542731
ICCID 898709912412542731
MSISDN 870772332028
FAX 870782546182
ISDN56 870782548300
ISDN64 870782551182
APN c2c.bgan.inmarsat.com


======= Package 2 ==========

IMSI 901112112542731
ICCID 898709912412542731
MSISDN 870772332028
FAX 870782546182
ISDN56 870782548300
ISDN64 870782551182
APN c2c.bgan.inmarsat.com


========= END OF PACKAGES ==========
= Total Processed: 2
= Date Processed: 2012-10-29
====================================



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum