Delimited with (*)

[acorbally]

I have a file delimited with (*) I want to import or append the data from the text file into a foxpro database. I see plenty of ways how to do it but they require types I am not using. Any thoughts?

 

[rgbean]

FPD/W 2.x is a bit limited when using the DELIMITED clause. If you have a file (aa.txt) like this:
1234,*ABCDE*
7890,*abcde*

And then run this code:

create cursor testtbl (Mynum N(5), Mystr C(10))
append from aa.txt delimited with *
browse

Then you get a proper import. However, usually people think in terms of the file looking like:
1234*ABCDE*another one*
7890*abcde*some data*

Unfortunately that's not what FoxPro expects.

VFP added another syntax:

append from aa.txt DELIMITED WITH CHARACTER *
BROWSE

And this works as you'd expect. However to get this, you'll need to upgrade to VFP!

Rick

 

[acorbally]

Unfortunately the delimited characters I am using are exacly (*) not just *. I think FoxPro is thinking it is a function. Any thoughts on a work around?

 

[DSummZZZ]

You could try opening the file in a text editor and doing a global replace of the *'s with a tab character, then use Rick's code to import it.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm