I am using Foxpro ver 5.0a. I am a novice who has done some manipulation of a program file created by someone else. Here is the code below I have that imports a tsv file into a table. When the tsv file has a comma in it then number after comma is ignored. For example, price is is $1,099.98 in the tsv file but the foxpro populates my wwl table with 1.00 in the price field because of the comma. I have been using the progam sucessfully for a period of time without a hitch only when sales price is over $999.99.
Anyway to get around the problem with the comma without manipulating the tsv file beforehand?
APPEND FROM wwlimport.tsv TYPE DELIMITED with tab