ODBiC Discussion Board


RE: Import Question, Tim Logan, 10-06-2003

Workaround

by Tim Logan, October 23, 2003 21:29

In case anybody else needs this, here's how I got around this problem.

<!--NOTE Get rid of work file if it exists --> <!--exec del NewFile.txt-->

<!--NOTE CONVERT FROM TAB DELIMITED TO | DELIMITED --> <!--import linedata from TabDelim.txt--> <!--if $ImportRow$ > 1 --> <!--note Row 1 is field names--> <!--output NewFile.txt APPEND--> $repl($linedata$, " "="|") <!--output--> <!--endif--> <!--endimport-->

<!--NOTE NOW IMPORT THE DATA --> <!--import delimiter="|", Field1, Field2, Field3, Field4, Field5 from NewFile.txt -->

Now do whatever needs to be done with the data.

<!--endimport-->



Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.