Jump to content


anortonbk

Member Since 16 Mar 2007
Offline Last Active Jan 08 2008 10:35 PM
-----

Posts I've Made

In Topic: Handling funky characters

28 March 2007 - 04:12 PM

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.

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.

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!!

In Topic: Stuck in a loop

17 March 2007 - 04:01 PM

In line 7, I actually had:

IF $$FIELD(#X,#X) = ' ' THEN