Multi-valued delimiter with .net C #

Question

When we use C # with the Universe database, multi values ​​come from the Universe database as comma-separated values ​​to the programming site. Typically, in Basic Basic programming, they stand out as distinguished values ​​of ^ 252 or ^ 253. Therefore, we can easily share the multi value with value separators, because people do not use ^ 252 or ^ 253 in ordinary data inputs.

But in C #, when we select multiple values ​​from the Universe database, they are highlighted with a comma. If data with multiple values ​​actually contains a comma, we cannot use the comma (,) value as a value separator. Because this will split the data with multiple values ​​in the wrong position.

For example, if data with multiple values:

01 Although we will do , Tom will go there, I will go down

The multivalued value for the above entry is separated by a comma in .net programming. But the first value (in bold) actually contains a comma after "Although."

We are faced with the problem of using the C # Split function to separate data and get individual values. Could you tell us how we can overcome this in C # orVB.net programming using the Universe database and get individual sub values ​​/ values ​​?.

Thanks.

Answer 1

Common field separators require exactly what you describe. If you use "you will also need to decide what to do when your data inside the field also contains" in it ".

When you find a good field separator (one with a small fingerprint in the memory and your data is unlikely to contain). You can create a regular expression to capture data from each field.

Like others, some code snippets or samples will mean that the answers are more accurate and useful.

In any case, can you return data to a certain type, for example, MS DataTable or your own structure? A list where Row is the type you create to store all the possible fields in your specific data model?