Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eddie Ruiz
  Where is Eddie Ruiz?
 Hawthorne
 United States
 Eddie Ruiz
 Tags
Subject: extracting data
Thread ID: 393937 Message ID: 393937 # Views: 56 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, December 26, 2013 6:05:37 PM         
   


Hello I need some help, Im using the following code to extract data from a dbf to an excel file

LdFrom=date(2013,01,01)
LdTo=date(2013,12,24)
COPY FIELDS 1.code, 2.name, 3.nodate, 4.nnum, 5.knum, 6.npaid to c:\documents\test.xls type xl5 for BETWEEN(nodate, ldfrom, ldto) and (4.nnum >= "0")

The problem that i have is that the 4.nnum contains data numbers and letters, I only want to be able to export only numbers, if this helps there's 7 digits in 4.nnum. In my code above i was trying to export data where 4.nnum >= "0" to try to export only the numbers but it didn't work.

Thanks in advanced for the help.

ENTIRE THREAD

extracting data Posted by Eddie Ruiz @ 12/26/2013 6:05:37 PM
RE: extracting data Posted by Stefan Wuebbe @ 12/26/2013 7:11:01 PM
RE: extracting data Posted by Eddie Ruiz @ 12/26/2013 8:10:37 PM
RE: extracting data Posted by Stefan Wuebbe @ 12/26/2013 9:10:01 PM