Dear Andrew,
after working with my data, it appears that messages are reversely sorted(newest to oldest) which is not a suitable choice and requires reading from bottom to top.
However, I faced the same problem mentioned in this post:
https://www.msofficeforums.com/word/...tml#post163131
But after googling, the sorting depends on the application that used for exporting messages
for example,
Super Backup Pro, makes XML and sort messages from newest to oldest.
SMS Backup & Restore, make XML and sort messages from oldest to newest (best choice).
So according to (SMS Backup & Restore), the pattern was changed to this:
Code:
<sms protocol=”0″ address=”+111111111111″ date=”1615582579995″ type=”1″ subject=”null” body=”my message……” toa=”null” sc_toa=”null” service_center=”+111111111111″ read=”1″ status=”-1″ locked=”0″ date_sent=”1615582589000″ readable_date=”Mar 12, 2021 11:56:19 PM” contact_name=”Ruyan” />
So please edit your code to extract these contents only:
body
readable_date
type
See attached file.