Details of comma-delimited data
- Last UpdatedJul 16, 2024
- 1 minute read
Commas are used as delimiters to separate multiple values specified for GraphicRepeaterApp custom properties. A comma is always used as the data delimiter regardless of the regional setting of the computer.
The following table shows examples of comma-delimited strings and how the entered data is parsed.
|
Comma Delimited Strings |
Parsed Data |
|---|---|
|
10,"Hello There",30,"Second" |
10 "Hello There" 30 "Second" |
|
40,"Hello",50 , "World", 100 |
40 "Hello" "50" "World" "100" |
|
40,"Hello, How "are" you",50 ,"World",100
|
40 "Hello, How "are" you" 50 "World" 100 |
|
40,"Hello, How "are" you",50 "World",100 |
40 "Hello, How "are" you" 50 "World" 100 |
|
40,"Hello,,,,,Th"""ere"",50"Se"co"nd |
40 "Hello,,,,,Th"""ere" 50"Se"co"nd |
|
35,Obj.Attribute1,"Pump1 output,36,Obj.Attribute2 |
35 Obj.Attribute1 "Pump1 output,36,Obj.Attribute2 |
|
35,Obj.Attribute1,Tank2 Volume Attribute,",36,Obj.Attribute2 |
35 Obj.Attribute1 Tank2 Volume Attribute ",36,Obj.Attribute2 |
Data property values can be entered as free text, making data parsing more complex. The following rules are followed to parse a comma delimited string containing many quotation marks and commas.
-
If data starts without a quotation mark, the entered data is evaluated as a single value until a comma appears in the string.
-
If data starts with a quotation mark, the entered data is evaluated as a single value until the next quotation mark and comma (",) appears in the string.