Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ampersand and STRTRAN()
Message
De
05/09/2008 23:24:24
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Ampersand and STRTRAN()
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01345308
Message ID:
01345308
Vues:
51
UPDATE: Damn. I hate when I do all that work to post something and then find out it's something entirely unrelated. Nevermind.

I know for a fact that there is only 1 occurrence of '&' in the TextRequestMessage variable, but when I strip it out, my message fails. I'm sure it's because of the ampersand, but I need to strip it out. It looks like it does strip it, but then it causes the message to fail. If I manually remove that one ampersand, then the message goes through fine. Where I'm trying to strip it out is in this string:
SUNSHINE SPINE & PAIN PA OP
This is the TextRequestMessage variable before the STRTRAN():
ISA:00:          :00:          :ZZ:041577         :ZZ:MCKESSON_TSH   :051013:0132:U:00401:000000111:0:P:;~
GS:HS::ZZCERT:20080905:013205:11:X:004010X092~
ST:270:601864~
BHT:0022:13:0069701:20080905:013205~
HL:1::20:1~
NM1:PR:2:O/P MOLINA HEALTHCARE MICHIGAN:::::PI:ZZCERT~
HL:2:1:21:1~
NM1:1P:2:SUNSHINE SPINE & PAIN PA OP:::::XX:~
HL:3:2:22:0~
NM1:IL:1:ROSSI:ZIPPORAH::::MI:PRVINTG002~
REF:SY:001008961~
N4:Grand Rapids:FL:49507~
DMG:D8:19411210:F~
DTP:472:RD8:20080905-20080905~
EQ:30~
SE:14:601864~
GE:1:11~
IEA:1:000000111~
This is the TextRequestMessage variable after the STRTRAN():
ISA:00:          :00:          :ZZ:041577         :ZZ:MCKESSON_TSH   :051013:0132:U:00401:000000111:0:P:;~
GS:HS::ZZCERT:20080905:013205:11:X:004010X092~
ST:270:601864~
BHT:0022:13:0069701:20080905:013205~
HL:1::20:1~
NM1:PR:2:O/P MOLINA HEALTHCARE MICHIGAN:::::PI:ZZCERT~
HL:2:1:21:1~
NM1:1P:2:SUNSHINE SPINE  PAIN PA OP:::::XX:~
HL:3:2:22:0~
NM1:IL:1:ROSSI:ZIPPORAH::::MI:PRVINTG002~
REF:SY:001008961~
N4:Grand Rapids:FL:49507~
DMG:D8:19411210:F~
DTP:472:RD8:20080905-20080905~
EQ:30~
SE:14:601864~
GE:1:11~
IEA:1:000000111~
For all you health care fanatics, it's test data, so no HIPAA rules were violated.
Répondre
Fil
Voir

Click here to load this message in the networking platform