{"id":246913,"date":"2023-01-18T15:15:36","date_gmt":"2023-01-18T15:15:36","guid":{"rendered":"\/forum\/forums\/topic\/tread-command-reading-csv-files-containing-all-data\/"},"modified":"2023-01-18T15:15:36","modified_gmt":"2023-01-18T15:15:36","slug":"tread-command-reading-csv-files-containing-all-data","status":"closed","type":"topic","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/tread-command-reading-csv-files-containing-all-data\/","title":{"rendered":"*TREAD command, reading CSV-files containing all data."},"content":{"rendered":"

Hello,<\/p>\n

I’m facing some problems using the *TREAD command. My problem is that displaying my table with the *STATUS command, gives me one less column and row of data.<\/p>\n

I used the following code:<\/p>\n

\n
\/INQUIRE,filelines,LINES,my_file_path,CSV      ! Discover the number of lines in a text file<\/div>\n
numlines = filelines-skiplines                               ! numlines = filelines – skiplines (here: 1)<\/div>\n
*DEL, read_csv,,NOPR<\/div>\n
*DIM,   read_csv,TABLE,numlines-1,numcols-1    ! Create table array to hold data<\/div>\n
*TREAD, read_csv,fnames_input(1,1),CSV,,skiplines   ! Import data into table<\/div>\n
*STATUS, read_csv<\/div>\n
 <\/div>\n
I followed the instructions given here: <\/div>\n
https:\/\/simutechgroup.com\/using-tread-in-ansys-mechanical-apdl-to-read-external-data\/<\/div>\n
 <\/div>\n
Because as described, entering the actual number of rows and columns for the relevant data leads to an unintentional shift of data. <\/div>\n<\/div>\n

This is the content of the CSV in my_file_path:<\/p>\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n
Time<\/td>\nHeatflux1<\/td>\nHeatflux2<\/td>\nHeatflux3<\/td>\n<\/tr>\n
0<\/td>\n301<\/td>\n88<\/td>\n62<\/td>\n<\/tr>\n
60<\/td>\n226.8<\/td>\n89<\/td>\n62<\/td>\n<\/tr>\n
120<\/td>\n149<\/td>\n90<\/td>\n62<\/td>\n<\/tr>\n
180<\/td>\n73<\/td>\n91<\/td>\n62<\/td>\n<\/tr>\n
240<\/td>\n0<\/td>\n91<\/td>\n62<\/td>\n<\/tr>\n
300<\/td>\n0<\/td>\n90<\/td>\n62<\/td>\n<\/tr>\n
360<\/td>\n0<\/td>\n90<\/td>\n62<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

This is the output I get with the code described above:<\/p>\n

 LOCATION                VALUE
        1       1       1    226.800000     
        2       1       1    149.000000     
        3       1       1    73.0000000     
        4       1       1    0.00000000     
        5       1       1    0.00000000     
        6       1       1    0.00000000     
        1       2       1    89.0000000     
        2       2       1    90.0000000     
        3       2       1    91.0000000     
        4       2       1    91.0000000     
        5       2       1    90.0000000     
        6       2       1    90.0000000     
        1       3       1    62.0000000     
        2       3       1    62.0000000     
        3       3       1    62.0000000     
        4       3       1    62.0000000     
        5       3       1    62.0000000     
        6       3       1    62.0000000     <\/p>\n

Is there any way to get the first row and column included in my table without changing the csv-file?<\/p>\n

Thanks a lot in advance.<\/p>\n","protected":false},"template":"","class_list":["post-246913","topic","type-topic","status-closed","hentry","topic-tag-csv-1","topic-tag-ansys-mechanical","topic-tag-apdl","topic-tag-excel-2","topic-tag-excel-csv","topic-tag-table","topic-tag-tread"],"aioseo_notices":[],"acf":[],"custom_fields":[{"0":{"_bbp_subscription":["272932","18229","20905","170445"],"_bbp_author_ip":["96.7.74.173"]," _bbp_last_reply_id":["0"]," _bbp_likes_count":["0"],"_btv_view_count":["3320"],"_bbp_topic_status":["unanswered"],"_bbp_status":["publish"],"_bbp_topic_id":["246913"],"_bbp_forum_id":["27791"],"_bbp_engagement":["18229","20905","170445","272932"],"_bbp_voice_count":["4"],"_bbp_reply_count":["6"],"_bbp_last_reply_id":["247335"],"_bbp_last_active_id":["247335"],"_bbp_last_active_time":["2023-01-24 10:33:08"]},"test":"ermanno-mancaoutlook-de"}],"_links":{"self":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/246913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics"}],"about":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/246913\/revisions"}],"wp:attachment":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/media?parent=246913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}