Hi everyone!
I want to write results of a study to a text file and process the data with Excel. So what I try to produce is a file which only contains the required data which I can then copy/paste. My code so far:
AnyOutputFile OutputFile1 = {
FileName = Main.ModelSetup.C3DFileData.NameOfFile+"-JointTorueOutput.txt";
SepSign = " ";
Header = {
TitleSectionOnOff = Off;
ConstSectionOnOff = Off;
VarSectionOnOff = Off;
ColumnNamesOnOff = Off;
LinePrefix = "";
};
AnyVector RelAnkle= {..AnkleTorque.RelRightAnkleFlexT};
//add more here
};
Is there a way to define TAB as separator sign?
I tried by just putting a tab in the SepSign-line but that is written as two spaces. Thus when copy/pasting the results into Excel columns are not separated but all data is written in the A-column.
The point is that I could of course define any separator and tell Excel during import how the data is separated. However, I’d like to get around the tedious import-dialogue as I need to process many files. And tab separation is the only way (as far as I know) Excel interprets correctly when using copy/paste.
Best regards
Florian