Thanks for all of the advice. I might not have been clear - my program doesn't hang, it finishes, we just lose data as you say - any data from the symbol onward do not get written.
So, I could compare every character of the field to a list of acceptable characters (perhaps with an IN clause), and if it is not in the list, then eliminate it?
Or, maybe create a table with all acceptable characters, and compare against that. Then, if we needed to add more characters, we would just need to modify the table, and not the code.
- ProIV Resource Centre
- → Viewing Profile: Posts: anortonbk
Community Stats
- Group Members
- Active Posts 8
- Profile Views 3,465
- Member Title Newbie
- Age Age Unknown
- Birthday Birthday Unknown
-
Gender
Not Telling
Previous Fields
-
Year Started ProIV
Not Specified
-
Highest ProIV Version Used
Not Specified
Posts I've Made
In Topic: Handling funky characters
28 March 2007 - 04:12 PM
In Topic: Handling funky characters
27 March 2007 - 09:29 PM
I mean that as my pro IV superlayer program reads the text field, if there is an ASCII symbol in the field, my program doesn't process anything beyond that point.
The other system passes me one huge field, containing 26 fields delimited by pipes, my program reads the big field, then writes each individual field to a second table.
It is supposed to read the pipe delimited fields, then, based on position, and the start and end pipe, take the field and write it to a field in the second table. When it hits one of these characters, none of the fields from that point forward get written to the second table.
So, I need to know how to strip these ASCII characters out of the text, or how to ignore them.
The other system passes me one huge field, containing 26 fields delimited by pipes, my program reads the big field, then writes each individual field to a second table.
It is supposed to read the pipe delimited fields, then, based on position, and the start and end pipe, take the field and write it to a field in the second table. When it hits one of these characters, none of the fields from that point forward get written to the second table.
So, I need to know how to strip these ASCII characters out of the text, or how to ignore them.
In Topic: Stuck in a loop
19 March 2007 - 09:34 PM
Thanks, I actually ended up getting this all worked out fine, after a few UMSGs, and is working great.
Thanks!!
Thanks!!
In Topic: Stuck in a loop
17 March 2007 - 04:01 PM
In line 7, I actually had:
IF $$FIELD(#X,#X) = ' ' THEN
IF $$FIELD(#X,#X) = ' ' THEN
- ProIV Resource Centre
- → Viewing Profile: Posts: anortonbk
- Privacy Policy