View Single Post
 
Old 11-03-2019, 06:47 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,990
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Presumably the date numbers could be used for sorting even though we can't see what they mean in terms of day/month/year. Surely a bigger number is a later date/time.

When I open the xml in Word, I get a pattern of 6 paragraphs per message. If you convert this to a 6 column table (separated by paragraphs) and then sort on the date column then you should have the means of determining the correct order.

You can probably work out the algorithm for the date by looking at the difference between two messages (date & time) in the SMS and the number difference in the xml. Is the xml number showing number of seconds after a particular date/time? Perhaps it is documented in the software you are using to extract the xml.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote