Conversion of Multivalued Fields (AREV Specific)
At 24 MAR 1999 12:32:00PM Victor Engel wrote:
OCONV has the ability to apply a conversion to an entire set of values delimited by, say, @VM. I have run into a problem, however, where this does not work as expected. We have a historical date field, some of whose values have spaces:
² ² ² ² ² ² ² ² ² ²² ² ² ² ²9500² ²² ²8968These spaces have the annoying consequence of hosing the entire field when passed through the standard date conversion. An obvious solution is to apply the conversion only to each individual value, but then we lose the speed and grace of the other method. Any comments/suggestions?
P.S. Don't ask me how that invalid data got there. It dates to before my time here.
Victor
At 24 MAR 1999 01:32PM Matt Sorrell wrote:
Victor,
Do a one time run through of the system and blow them out?
Or at runtime before doing the OCONV do a:
SWAP " " WITH "" IN DATE.ARRAY
Then do the OCONV on DATE.ARRAY.
Matt Sorrell
msorrell@movgal.com
At 24 MAR 1999 01:38PM Bryan deSilva wrote:
Victor:
Sounds like your audit groups (HR-1 right?) were at one time messed up or someone has added some code that didn't work. The spaces are truly a no no. If this is part of a stack, I have a stack clean tool that will fix this problem and many others. If something else, write yourself a little tools that reads the mv and when it finds an entry with a space, swap it with a null.
Bryan deSilva
Improvisations
At 24 MAR 1999 11:16PM Bizsoft Corp wrote:
We create custom exporting utilities for getting info out of AREV/OI, directly, without the software. Just the data is required.