Causal table export: Please switch from comma delimited to tab delimited
Posted: Wed Dec 04, 2024 9:23 am
Currently, when hitting the copy-button in the causal table tool, the result in the clip-board is comma delimited text.
That makes using it difficult, because variable names often also contain commas, when qualitative models are built in Group Model Building sessions.
That means it needs workarounds to avoid these commas for being mistaken for column breaks when importing into spreadsheets (e.g. excel). My workaround: find+replace commas with following space ", " with semicolons with following space "; " then convert the rest of the commas "," to tabstops (e.g. in notepad++ with extended search mode on) and then convert semicolons back to commas and then import.
You could make this workaround unnecessary, by changing the export from Vensim to tab-delimited.
Thanks for considering!
That makes using it difficult, because variable names often also contain commas, when qualitative models are built in Group Model Building sessions.
That means it needs workarounds to avoid these commas for being mistaken for column breaks when importing into spreadsheets (e.g. excel). My workaround: find+replace commas with following space ", " with semicolons with following space "; " then convert the rest of the commas "," to tabstops (e.g. in notepad++ with extended search mode on) and then convert semicolons back to commas and then import.
You could make this workaround unnecessary, by changing the export from Vensim to tab-delimited.
Thanks for considering!