You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In my current use of Serial Studio I often port the csv to Excel for data manipulation. As a result I often find myself having to change all of the RX Time entries provided so that Excel detects them as valid datetime fields. The reason for this is that the RX Time data is presented as YYYY/MM/DD/ HH:mm:SS::ssssss, while Excel for example will only detect dates of format YYYY/MM/DD HH:mm:SS.ssssss (notice the missing slash after DD and the decimal point instead of :: separator between SS and ssssss)
It would be nice to have some ability to modify the format of the RX Time field in settings so that I can present the datetime in whatever format I like, with custom separators between year, month, date, hour, minute, second, and sub-second fields.
Currently I've basically been using manual Find and Replace to accomplish this; I understand that it's possible to code up a quick script to do this on my end, but I feel this would be a good quality of life improvement for most users.
The text was updated successfully, but these errors were encountered:
In my current use of Serial Studio I often port the csv to Excel for data manipulation. As a result I often find myself having to change all of the RX Time entries provided so that Excel detects them as valid datetime fields. The reason for this is that the RX Time data is presented as YYYY/MM/DD/ HH:mm:SS::ssssss, while Excel for example will only detect dates of format YYYY/MM/DD HH:mm:SS.ssssss (notice the missing slash after DD and the decimal point instead of :: separator between SS and ssssss)
It would be nice to have some ability to modify the format of the RX Time field in settings so that I can present the datetime in whatever format I like, with custom separators between year, month, date, hour, minute, second, and sub-second fields.
Currently I've basically been using manual Find and Replace to accomplish this; I understand that it's possible to code up a quick script to do this on my end, but I feel this would be a good quality of life improvement for most users.
The text was updated successfully, but these errors were encountered: