Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Extracting Numeric Data From Text String
Message
De
20/03/2013 05:36:55
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Extracting Numeric Data From Text String
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01568837
Message ID:
01568837
Vues:
72
Suppose I want to Extract 478 from the given string. I am using the following code
lcStr="F5 B (Total Charges)390 478 w"
lnPOS = At("Total Charges",lcStr)
WAIT WINDOW SUBSTR(lcStr,lnpos+18,3) && Displays 478
The same gives me the required Value.

However, in certain cases I get string as "F5 B (Total Chg)390 478 w" insetead of "F5 B (Total Charges)390 478 w", in another instace I get "F5 B (Total Chrgs)390 478 w".

I need 478 from the above irrespective of whether it is Total Charges/Total Chrg/Total chg etc.

Similarly, I have In some Cases "Service Tax" and in other string as "Service Tax New"

Kinldy Guide How to Extract the required value with accuracy in such cases

Regards
Harsh
Harsh
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform