I have a formatting problem with data coming via a LEI from ORACLE.Within the ORACLE field names written like this:
Meier, G.; Schulze, A.
In the Multiple value field within the Notes Form which receives the field data, I set up the properties like this:
Separate values when user enters semicolon
Dispaly separate value with semicolon
But the result is:
Meier;G.;Schulze; A.
What is wrong?
Thank you for your help in advance
Leini
Subject: Multiple values formatting problen
Leini, I would try two approaches. First, I would try all combinations of “Display separate values with” and “Separate values when user enters”, usually New Line and New Line erase all doubt about characters and notes is pretty good about knowing that a semicolon is a new line. If none of the cominations work, then the comma (although you told it not to) is still being seen as a multi-value separator. Try manipulating the returned value from oracle by replacing the comma with a space. This way “Meier, G” would be returned “Meier G” and so on.
Give those a shot.
Subject: Multiple values formatting problen
Leini, I would try two approaches. First, I would try all combinations of “Display separate values with” and “Separate values when user enters”, usually New Line and New Line erase all doubt about characters and notes is pretty good about knowing that a semicolon is a new line. If none of the cominations work, then the comma (although you told it not to) is still being seen as a multi-value separator. Try manipulating the returned value from oracle by replacing the comma with a space. This way “Meier, G” would be returned “Meier G” and so on.
Give those a shot.