Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Oct 2012
    Posts
    8
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Changing the file format of .csv

    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

  • #2
    New to the CF scene
    Join Date
    Oct 2012
    Posts
    8
    Thanks
    2
    Thanked 0 Times in 0 Posts
    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
    ====================================


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •