I want to create unique Index system base on Type and Size. E.g.
(in 2 separate columns)
Type = Package Material
Size = Small
The index formed should be P_Mat(S)
The requirement is that the first Capital of the Type followed by 3 Letters of the next WORD and followed by Bracketed first Letter of Size (S) or (M) or (L)
I cant seem to get the 3 letters of the second word
Help anyone?
(in 2 separate columns)
Type = Package Material
Size = Small
The index formed should be P_Mat(S)
The requirement is that the first Capital of the Type followed by 3 Letters of the next WORD and followed by Bracketed first Letter of Size (S) or (M) or (L)
I cant seem to get the 3 letters of the second word
Help anyone?