Community
    • Login

    EDIT .CSV file and SAVE as .CSV file

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    15 Posts 3 Posters 42.3k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Vijay BabuV
      Vijay Babu
      last edited by

      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

      Claudia FrankC 1 Reply Last reply Reply Quote 0
      • Claudia FrankC
        Claudia Frank @Vijay Babu
        last edited by

        @Vijay-Babu

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

        Cheers
        Claudia

        1 Reply Last reply Reply Quote 0
        • Vijay BabuV
          Vijay Babu
          last edited by

          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

          Claudia FrankC 1 Reply Last reply Reply Quote 0
          • Claudia FrankC
            Claudia Frank @Vijay Babu
            last edited by

            @Vijay-Babu

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

            Cheers
            Claudia

            1 Reply Last reply Reply Quote 0
            • Vijay BabuV
              Vijay Babu
              last edited by

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

              Thanks
              Vijay

              Claudia FrankC 1 Reply Last reply Reply Quote 0
              • Claudia FrankC
                Claudia Frank @Vijay Babu
                last edited by

                Hi Vijay,

                see screenshot

                Cheers
                Claudia

                1 Reply Last reply Reply Quote 0
                • Vijay BabuV
                  Vijay Babu
                  last edited by

                  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

                  Claudia FrankC 1 Reply Last reply Reply Quote 0
                  • Claudia FrankC
                    Claudia Frank @Vijay Babu
                    last edited by

                    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

                    1 Reply Last reply Reply Quote 0
                    • Vijay BabuV
                      Vijay Babu
                      last edited by

                      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

                      Claudia FrankC 1 Reply Last reply Reply Quote 0
                      • Claudia FrankC
                        Claudia Frank @Vijay Babu
                        last edited by

                        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

                        1 Reply Last reply Reply Quote 0
                        • Vijay BabuV
                          Vijay Babu
                          last edited by

                          Hi Claudia

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

                          Thanks!
                          Vijay

                          Claudia FrankC 1 Reply Last reply Reply Quote 0
                          • Claudia FrankC
                            Claudia Frank @Vijay Babu
                            last edited by

                            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

                            1 Reply Last reply Reply Quote 0
                            • Vijay BabuV
                              Vijay Babu
                              last edited by

                              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

                              Claudia FrankC 1 Reply Last reply Reply Quote 0
                              • AdrianHHHA
                                AdrianHHH
                                last edited by AdrianHHH

                                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++”.

                                1 Reply Last reply Reply Quote 0
                                • Claudia FrankC
                                  Claudia Frank @Vijay Babu
                                  last edited by

                                  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

                                  1 Reply Last reply Reply Quote 0
                                  • First post
                                    Last post
                                  The Community of users of the Notepad++ text editor.
                                  Powered by NodeBB | Contributors