1.

Solve : Remove Double Quotes from Flat File?

Answer» <html><body><p>I concur with everyone's recommendation on using REPL, JREPL or FindRepl.<br/><br/>Your other option is Vbscript which we <a href="https://interviewquestions.tuteehub.com/tag/could-410026" style="font-weight:bold;" target="_blank" title="Click to know more about COULD">COULD</a> create a batch file that creates the vbscript code and then execute the vbscript.Just for general reference.<br/><a href="https://en.wikipedia.org/wiki/Comma-separated_values">http://en.wikipedia.org/wiki/Comma-separated_values</a><br/> Quote</p><blockquote>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 (<a href="https://interviewquestions.tuteehub.com/tag/numbers-22758" style="font-weight:bold;" target="_blank" title="Click to know more about NUMBERS">NUMBERS</a> 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.<br/><br/>A general standard for the CSV file format does not exist, but RFC 4180 provides a de facto standard for some aspects of it.<br/></blockquote> Excel and similar spreadsheets have CSV conversions built-in. Use of a batch <a href="https://interviewquestions.tuteehub.com/tag/script-345000" style="font-weight:bold;" target="_blank" title="Click to know more about SCRIPT">SCRIPT</a> is needed in only a few cases.<br/>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 <a href="https://interviewquestions.tuteehub.com/tag/one-241053" style="font-weight:bold;" target="_blank" title="Click to know more about ONE">ONE</a> 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<blockquote>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.<br/></blockquote> I have seen some weird data in my time.  There are files that have a record identifier at the beginning of the line to <a href="https://interviewquestions.tuteehub.com/tag/tell-1240910" style="font-weight:bold;" target="_blank" title="Click to know more about TELL">TELL</a> you what the layout of the file is.  This was pretty common back in the days of Cobol programming.<br/><br/>Also, Excel can handle embedded line feeds if they are enclosed in quotes.</body></html>


Discussion

No Comment Found

Related InterviewSolutions