<div>
That is fine, but where indicated on the file I need those &quot;&nbsp;&quot; on certain fields not all fields otherwise my import will not work.
</div>

<div>
here is an entry that is correct for upload, how do I get only certain fields &quot;&nbsp;&quot; 
 
0,&quot;AM2010000&quot;,&quot;221 CHARMAN RD CHELTENHAM&quot;,1,0.00,19950117,20110701,19950117,&lt;NULL&gt;,1,FLGEN,GENERAL,FL00,&lt;NULL&gt;,5814,100,0,0,&quot;&quot;,5899,0,1,0,20110705,1,0
</div>

<div>
You should remove the quotes from the excel file before saving as csv. It will automatically insert quotes when saving
</div>

<div>
But I only need the quotes around these fields 
,&quot;AM2010000&quot;,&quot;221 CHARMAN RD CHELTENHAM&quot;, 
 
when you save as csv and open in notepad it puts the quotes around everything, how do you keep the quotes I need and remove the other ones? 
 
ie 
 
 
&quot;0,&quot;,&quot;&quot;&quot;AM2010001&quot;&quot;,&quot;,&quot;&quot;&quot;CHELTENHAM DIR REVAL&quot;&quot;,&quot;,&quot;1,&quot;,&quot;214000,&quot;,&quot;20010731,&quot;,&quot;20110701,&quot;,&quot;20010731,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1,&quot;,&quot;FLGEN,&quot;,&quot;GENERAL,&quot;,&quot;FL00,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;5814,&quot;,&quot;100,&quot;,&quot;0,&quot;,&quot;0,&quot;,&quot;&quot;&quot; &quot;&quot;,&quot;,&quot;5887,&quot;,&quot;0,&quot;,&quot;1,&quot;,&quot;0,&quot;,&quot;20110701,&quot;,&quot;1,&quot;,&quot;0,&quot; 
&quot;0,&quot;,&quot;&quot;&quot;AM2010002&quot;&quot;,&quot;,&quot;&quot;&quot;LAIDLEY CREMATORIUM (LAND)&quot;&quot;,&quot;,&quot;1,&quot;,&quot;0,&quot;,&quot;19961223,&quot;,&quot;20110701,&quot;,&quot;19961223,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1,&quot;,&quot;CLGEN,&quot;,&quot;GENERAL,&quot;,&quot;CL00,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;3719,&quot;,&quot;100,&quot;,&quot;0,&quot;,&quot;0,&quot;,&quot;&quot;&quot; &quot;&quot;,&quot;,&quot;69,&quot;,&quot;0,&quot;,&quot;1,&quot;,&quot;0,&quot;,&quot;20110701,&quot;,&quot;1,&quot;,&quot;0,&quot; 
&quot;0,&quot;,&quot;&quot;&quot;AM2010004&quot;&quot;,&quot;,&quot;&quot;&quot;BUILDING REFURBISHMENT&quot;&quot;,&quot;,&quot;1,&quot;,&quot;417694.92,&quot;,&quot;20090315,&quot;,&quot;20110701,&quot;,&quot;20090315,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1,&quot;,&quot;FBIMP,&quot;,&quot;GENERAL,&quot;,&quot;FB00,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;3706,&quot;,&quot;100,&quot;,&quot;0,&quot;,&quot;0,&quot;,&quot;&quot;&quot; &quot;&quot;,&quot;,&quot;6339,&quot;,&quot;0,&quot;,&quot;1,&quot;,&quot;0,&quot;,&quot;20110701,&quot;,&quot;1,&quot;,&quot;0,&quot; 
&quot;0,&quot;,&quot;&quot;&quot;AM2010006&quot;&quot;,&quot;,&quot;&quot;&quot;SHELVING&quot;&quot;,&quot;,&quot;1,&quot;,&quot;2949.47,&quot;,&quot;20050830,&quot;,&quot;20110701,&quot;,&quot;20050830,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1,&quot;,&quot;FFGEN,&quot;,&quot;GENERAL,&quot;,&quot;FF00,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1220,&quot;,&quot;100,&quot;,&quot;0,&quot;,&quot;0,&quot;,&quot;&quot;&quot; &quot;&quot;,&quot;,&quot;5555,&quot;,&quot;0,&quot;,&quot;1,&quot;,&quot;0,&quot;,&quot;20110701,&quot;,&quot;1,&quot;,&quot;0,&quot; 
&quot;0,&quot;,&quot;&quot;&quot;AM2010007&quot;&quot;,&quot;,&quot;&quot;&quot;AIR CONDITIONER&quot;&quot;,&quot;,&quot;1,&quot;,&quot;338.44,&quot;,&quot;20050501,&quot;,&quot;20110701,&quot;,&quot;20050501,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1,&quot;,&quot;PEGEN,&quot;,&quot;GENERAL,&quot;,&quot;PE00,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;2602,&quot;,&quot;100,&quot;,&quot;0,&quot;,&quot;0,&quot;,&quot;&quot;&quot; &quot;&quot;,&quot;,&quot;5516,&quot;,&quot;0,&quot;,&quot;1,&quot;,&quot;0,&quot;,&quot;20110701,&quot;,&quot;1,&quot;,&quot;0,&quot; 
&quot;0,&quot;,&quot;&quot;&quot;AM2010011&quot;&quot;,&quot;,&quot;&quot;&quot;SERVER&quot;&quot;,&quot;,&quot;1,&quot;,&quot;5078.77,&quot;,&quot;20080207,&quot;,&quot;20110701,&quot;,&quot;20080207,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1,&quot;,&quot;ITHSE,&quot;,&quot;GENERAL,&quot;,&quot;IT00,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1220,&quot;,&quot;100,&quot;,&quot;0,&quot;,&quot;0,&quot;,&quot;&quot;&quot; &quot;&quot;,&quot;,&quot;5993,&quot;,&quot;0,&quot;,&quot;1,&quot;,&quot;0,&quot;,&quot;20110701,&quot;,&quot;1,&quot;,&quot;0,&quot; 
&quot;0,&quot;,&quot;&quot;&quot;AM2010013&quot;&quot;,&quot;,&quot;&quot;&quot;COMPUTER&quot;&quot;,&quot;,&quot;1,&quot;,&quot;737.62,&quot;,&quot;20080512,&quot;,&quot;20110701,&quot;,&quot;20080512,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1,&quot;,&quot;ITHPC,&quot;,&quot;GENERAL,&quot;,&quot;IT00,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1220,&quot;,&quot;100,&quot;,&quot;0,&quot;,&quot;0,&quot;,&quot;&quot;&quot; &quot;&quot;,&quot;,&quot;6077,&quot;,&quot;0,&quot;,&quot;1,&quot;,&quot;0,&quot;,&quot;20110701,&quot;,&quot;1,&quot;,&quot;0,&quot; 
&quot;0,&quot;,&quot;&quot;&quot;AM2010016&quot;&quot;,&quot;,&quot;&quot;&quot;IPHONE&quot;&quot;,&quot;,&quot;1,&quot;,&quot;729.13,&quot;,&quot;20101002,&quot;,&quot;20110701,&quot;,&quot;20101002,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1,&quot;,&quot;OEMPC,&quot;,&quot;GENERAL,&quot;,&quot;OE00,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1220,&quot;,&quot;100,&quot;,&quot;0,&quot;,&quot;0,&quot;,&quot;&quot;&quot; &quot;&quot;,&quot;,&quot;6773,&quot;,&quot;0,&quot;,&quot;1,&quot;,&quot;0,&quot;,&quot;20110701,&quot;,&quot;1,&quot;,&quot;0,&quot; 
&quot;0,&quot;,&quot;&quot;&quot;AM2010017&quot;&quot;,&quot;,&quot;&quot;&quot;PROJECTOR&quot;&quot;,&quot;,&quot;1,&quot;,&quot;608.84,&quot;,&quot;20040701,&quot;,&quot;20110701,&quot;,&quot;20040701,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1,&quot;,&quot;OEGEN,&quot;,&quot;GENERAL,&quot;,&quot;OE00,&quot;,&quot;&lt;NULL&gt;,&quot;,&quot;1220,&quot;,&quot;100,&quot;,&quot;0,&quot;,&quot;0,&quot;,&quot;&quot;&quot; &quot;&quot;,&quot;,&quot;5348,&quot;,&quot;0,&quot;,&quot;1,&quot;,&quot;0,&quot;,&quot;20110701,&quot;,&quot;1,&quot;,&quot;0,&quot; 

