topic Re: Robot 2018 - CSV file on Results for Plates in Robot Structural Analysis Forum

(API) Robot 2018 - CSV file on Results for Plates

Anonymous — Wed, 31 May 2017 09:50:08 GMT

Hi,

I am starting to use Robot 2018 and I notice that the conversion to CSV file from the table of "Results for Plates" is not following the same format as in Robot 2015. The character that is doing the separation between "Panel", "Node" and "Case" is "/" instead of ";".

This is a beat boring, because when I need to open the csv file in excel, the numbers of the panel and the node appear at the same column and cell.

Is there any way in Robot 2018 to continue to export this table in the same format as in Robot 2015?

Thank you.

Kind regards,

David

Re: Robot 2018 - CSV file on Results for Plates

Rafal.Gaweda — Wed, 17 May 2017 12:52:17 GMT

Hi @Anonymous

My advice is to open csv file in Notepad and replace / by ; and save the file

Re: Robot 2018 - CSV file on Results for Plates

Anonymous — Wed, 17 May 2017 13:18:58 GMT

Thank you for your reply, but a bit tricky for a CSV file which goal is to create a text file with strings separated by "," or ";"!!

If it was working fine in the previous versions, why it has changed?!

Regards,

David

Re: Robot 2018 - CSV file on Results for Plates

Rafal.Gaweda — Wed, 17 May 2017 13:54:38 GMT

Hi @Anonymous

I guess it was changed to have exactly the same table look like in Robot. First column contains "/" sign in Robot.

Re: Robot 2018 - CSV file on Results for Plates

Anonymous — Sat, 20 May 2017 15:32:05 GMT

hi,

Worse than the change made is the autodesk support justification, totally unacceptable.

NMV

Re: Robot 2018 - CSV file on Results for Plates

Artur.Kosakowski — Fri, 26 May 2017 13:02:26 GMT

Hi @Anonymous

I'd say it is hard to understand why Microsoft allows you to replace /space with another character in e.g. Notepad but doesn't allow you to set it as a delimiter in Excel

Anyway the solution proposed by Rafal is not that hard to execute:

If you find your post answered press the Accept as Solution button please. This will help other users to find solutions much faster. Thank you.

Re: Robot 2018 - CSV file on Results for Plates

StefanoPasquini6790 — Mon, 29 May 2017 22:55:36 GMT

If I'm not wrong, in excel you can set more than one limiter in the csv data importing, so you can use two or three of them, including an "user defined one" . I do this everyday.

Re: Robot 2018 - CSV file on Results for Plates

Artur.Kosakowski — Tue, 30 May 2017 08:52:10 GMT

HI Stefano,

The only issue is that if you set / then you will 'corrupt' units as well . This is why I introduced notepad in the process as I wasn't able to set /space as the 'used defined one' in Excel

Re: Robot 2018 - CSV file on Results for Plates

Anonymous — Tue, 30 May 2017 11:44:03 GMT

Hi,

I keep my opinion that RSA 2018 has a "minor bug" in the conversion to a CSV file that should be corrected in the next service pack, because it doesn't make any sense spend time in opening the csv in the notepad then replace "/" by ";" except in the units, save the file and then open it in Excel, even more when this option of convert to CSV was working fine and correctly since Robot 17 (2002)!!

Regards,

David

Re: Robot 2018 - CSV file on Results for Plates

Artur.Kosakowski — Tue, 30 May 2017 12:59:55 GMT

Hi @Anonymous

I have forwarded your request to the development team. I hope that for a moment the workaround I provided will be acceptable for you.

If you find your post answered press the Accept as Solution button please. This will help other users to find solutions much faster. Thank you.

Re: Robot 2018 - CSV file on Results for Plates

Rafal.Gaweda — Wed, 31 May 2017 09:10:49 GMT

Hi All

I have prepared (in fact I have modified existing on forum) macro for dumping active table with all tabs to csv \ txt replacing correctly "/" and keeping units.

Macro attached.

Feel free to modify it if needed.

Sometimes it may not run on Plate and Shells Results table \ Envelope tab