I built a little macro to find and replace return characters in a certain field from a tab delimited text file exported from access. It replaces the return with a formatting character, and once the file is brought into Director it is converted back. Since some of our data is copy/pasted into access from Word we end up with some bad returns in other fields, so replacing all returns can cause problems.
Since I am a novice programmer, I figure I am probably not doing this as elegantly as possible, and I thought perhaps someone might suggest how I can clean this up a bit.
while (At_EOF == 0) {
Search("|009",COUNT,24)
Search("|009",ADVANCE)
While (Cur_Char != 9) {
if (Cur_Char == 13) {
Replace ("|013","|202",NOERR)
Replace ("|010","",NOERR)
}
Char(1)
}
Line(1)
}
|
|