format, ascii comma delimited?

Posted on 2008-11-14
Last Modified: 2013-11-24
I need someone to reformat a csv or excel file into ascii comma delimited in an ebsic format attached is the layout .
Question by:formatdummie
    LVL 22

    Accepted Solution

    You can save a file in comma-delimited format directly from Excel (File, Save As...).

    Then you'll just need a text editor that can save the file using the EBCDIC character set instead of binary. Google for that. There are plenty of freebie text editors around.
    LVL 20

    Assisted Solution

    A .csv file _is_ an ASCII comma-delimited file. If you have a native Excel file, then as dportas says, use Excel's File, Save As, and choose file type "CSV (comma-delimited)" to get to that format, then convert to EBCDIC.

    EBCDIC is an alternative character set to ASCII, used primarily on IBM mainframes.
    LVL 51

    Assisted Solution

    by:Mark Wills
    If you have regular need, pervasive have a pretty good set of tools - they were free a few months back - now look like $50 per year..., there is also some MS functions :

    or, are you just asking for that file to be converted and sent back ?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now