DriveWorks Solo 22

TableFromCsv

TableFromCsv

Creates a table from a CSV string.

Syntax

TableFromCsv( [Csv String])

Where:

Csv String is a string separated by commas that represents a table.

Examples

Use case for the TableFromCsv function

1. Add a Text Box control to a user form.
2. Change the MultiLine property of the Text Box control to True.
3. Go into Test Mode and enter some data into the Text Box control. For example:

   

4. Create a variable and build the rule:

   TableFromCsv(EnterCSVReturn)

   Where EnterCSV is the name of the Text Box control added in step 1 above.

5. The result of the variable (using the data above) will be:

   {"Name","Thread Pitch","Nominal Diameter","Head Shape","Available";"M4","0.7","4","Pan","Yes";"M5","0.8","5","Round","";"M6","1","6","Button","Yes";"M10","1.5","10","","Yes";"M24","","24","Round","No";"M50","4.5","50","Pan","No"}

   And if this variable is applied to the Items property of a Data Table control, on a user form, it will look like:

   

   The first line of data is treated as a header row.

   Subsequent new lines are treated as rows in the array.

   Each column is separated with a comma.

See also

How To: Work With Arrays