Scilab Home page | Wiki | Bug tracker | Forge | Mailing list archives | ATOMS | File exchange
Please login or create an account
Change language to: English - Français - Português - 日本語 -
Справка Scilab >> Электронная таблица > csvTextScan

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 [] and conversion is set to string, 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

ВерсияОписание
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.
Scilab Enterprises
Copyright (c) 2011-2017 (Scilab Enterprises)
Copyright (c) 1989-2012 (INRIA)
Copyright (c) 1989-2007 (ENPC)
with contributors
Last updated:
Tue Feb 14 15:13:37 CET 2017