Problem with text file 2

[EKC]

Hi,
My select statement is:
Select field1,filed2 from Table1 to file Text1.txt

I have problem to parse this text file corectly in Excel sheet when field has more the one word with spaces, the whole thing is messed up then.(I use space as delimiter)
Is there any function that takes this spaces from (If field value is Ford Taurus 97 to be FordTaurus97) so I can include it in my select statement or any other idea will be welcome
Thanks in advance,
Lyn

 

[dgrewe]

1. MyMemVar = strtran(myMemVar , " ", "&quot

2. delimit the txt file with a comma and then import into Excel (Select field1,filed2 from Table1 to file Text1.txt delimited)

3. Use ODBC, ActiveX or Automation to place the infor directly into the Excel spreadsheet cells.

David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644

 

[jimstarr]

I agree with dgrewe's solution using the STRTRAN function.


You could simply change your select statement to be:

SELECT STRTRAN(field1, " ", "&quot, STRTRAN(field2, " ", "&quot etc.


Jim

 

[jonscott8]

Lyn,

Have you researched the COPY TO function using the TYPE XLS argument? For example,

Select field1,filed2 from Table1 Into Cursor Temp
Copy To C:\MyFile.xls TYPE XLS Jon Hawkins
jonscott8@yahoo.com

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed