Please note that the recommended version of Scilab is 2025.0.0. This page might be outdated.
See the recommended documentation of this function
csvTextScan
Convert a comma-separated value to a matrix
Syntax
A = csvTextScan(M) A = csvTextScan(M, separator) A = csvTextScan(M, separator, decimal) A = csvTextScan(M, separator, decimal, conversion) A = csvTextScan(M, separator, decimal, conversion, range)
Parameters
- M
a m-by-1 or 1-by-m matrix of strings.
- separator
a 1-by-1 matrix of strings, the column separator mark.
- decimal
a 1-by-1 matrix of strings, the decimal mark. The available values are "." or ",".
If
decimal
is different of[]
andconversion
is set tostring
, the decimal conversion will be done.- conversion
a 1-by-1 matrix of strings, the type of the output
A
. Available values are "string" or "double".- range
a 1-by-4 or 4-by-1 matrix of floating point integers, the range of rows and columns which must be read (default range=[], meaning that all the rows and columns). Specify range using the format
[R1 C1 R2 C2]
where (R1,C1) is the upper left corner of the data to be read and (R2,C2) is the lower right corner.- A
a m-by-n matrix of strings or double.
Description
Given an ascii file with delimited fields, this function returns the corresponding Scilab matrix of strings or doubles.
The csvTextScan
function has the same purpose as
csvRead
, except that csvTextScan
reads in a string, while csvRead
reads in a
file.
The default value of the optional input arguments are defined by the
csvDefault
function.
Any optional input argument equal to the empty matrix
[]
is set to its default value.
When input argument "conversion" is equal to "double", strings are converted as NaN.
Examples
// convert a csv string matrix to splitted string or double matrix A = ["1;3 + i"; "Nan;-Inf"] B = csvTextScan(A,';') C = csvTextScan(A,';',[],'double') // // Configure the decimal mark. Atext = [ " 1,000000000D+00; 0,000000000D+00; 2,000000000D+02; Inf; 0,000000000D+00"; " 1,000000000D+00; 1,00000000D-300; 2,000000000D+02; Inf; 0,000000000D+00"; " 1,000000000D+00; 1,00000000D-200; 2,000000000D+02; 3,15000000D+300; 1,020000000D+02"; " 9,999999999D-01; 1,00000000D-100; 2,000000000D+02; 2,960000000D+02; 1,170000000D+02"; " 1,000000000D+00; Inf;-Inf; Nan; 0,000000000D+00" ]; csvTextScan( Atext , ";" , "," )
See also
History
Version | Description |
5.4.0 | Function introduced. Based on the 'csv_readwrite' module. |
5.4.1 | If decimal is different of [] and conversion is set to string , the decimal conversion will be done. |
Report an issue | ||
<< csvRead | Tableur | csvWrite >> |