A simple code how to read\/import a CSV file into an array (dyn_dyn_string).<\/p>\n
dyn_dyn_string result; Limitations: With oracle you can use external tables to access CSV files. After creating an external table it is possible to access the file by SQL:<\/p>\n CREATE DIRECTORY EXT_DIR AS '\/home\/oracle\/data';<\/p>\n -- Create table A simple code how to read\/import a CSV file into an array (dyn_dyn_string). main() { string content; fileToString(DATA_PATH+”\/csvtest.txt”, content); \/\/ read file into a string variable dyn_dyn_string result; dyn_string lines = strsplit(content, “\\n”); \/\/ split the string into lines for ( int i=1; i<=dynlen(lines); i++ ) { result[i]=strsplit(lines[i], “;”); \/\/ delimiter “;” } DebugTN(result); } … Continue reading WinCC OA read csv file…<\/span> main()
\n{
\n string content;
\n fileToString(DATA_PATH+\"\/csvtest.txt\", content); \/\/ read file into a string variable<\/p>\n
\n dyn_string lines = strsplit(content, \"\\n\"); \/\/ split the string into lines
\n for ( int i=1; i<=dynlen(lines); i++ ) {
\n result[i]=strsplit(lines[i], \";\"); \/\/ delimiter \";\"
\n }
\n DebugTN(result);
\n}
\n<\/code><\/p>\n
\n* Don’t do it in that way with very big files because it is read from the file into memory
\n* The delimiter “;” cannot be inside of a cell value<\/p>\nselect * from ext_tab<\/p>\n
\ncreate table ext_tab
\n(
\nCol1 VARCHAR2(30),
\nCol2 VARCHAR2(30),
\nCol3 VARCHAR2(30)
\n)
\norganization external
\n(
\ntype ORACLE_LOADER
\ndefault directory EXT_DIR
\naccess parameters
\n(
\nRECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY \";\"
\n)
\nlocation (EXT_DIR:csvtest.csv')
\n)
\nreject limit UNLIMITED;
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"