[Er...] Posted March 3, 2022 Share Posted March 3, 2022 I have an engineering request to combine .chr data in Excel. What I need to do is add time and date to .chr under group1 group2 so I can sort the data. Or is there another way? Link to comment Share on other sites More sharing options...
[He...] Posted March 3, 2022 Share Posted March 3, 2022 Group1 - group10 is occupied with the group hierarchy in characteristics list so I don't think you can use that. But you can easily create new columns with PCM command generateTableColumn() Syntax: generateTableColumn(column ID,function name) You need to create a function that outputs the date and another that outputs the time if you want it separate columns. A function can have many lines and calculations so you are not limited to what you can do in a single line. Example. Insert into presettings of the program or in external PCM-file. This should generate a column with header Date and the the string that you specify in the DateCustom variable. Do the same for Time. defineFunctionStart("Current date") DateCustom = date() //Here you can play around and specify your own date format. Since I'm Swedish I fancy the ISO-standard version YYYY-MM-DD but if you are American I guess you want all the numbers at random with some random separators in there like DM/YM\YD\YY ;) defineFunctionEnd("DateCustom") generateTableColumn("Date","Current date") Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in