Excel Import contains "less than" symbol < , trims the rest of the value
Has anybody seen the following issue and/or can suggest a workaround? Thanks.
When attempting to bulk upload new assets to a codelist domain, we sometimes, but not always, lose the right hand side of any text for attributes which contain the less than (<) symbol. (The greater than symbol is fine!)
name: Example_LessThan_AB
synonym: Example<AB
synonym value imported in Collibra: Example
The following 4 values (attributes) were affected (after import everything after the “<” sign is missing):
HOWEVER these similar values were not affected and uploaded in full:
EXAMPLE<1
EXAMPLE><
EXAMPLE>AB2
leehayes
Posted 5 years ago · Edited 2 years ago·Last reply 5 years ago
3 comments
constancebarton
·5 years ago · EditedI have experienced similar issues with special characters. Sometimes it helps to use the corresponding HTML code value. In the case of the less than sign ("<") the HTML value is <
constancebarton
·5 years ago · EditedI have experienced similar issues with special characters. Sometimes it helps to use the corresponding HTML code value. In the case of the less than sign ("<") the HTML value is <
leehayes
OP5 years ago · EditedThanks - I think that is good advice generally although of less value when we are trying to encourage data citizens across the organisation to be able to upload and manage their own catalogs and glossaries.
In this case, it looks like the issue was related to the attribute being “rich text” rather than “plain text”.
I find it frustrating that this is an immutable property, meaning we will need to book a new plain text attribute and transfer values across.
Also, I don’t understand why rich text was chosen as the default? Surely rich text is the exception, rather than the rule? Even if not, why can DGC UI not enforce that the user selects plain or rich text rather than simply defaulting?