Thread: MailMerge field for decimals with letters, i.e. 1A.23
View Single Post
 
Old 06-27-2024, 06:59 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
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
Looking at what you provided, it appears that you could compare SubLocation against a formatted ItemNumber. Do you have a larger data set which includes rounded numbers for us to test on?

I did have a fiddle with the one entry and you might be able to try something along the lines of testing formatted vs unformatted eg
{If {MERGEFIELD ItemNumber \# ##.##} = {MERGEFIELD ItemNumber } {MERGEFIELD ItemNumber } {MERGEFIELD ItemNumber \# ##.##}}
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote