Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ampersand and STRTRAN()
Message
From
05/09/2008 23:24:24
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Ampersand and STRTRAN()
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01345308
Message ID:
01345308
Views:
50
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.
Reply
Map
View

Click here to load this message in the networking platform