Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Extracting Numeric Data From Text String
Message
De
20/03/2013 07:16:39
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
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:
01568845
Vues:
35
But sir, my value of lcstr would be extracted from file as lcstr=FIletostr(123.txt) and from there I have to Find "Total Charges" from other Junk of Data and get the requited Value. How , it will be Done ?



>>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
>
>
>lcStr="F5 B (Total Chrgs)390 478 w"
>? SUBSTR(lcStr, RAT(" ", lcStr,2)+1,3)
>lcStr="F5 B (Total Charges)390 478 w"
>? SUBSTR(lcStr, RAT(" ", lcStr,2)+1,3)
>
Harsh
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform