<br><br>
<div><span class="gmail_quote">On 10/24/07, <b class="gmail_sendername">Walter Vaughan</b> <<a href="mailto:wvaughan@steelerubber.com">wvaughan@steelerubber.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Kenneth Brody wrote:<br><br>> Quoting <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> (Tue, 23 Oct 2007 22:10:27 -0400):
<br>>>I am familiar with using export for ascii and other files -- I predominantly<br>>>use it to create comma delim files.<br>>>How would you create a tab delimitted file? I know it's with the delimiter
<br>>>flag but do you use the ascii code for a tab instead of<br>>>what I normally put as a ',' ??<br>> f=\t<br><br>Here's the fundamental problem (unless it's been fixed since 5.0-ODBC)...<br>
<br> EXPORT ASCII alias = name R=n F=m O=y C=z<br><br> Example: Export word-processing files, where "R" is record<br> indicator, "F" is field separator, "O" is opening
<br> field delimiter, "C" is closing delimiter.<br><br>It didn't go on to exlain what the possible values are for "nmyz"<br><br>Any modern IDE with command completion would have that.
<br><br>So even if someone who was going to be a smart alec (like I was) and were to<br>say, "Put your cursor on a "Then" line and hit F10, then F9, and type EXPORT"<br><br>But it really doesn't tell you, and whats worse is below is this
<br><br>Syntax<br> EXPORT WORD assign = filename<br> EXPORT ASCII assign = /pathname r=N f=,<br><br>Which I belive would put "N"'s between the records for the bottom example. I<br>havent tested it but kosher would be EXPORT ASCII assign = /pathname r=\n f=,
<br><br>Stuff like this is what makes the 20 somethings I show filePro laugh at me for<br>clinging to my old fashioned ways.<br><br>--<br>Walter<br>...who has no clue as to why he wrote this message.</blockquote>
<div> </div>
<div> </div>
<div>FWIW - I did look at the help in processing for the proper way to create what I wanted but the</div>
<div>help for export is pretty limited in that it doesn't tell you much other than how to use a comma as a delimiter -- what if you wanted to use a pipe or some other character (which oddly enough I have gotten requests for from other databases I work with, etc)
</div>
<div>Thanks again</div>
<div> </div>
<div>Scott</div><br> </div>