![]() |
#6
|
||||
|
||||
![]()
Hi Theodore ,
Quote:
Quote:
FWIW, although you can't extract the first two characters via a LEFT function, you could use a series of fields to find out what they are. For example, you could retrieve them via field coding like: {SET Str {docproperty customprop2}} {IF{REF Str} = "1*" "1"}{IF{REF Str} = "2*" "2"} ... {IF{REF Str} = "A*" "A"}{IF{REF Str} = "B*" "B"} ... {IF{REF Str} = "a*" "a"}{IF{REF Str} = "b*" "b"} etc. for the first character, and: {IF{REF Str} = "?1*" "1"}{IF{REF Str} = "?2*" "2"} ... {IF{REF Str} = "?A*" "A"}{IF{REF Str} = "?B*" "B"} ... {IF{REF Str} = "?a*" "a"}{IF{REF Str} = "?b*" "b"} etc. for the second. If you have the possibility of any letter or number, that could mean having to work with 62 fields per character - 124 in all, though fewer fields are required if some characters (eg lower-case letters) can be ruled out.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
etherplain | Word VBA | 2 | 02-05-2013 07:32 PM |
Conditional Fields Breaking Down With Large Merge | GabeChiarelli | Mail Merge | 2 | 01-31-2013 07:17 AM |
![]() |
PaulPCoker | Excel | 4 | 09-21-2012 11:26 AM |
![]() |
alphonse68 | Word | 1 | 01-09-2012 03:34 PM |
Word not highlighting conditional Merge fields | Dunce | Mail Merge | 0 | 02-15-2010 05:44 AM |