Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 11-03-2019, 06:47 PM
Guessed's Avatar
Guessed Guessed is offline Need to reverse order of SMS text messages a program has exported to Word Windows 10 Need to reverse order of SMS text messages a program has exported to Word Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
reverse order of paragraphs, word 2010 moorea21 Word VBA 1 08-02-2018 03:47 AM
open dialog box in Word has folders in reverse alphabetical order Rewster Word 2 02-20-2017 08:06 AM
Need to reverse order of SMS text messages a program has exported to Word Reverse Order for Flashcards? bknollman3 PowerPoint 2 03-23-2013 06:34 AM
wildcards in find & replace to reverse word order jeffk Word 3 11-11-2012 01:47 PM
Reverse order of headings throughout Word my_vine_figtree Word VBA 1 08-17-2010 01:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft