[PLUG] Awkward Field Separators

Rich Shepard rshepard at appl-ecosys.com
Tue May 13 16:12:51 UTC 2008


On Tue, 13 May 2008, Michael wrote:

> Is the intent to have the VALUES parameters reshuffled to fit another order?

   Yes.

> Perhaps your solution lies in viewing the problem from a different perspective.
>
> When I read the SQL I mentally rewrote it as:
>
>  INSERT INTO "Rules" (Quantity, Type, Location, Resource) VALUES
> ('Few','Inorganics','Aquifer','GroundWater');

   I considered modifying each row to include the field names, but thought
that awk would be the most parsimonious solution. Guess I can change that.

Thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863



More information about the PLUG mailing list