Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Read Excel CSV file
Message
De
15/03/2007 04:34:45
 
 
À
15/03/2007 03:26:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01203878
Message ID:
01203883
Vues:
14
Hi Yochanan,

I don't have any solution to your problem, but I have two functions to reverse text, maybe you can use one of them as a workaround.
Function Backwards && reverses the text so "ABC   " becomes "   CBA"
  Lparameters lcIndata
  Local lnCounter,lcReturn
  lcReturn=''
  For lnCounter=Len(lcIndata) To 1 Step -1
    lcReturn = lcReturn + Substr(lcIndata,lnCounter,1)
  Endfor
Return lcReturn

Function Backward1 && reverses and left justifies the text so "ABC   " becomes "CBA   "
  Lparameters lcIndata
  Local lnCounter,lcReturn
  lcReturn=''
  For lnCounter=Len(Trim(lcIndata)) To 1 Step -1
    lcReturn = lcReturn + Substr(lcIndata,lnCounter,1)
  Endfor
Return Padr(lcReturn,Len(lcIndata))
>Hi all,
>I must read data from Excel (Hebrew) file CSV. Usually I rename CSV file to .txt and read as ASCII file. But in Hebrew case it does not possible, right/left problem exists.
>By which way can I read CSV Excel file right to VFP?
>
>Thanks.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform