EDIT .CSV file and SAVE as .CSV file



  • Hi there

    We are working on an .CSV file which has got spl. characters,so we need to correct the data in file and again save it back to .CSV, could not see .csv file format in drop down.

    can someone please help on this?? so that i can save the file back to CSV.

    Thanks in Advance!

    Thanks & regards
    Vijay



  • @Vijay-Babu

    if you opened it as csv - just press save - done.

    Cheers
    Claudia



  • Hi Claudia

    Yeah i open it as csv,but when i edit and save the file it prompts a popup with message " file will change the original format" - click yes/no.i have clicked yes unfortunately for unknown reasons still content in file is messed up/format is changed.

    Hence we can around Notepad++ ,but here cant see the option to save the file as CSV.

    Thanks
    Vijay



  • @Vijay-Babu

    could you please provide the debug info?
    Available via menu ?->debug-info

    Cheers
    Claudia



  • Could not locate this,can you please confirm where this path is ?? is it in Notepad++ or MSExcel.

    Thanks
    Vijay



  • Hi Vijay,

    see screenshot

    Cheers
    Claudia



  • Hi Claudia

    Thanks for the revert.Please refer below details.

    Notepad++ v7.2 (64-bit)
    Build time : Nov 2 2016 - 11:27:56
    Path : C:\Program Files\Notepad++\notepad++.exe
    Admin mode : OFF
    Local Conf mode : OFF
    OS : Windows 10
    Plugins : mimeTools.dll NppConverter.dll

    Thanks
    Vijay



  • Hi Vijay,

    I’m confused because I thought it might be related to one of the 3rd party plugins you’ve installed
    but you haven’t installed any.
    So if the file is really a csv I don’t see why it shouldn’t work.
    Could it be that you renamed a xlsx or any other excel format to csv instead of exporting it?
    Could you do me a favor and make a screenshot with this message?
    Maybe upload to imgur.com, it’s free - no registration needed.

    Cheers
    Claudia



  • Hi Claudia

    Appreciate your Quick turnaround.
    i am just trying to understand which screen shot do you need?
    is it Procedure 1: Open Original CSV file–> make required changes–>Save.
    2: Open CSV File in Notepad++ --> Edit required chhanges --> Save AS?

    And answer for below Q is
    Could it be that you renamed a xlsx or any other excel format to csv instead of exporting it?
    ANS: i am working on Orignal file only its a file that is converted from XLSX to CSV

    Thanks again for the support.

    Thanks
    Vijay



  • Hi Vijay,

    I was looking for a screenshot with the popup message “file will change…”
    It doesn’t matter if you use file-save or file-saveas - as long as it shows this popup.

    Cheers
    Claudia



  • Hi Claudia

    how do i attach snaps here.imgur does not work.
    it shows up blank screen.

    Thanks!
    Vijay



  • Hi Vijay,

    you can only embed links to images.
    The syntax is

    ![](www.whatever.my_image.png)
    

    If imgur doesn’t work for you maybe you can use another image hoster.
    I have to leave now, so I can’t respond for the next 8-10 hours.

    Cheers
    Claudia



  • Hi Claudia

    Sorry could not understand this syntax,how ever i am typing below the text in popup on saving the excel.

    Some features in your workbook might be lost if you save it as CSV(Comma delimited).
    Do you want keep using this format?

    YES NO HELP (Buttons)

    Hope this helps.
    Thanks in Advance!

    Thanks
    Vijay



  • The message “Some features in your workbook might be lost if you save it as CSV(Comma delimited)” is produced by Excel, not by Notepad++. You appear to be editing your CSV in Excel and then trying to save it.

    Find the CSV file in Windows Explorer. Use the context (right click) menu and select “Edit with Notepad++”. Then you can edit and save the file.

    Look at the top of the screenshot that Claudia posted. Note that it includes the text “Notepad++”.



  • Hi Vijay,

    that’s what i feared.
    As AdrianHHH already pointed out (btw. thanks for jumping in) Excel is producing
    this message. The reason is simple, when you have a normal Excel file the file
    contants formatting informations as well as the text which you see in Excel.
    When converting this format to csv all the formatting stuff gets deleted because
    a csv is a plain text file format.
    So you have to decide either using the Excel format, but then you cannot
    edit it by notepad++ safely or converting to csv and loosing all formatted stuff.

    Cheers
    Claudia


Log in to reply