InterviewSolution
 Saved Bookmarks
    				| 1. | 
                                    Solve : Remove Double Quotes from Flat File? | 
                            
| 
                                   
Answer»  I concur with everyone's recommendation on using REPL, JREPL or FindRepl. 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.Excel and similar spreadsheets have CSV conversions built-in. Use of a batch SCRIPT is needed in only a few cases. Just saying...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. Quote from: stew2652 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.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.  | 
                            |