Would y'all be able to answer me this, in a multi-line DB_MEMO field, when we
insert a LF, via [CTRL-Enter], what is the ASCII value of that input?
Is it 10d==0Ah?
Do other front-ends that allow this type of "intra-field" formatting use the LF
character also?
I ask because I was really pullin' my hair out tryin' to figure out why some
extracted data wouldn't LOAD||GATEWAY properly. As I searched my off-line
storage (okay, my wife might tell you that my brain is off-line the majority of
the day) I recalled the issue of embedded quotes. Well, there were LOTS of
those. So, via WordPerfect (not necessarily a contrarian, but I still think
it's a better product than Word and, unlike Word, once I learn one version I
pretty much know all of 'em, but I digress ...), I searched and replaced all
"[HRt]"=>|[HRt]| and ","=>|,|, saving it as ASCII Text. Essentially, I
replaced all double-quote (") delimiters with the Pipe (|) character. Now, to
make this work without having [SRt] embedded - some of the fields are brief
narratives, up to 300 characters - I reformatted the page to a BIG one,
Landscape, Minimal Margins, and Prestige Elite, 4pt, then "Save As" ASCII
Unformatted Text.
Then while scanning through the document, looking for any records long enough
that they triggered a [SRt], I started finding [HRt] characters embedded within
the narrative field of some records. It didn't make sense until I thought
about researchers who might want to "format" their text within the input field
on a form. So, I used a HEX viewer to see what the value was and these were
all 0Ah/10d, which is (I think) the LF character.
Thus, my questions.
Thanks,
Steve in Memphis
J. Stephen Wills
Program Manager, Research Informatics
Office of the Vice Chancellor for Research
University of Tennessee Health Science Center
62 S. Dunlap, Suite 400
Memphis, TN 38163
Office: 901-448-2389
FAX : 901-448-7133
