Forums
New posts
Search forums
What's new
New posts
New media
New media comments
Latest activity
Media
New media
New comments
Search media
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Main Forums
Automation, Cinema, Computers, Television Forum
A query to alter a Word doc. ?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Help Support Talk Electrician Forum:
This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
Message
<blockquote data-quote="SPECIAL LOCATION" data-source="post: 499914" data-attributes="member: 250"><p>You have to remember the file names will be treated as text and sorted alpha numerically.. NOT as numbers.</p><p></p><p>So for example.. if you were back at 3 digit numbers and didn't add a preceding zero, (or space), in the file name the alphabetical orders will look wrong numerically.</p><p></p><p>Say you have four invoices:- 345, 567, 2345 &amp; 4567 and just named them with a preceding 'INV' with no spaces or zeros..</p><p></p><p>the alphabetical order would be:- "INV2345, INV345, INV4567, INV567"</p><p></p><p>Which looks numerically wrong.. but is correct alphanumerically.</p><p></p><p>Or if you had a put a Zero before the 345, and a Space before 567... That will also look wrong as space comes before zero in the computers alpha sort..</p><p></p><p>so you would get:- INV 567, INV0345, INV2345, INV4567</p><p></p><p>which is getting better but the space -vs- zero will still mess up your listing..</p><p></p><p>AND... if you've gone and stuck a double space before some of the digits.. it can end up looking totally random!</p><p></p><p>If you have used a consistent name structure with the same number of digits for every job, then it will be just select sort on the file name in your file manager program..</p><p></p><p>Otherwise you may be a bit screwed!</p><p></p><p> :C</p></blockquote><p></p>
[QUOTE="SPECIAL LOCATION, post: 499914, member: 250"] You have to remember the file names will be treated as text and sorted alpha numerically.. NOT as numbers. So for example.. if you were back at 3 digit numbers and didn't add a preceding zero, (or space), in the file name the alphabetical orders will look wrong numerically. Say you have four invoices:- 345, 567, 2345 & 4567 and just named them with a preceding 'INV' with no spaces or zeros.. the alphabetical order would be:- "INV2345, INV345, INV4567, INV567" Which looks numerically wrong.. but is correct alphanumerically. Or if you had a put a Zero before the 345, and a Space before 567... That will also look wrong as space comes before zero in the computers alpha sort.. so you would get:- INV 567, INV0345, INV2345, INV4567 which is getting better but the space -vs- zero will still mess up your listing.. AND... if you've gone and stuck a double space before some of the digits.. it can end up looking totally random! If you have used a consistent name structure with the same number of digits for every job, then it will be just select sort on the file name in your file manager program.. Otherwise you may be a bit screwed! :C [/QUOTE]
Insert quotes…
Verification
Post reply
Main Forums
Automation, Cinema, Computers, Television Forum
A query to alter a Word doc. ?
Top