</div>

<div>
How about save as in Text (MS DOS)?
</div>

<div>
No that did not work either see result &nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/07_w29/478078/Book1.txt" target="_blank" class="file-inline" title="txt msdos save (1 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Book1.txt</a> 
 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010000&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;221 CHARMAN RD CHELTENHAM&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CORP&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;NONE&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010001&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CHELTENHAM DIR REVAL&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CORP&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;NONE&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010002&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;LAIDLEY CREMATORIUM (LAND)&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CORP&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;NONE&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010004&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;BUILDING REFURBISHMENT&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CORP&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;S_005.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010006&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;SHELVING&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CORP&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;S_040.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010007&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AIR CONDITIONER&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CORP&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;S_018.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010011&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;SERVER&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CORP&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;S_022.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010013&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;COMPUTER&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CORP&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;S_050.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010016&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;IPHONE&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CORP&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;S_014.29&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010017&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;PROJECTOR&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CORP&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;NONE&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010000&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;221 CHARMAN RD CHELTENHAM&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;TAX&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;NONE&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010001&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;CHELTENHAM DIR REVAL&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;TAX&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;NONE&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010002&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;LAIDLEY CREMATORIUM (LAND)&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;TAX&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;NONE&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010004&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;BUILDING REFURBISHMENT&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;TAX&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;D_005.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010006&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;SHELVING&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;TAX&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;D_010.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010007&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AIR CONDITIONER&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;TAX&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;D_010.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010011&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;SERVER&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;TAX&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;D_050.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010013&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;COMPUTER&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;TAX&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;D_050.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010016&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;IPHONE&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;TAX&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;D_030.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;AM2010017&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;PROJECTOR&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;TAX&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20110701 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&quot;&quot;D_010.00&quot;&quot;&quot; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00 
 
 
what I need to see is the following 
 
0,&quot;AM2010000&quot;,&quot;221 CHARMAN RD CHELTENHAM&quot;,1,0.00,19950117,20110701,19950117,&lt;NULL&gt;,1,FLGEN,GENERAL,FL00,&lt;NULL&gt;,5814,100,0,0,&quot;&quot;,5899,0,1,0,20110705,1,0 
</div>

Book1.txt

<div>
I found the answer so easy. 
 
Accept the data with the string fields and commas in excel or csv. 
simply copy and paste into text all and all okay. 
 

</div>

<div>
I was working on this while you accepted the answer. You might like to try this macro which can save you a couple of steps. 
 
Sub wcsv() 
Dim rw As Range, cel As Range 
Dim csvs As String, sfn As String 
For Each rw In ActiveSheet.UsedRange.Rows 
For Each cel In rw.Cells 
csvs = csvs &amp;&nbsp;cel.Value &amp;&nbsp;&quot;,&quot; 
Next cel 
csvs = Left(csvs, Len(csvs) - 1) &amp;&nbsp;vbCrLf 
Next rw 
sfn = Application.GetSaveAsFilename(&quot;&quot;, &quot;(*.txt),*.txt&quot;, 1) 
Open sfn For Output As #1 
Print #1, csvs 
Close 1 
End Sub 

</div>

<div>
<div class="content wysiwyg-content">
I have to import data into an applicatin and the only way it will accep it is in txt field, I can copy and paste into text. how can i input ',' after each field and &quot;&nbsp;&quot; to incdicate string fields. 
 
here is a sammple file 
 
<a href="https://filedb.experts-exchange.com/incoming/2011/07_w28/476628/excel.xls" target="_blank" class="file-inline" title="excel file for ',' and ' &quot; ' (16 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>excel.xls</a>
</div>
</div>

excel.xls

I have to import data into an applicatin and the only way it will accep it is in txt field, I can copy and paste into text. how can i input ',' after each field and " " to incdicate string fields.

here is a sammple file


Saving excel file to text comma between each field

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.