実行ログをExcelに抽出しました。
TimeStampを文字列mm/dd/yyyy hh:mm:ssだけでSortすると、同じ行が複数存在して、実際のログの並びとは異なる並び方になる可能性を危惧しています。
この危惧が当たっている場合、ログのJSONファイルをDataTableに抽出する際に、ミリ秒単位でTimeStampを抽出しなければならないのでは？もしそうであれば、具体的な方法が分かる方、ご教示ください。
Why are you sorting this?
Already they would be in the right order if you dont sort at all
Cheers
Because I noticed the extracted Log excel file was shown like this yesterday,
12/08/2023 11:22:22
12/08/2023 09:23:22
12/08/2023 09:23:22
12/08/2023 09:23:23
I assume this was caused by the appended Log were addded at the top of existing log.
Is my understanding correct?
yes it is correct,the order would be in descending…
if you want to reverse the order you can use this in assign
dt = dt.AsEnumerable.Reverse.copyToDataTable
cheers
I gave you the exact command to use as well…Not sure what you need in the above statement…
The question way to order it in ascending and as it is already ordered in descending you just need to use reverse and that is what is mentioned above
Cheers