<html><body>
<p>Bruce,<br>
If you're on a linux system with perl:<br>
<br>
perl -pi -e 's/\t/,/g' filename<br>
<br>
is a perl one-liner that should replace all of the tabs with commas in the file, working on the file in place. I've used similar commands on text files up to 379 GB in size, although it does take a while for files that size.<br>
<br>
It does alter the file in place, which can be dangerous. It's best to test on a sample of the file :<br>
<br>
head filename> testfile ( take the first 10 lines of the file and write it to a separate file)<br>
perl -pi -e 's/\t/,/' testfile<br>
<br>
If the testfile works fine, use it on the main file.<br>
<br>
<br>
Doug<br>
<br>
<br>
Doug Newcomb <br>
USFWS<br>
Raleigh, NC<br>
919-856-4520 ext. 14 doug_newcomb@fws.gov<br>
---------------------------------------------------------------------------------------------------------<br>
The opinions I express are my own and are not representative of the official policy of the U.S.Fish and Wildlife Service or Dept. of the Interior. Life is too short for undocumented, proprietary data formats.<br>
<img width="16" height="16" src="cid:1__=0ABBFCE1DFF583498f9e8a93df938690@fws.gov" border="0" alt="Inactive hide details for "Clay, Bruce" <bclay@ball.com>">"Clay, Bruce" <bclay@ball.com><br>
<br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td style="background-image:url(cid:2__=0ABBFCE1DFF583498f9e8a93df938690@fws.gov); background-repeat: no-repeat; " width="40%">
<ul>
<ul>
<ul>
<ul><b><font size="2">"Clay, Bruce" <bclay@ball.com></font></b><font size="2"> </font><br>
<font size="2">Sent by: gdal-dev-bounces@lists.osgeo.org</font>
<p><font size="2">11/18/2009 11:09 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width="60%">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:3__=0ABBFCE1DFF583498f9e8a93df938690@fws.gov" border="0" alt=""><br>
<div align="right"><font size="2">To</font></div></td><td width="100%"><img width="1" height="1" src="cid:3__=0ABBFCE1DFF583498f9e8a93df938690@fws.gov" border="0" alt=""><br>
<font size="2"><gdal-dev@lists.osgeo.org></font></td></tr>
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:3__=0ABBFCE1DFF583498f9e8a93df938690@fws.gov" border="0" alt=""><br>
<div align="right"><font size="2">cc</font></div></td><td width="100%"><img width="1" height="1" src="cid:3__=0ABBFCE1DFF583498f9e8a93df938690@fws.gov" border="0" alt=""><br>
</td></tr>
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:3__=0ABBFCE1DFF583498f9e8a93df938690@fws.gov" border="0" alt=""><br>
<div align="right"><font size="2">Subject</font></div></td><td width="100%"><img width="1" height="1" src="cid:3__=0ABBFCE1DFF583498f9e8a93df938690@fws.gov" border="0" alt=""><br>
<font size="2">[gdal-dev] tab delimited to shapefile</font></td></tr>
</table>
<table border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="58"><img width="1" height="1" src="cid:3__=0ABBFCE1DFF583498f9e8a93df938690@fws.gov" border="0" alt=""></td><td width="336"><img width="1" height="1" src="cid:3__=0ABBFCE1DFF583498f9e8a93df938690@fws.gov" border="0" alt=""></td></tr>
</table>
</td></tr>
</table>
<br>
<font face="Arial">Is there any way to use ogr2ogr to convert tab-delimited data such as the geoname dot org files into shapefiles short of converting all tabs to commas?</font><br>
<font face="Arial"> </font><br>
<font face="Arial">I created a VRT file that works with CSV files but I can not find any way to convert tab-delimited data.</font><br>
<font face="Arial"> </font><br>
<font face="Arial">Bruce</font><br>
<font face="Arial"> </font>
<p><tt><font size="4"><br>
<br>
This message and any enclosures are intended only for the addressee. Please <br>
notify the sender by email if you are not the intended recipient. If you are <br>
not the intended recipient, you may not use, copy, disclose, or distribute this <br>
message or its contents or enclosures to any other person and any such actions <br>
may be unlawful. Ball reserves the right to monitor and review all messages <br>
and enclosures sent to or from this email address.</font></tt><tt>_______________________________________________<br>
gdal-dev mailing list<br>
gdal-dev@lists.osgeo.org<br>
</tt><tt><a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a></tt>
<p></body></html>