J
John
Result I want whether employee has an entry in "aka" field or not.
«EmployeeFirst» L. «EmployeeLast» aka Larry Alan Young v. «Employer»
{MERGEFIELD EmployeeFirst} {IF {MERGEFIELD EE_MI} <>"" "{MERGEFIELD EE_MI }
"}{MERGEFIELD EmployeeLast} {IF {MERGEFIELD AKA} <>"" "{MERGEFIELD AKA}"}v.
{MERGEFIELD Employer}
Merged Result using above:
Name with aka in field: Alan L. Young aka Larry Alan Youngv. (this result
needs space between g and v.)
Name with blank aka field: Martin Begg v. (this result has correct spacing)
If I instead add a space in front of the v. in above mergefield statement, I
get the following result:
Name with aka in field: Alan L. Young aka Larry Alan Young v. (this
spacing is correct between g and v.)
Name with blank aka field: Martin Begg v. (this result has added an
additional space and is incorrect)
Same Mergefield statement but in sentence format:
The employee «EmployeeFirst» «EmployeeLast». The next sentence starts.
The employee {MERGEFIELD EmployeeFirst} {IF {MERGEFIELD EE_MI} <>""
"{MERGEFIELD EE_MI } "}{MERGEFIELD EmployeeLast} {IF {MERGEFIELD AKA} <>""
"{MERGEFIELD AKA}"}. The next sentance starts
Merge Result:
Name with aka in field: Alan L. Youngaka Larry Alan Young. (needs space
between g and aka, but the spacing at end with period is correct)
Name with blank aka field: Martin Begg. (has correct spacing at period)
Can someone tell me where my mergefield statement is incorrect so that I can
use in all instances shown above.
Thank you,
AJ
«EmployeeFirst» L. «EmployeeLast» aka Larry Alan Young v. «Employer»
{MERGEFIELD EmployeeFirst} {IF {MERGEFIELD EE_MI} <>"" "{MERGEFIELD EE_MI }
"}{MERGEFIELD EmployeeLast} {IF {MERGEFIELD AKA} <>"" "{MERGEFIELD AKA}"}v.
{MERGEFIELD Employer}
Merged Result using above:
Name with aka in field: Alan L. Young aka Larry Alan Youngv. (this result
needs space between g and v.)
Name with blank aka field: Martin Begg v. (this result has correct spacing)
If I instead add a space in front of the v. in above mergefield statement, I
get the following result:
Name with aka in field: Alan L. Young aka Larry Alan Young v. (this
spacing is correct between g and v.)
Name with blank aka field: Martin Begg v. (this result has added an
additional space and is incorrect)
Same Mergefield statement but in sentence format:
The employee «EmployeeFirst» «EmployeeLast». The next sentence starts.
The employee {MERGEFIELD EmployeeFirst} {IF {MERGEFIELD EE_MI} <>""
"{MERGEFIELD EE_MI } "}{MERGEFIELD EmployeeLast} {IF {MERGEFIELD AKA} <>""
"{MERGEFIELD AKA}"}. The next sentance starts
Merge Result:
Name with aka in field: Alan L. Youngaka Larry Alan Young. (needs space
between g and aka, but the spacing at end with period is correct)
Name with blank aka field: Martin Begg. (has correct spacing at period)
Can someone tell me where my mergefield statement is incorrect so that I can
use in all instances shown above.
Thank you,
AJ