Code: Select all
ALLT(PADL(TRANSFORM(VAL(CONT_ID)),7," ")) +"*"+ALLT(PADL(TRANSFORM(VAL(GPB_ID)),3," "))+PADL(ALLT(ENDORSE),20,'*')
Sequence number would be as follows:
Code: Select all
ALLT(PADL(TRANSFORM(VAL(SEQUENCE)),7," "))
Moderators: Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Chrissy, Geoff, Vince
Code: Select all
ALLT(PADL(TRANSFORM(VAL(CONT_ID)),7," ")) +"*"+ALLT(PADL(TRANSFORM(VAL(GPB_ID)),3," "))+PADL(ALLT(ENDORSE),20,'*')
Code: Select all
ALLT(PADL(TRANSFORM(VAL(SEQUENCE)),7," "))