{"id":3127,"date":"2019-03-25T17:42:49","date_gmt":"2019-03-25T20:42:49","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/automation-in-code-generation-lesson-3-changing-a-string-into-a-vector\/"},"modified":"2020-04-08T14:06:41","modified_gmt":"2020-04-08T17:06:41","slug":"automation-in-code-generation-lesson-3-changing-a-string-into-a-vector","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-3-changing-a-string-into-a-vector\/","title":{"rendered":"Automation in code generation: Lesson 3 – Changing a string into a vector."},"content":{"rendered":"
\n

For the purposes of this article, we will consider option 1 from Lesson 2 is being used.<\/p>\n

After the .csv<\/b> file has been read, we are left with a string that is equivalent to the contents of the whole table. Rows are separated by line breaks, and columns by either a semicolon (;) or a comma (,), depending on Windows country and language settings.<\/p>\n

Example:<\/p>\n

SE1;5201;Driver1;Tag1
\nSE1;5202;Driver1;Tag2
\nSE1;5203;Driver1;Tag3
\nSE2;5204;Driver2;Tag1
\nSE2;5205;Driver2;Tag2
\nSE2;5206;Driver2;Tag3
\nSE3;5207;Driver3;Tag1
\nSE3;5208;Driver3;Tag2
\nSE3;5209;Driver3;Tag3<\/span><\/p>\n

To separate data individually (cell by cell), you must turn the string into a vector. This can be done via vbScript’s Split <\/i>method, which has one mandatory parameter and three optional ones:<\/p>\n

Split(expression[, delimiter[, count[, compare]]])<\/span><\/p>\n

The expression <\/span>parameter must be replaced by the desired string. The delimiter <\/span>parameter indicates which separator must be used. The other two parameters are not relevant to this case, and must therefore be left blank.<\/p>\n

Usage example:<\/p>\n

auxVetor = Split(auxString, vbNewLine)<\/span><\/p>\n

In this example, the auxString <\/span>variable is the string equivalent to the spreadsheet’s content, and vbNewLine <\/span>constant is the line break character.<\/p>\n

Now, auxVetor <\/span>variable contains a vector with as many positions in it as the number of rows in the table:<\/p>\n

auxVetor(0) contains the string \"SE1;5201;Driver1;Tag1\"\r\nauxVetor(1) contains the string \"SE1;5202;Driver1;Tag2\"\r\nauxVetor(2) contains the string \"SE1;5203;Driver1;Tag3\"<\/span><\/pre>\n
and so on.<\/p>\n
The next step is to separate each row’s column. To do so, you must scan all positions of the vector, and once again execute Split <\/i>method, only this time passing a semicolon (;) as parameter.<\/p>\n
Example:<\/p>\n
'separates the string into a row vector <\/span>\r\nauxVetor = split(auxString, vbNewline)<\/span>\r\n\r\n'for each row <\/span>\r\nfor i=0 to Ubound(auxVetor)\r\n\r\n'separates the row into a cell vector<\/span>\r\nvetorColunas = split(auxVetor(i), \";\")\r\n\r\n'saves the cells in script variables<\/span>\r\nauxSE = vectorColumns(0)\r\nauxEquip = vectorColumns(1)\r\nauxDriver = vectorColumns(2)\r\nauxTag = vectorColumns(3)\r\n\r\n\u00a0\u00a0 'here goes the rest of the automated script, which will use the data\r\n'organized above to create\/set up the desired objects\r\n'...\r\n'...\r\n'... <\/span>\r\n\r\nnext\r\n\r\n<\/pre>\n
NOTE<\/b>: The template to be used in the spreadsheet (which data will be saved, and in which order it will happen) can vary according to the user. Therefore, the sample script above will vary according to the defined template.<\/p>\n<\/div>\n
Related articles<\/h3>\n
\n