Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Remove Double Quotes from Flat File  (Read 16919 times)

0 Members and 1 Guest are viewing this topic.

Squashman



    Specialist
  • Thanked: 134
  • Experience: Experienced
  • OS: Other
Re: Remove Double Quotes from Flat File
« Reply #15 on: December 04, 2014, 09:04:37 AM »
I concur with everyone's recommendation on using REPL, JREPL or FindRepl.

Your other option is Vbscript which we could create a batch file that creates the vbscript code and then execute the vbscript.

Geek-9pm


    Mastermind
  • Geek After Dark
  • Thanked: 1026
    • Gekk9pm bnlog
  • Certifications: List
  • Computer: Specs
  • Experience: Expert
  • OS: Windows 10
Re: Remove Double Quotes from Flat File
« Reply #16 on: December 04, 2014, 03:53:51 PM »
Just for general reference.
http://en.wikipedia.org/wiki/Comma-separated_values
Quote
A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted as binary numbers. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields.

A general standard for the CSV file format does not exist, but RFC 4180 provides a de facto standard for some aspects of it.
Excel and similar spreadsheets have CSV conversions built-in. Use of a batch script is needed in only a few cases.
Just saying...

stew2652



    Beginner

    Thanked: 2
    • Experience: Familiar
    • OS: Windows 7
    Re: Remove Double Quotes from Flat File
    « Reply #17 on: December 05, 2014, 08:45:26 AM »
    The quote from Wikipedia says "Usually, all records have an identical sequence of fields".  Shouldn't it be all the time?  If any one of the records is not identical with all of the others (as far as the number of fields), it will be mis-aligned when opening up in Excel.

    Squashman



      Specialist
    • Thanked: 134
    • Experience: Experienced
    • OS: Other
    Re: Remove Double Quotes from Flat File
    « Reply #18 on: December 05, 2014, 09:16:45 AM »
    The quote from Wikipedia says "Usually, all records have an identical sequence of fields".  Shouldn't it be all the time?  If any one of the records is not identical with all of the others (as far as the number of fields), it will be mis-aligned when opening up in Excel.
    I have seen some weird data in my time.  There are files that have a record identifier at the beginning of the line to tell you what the layout of the file is.  This was pretty common back in the days of Cobol programming.

    Also, Excel can handle embedded line feeds if they are enclosed in quotes.