tag:blogger.com,1999:blog-6925744623615544233.post5621850991756114666..comments2023-06-23T08:25:43.829-07:00Comments on Video Tutes: Using filters with mailmergeDaihttp://www.blogger.com/profile/07518997268943179235noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6925744623615544233.post-7747191681644093072010-10-17T15:30:59.718-07:002010-10-17T15:30:59.718-07:00I agree. I took notice to that when I was watching...I agree. I took notice to that when I was watching the video as well. If you look when you highlight the Mr on ID's 0 & 7 it only selects the two letters. But when you highlight the others you can see there is an extra space after the Mr. <br /><br />This is a good note for many database, web, and other applications. Many of them count the space, some even will read "mr" and "Mr" as two different things.<br /><br />So make sure your always consistent and double check.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6925744623615544233.post-36186132384419109282008-10-20T19:28:00.000-07:002008-10-20T19:28:00.000-07:00I think the reason your "Mr" filter isn't working ...I think the reason your "Mr" filter isn't working is that filtering doesn't ignore spaces, and some of your titles have an extra space at the end.<BR/><BR/>In the first case (IDs 0 and 7), the title is "Mr" (without quotes). For the others, it's "Mr " with an extra space at the end.<BR/><BR/>Take those extra spaces out and it should work all the time.Anonymousnoreply@blogger.com