Optimal Join of a text to string with Logic

[sryair]

I need to Join together By Logic some Attributes (Delimited with “ | “


Attribute Name Attribute Sequence prefix
SHORT NAME MODULE,DISCRETE 1
TYPE OUTPUT 2
SIZE 100MM 3 SZ
POWER SUPPLY 24VDC 4 PS
POWER RATING 100W 5 PR
NUMBER OF INPUTS 16 DIGITAL 6
NUMBER OF OUTPUTS 16 ANALOG 7
MOUNTING PLUG-IN 9
APPLICATION COMPUTER 15 APP
FREQUENCY 50HZ 16

The max length of the join string is 50 characters
The first two attributes must be in the join string

The Other Attributes by the Sequence
Then required to optimize and check if the join length of the string is the max possible


Any ideas how to do this with VBA code in Excel?

 

[mole999]

care to provide examples of the finished requirement

what drives the logic, what rules would the human apply to get the result EVERYTIME

 

[sryair]

SHORT NAME: MODULE,DISCRETE
TYPE: OUTPUT
SIZE: 100MM
POWER SUPPLY: 24VDC
POWER RATING: 100W
NUMBER OF INPUTS: 16 DIGITAL
NUMBER OF OUTPUTS: 16 ANALOG
MOUNTING: PLUG-IN
APPLICATION: COMPUTER
FREQUENCY: 50HZ

The max length of the join string is 50 characters
The first two attributes must be in the join string

The Other Attributes by the Sequence

Then required to optimize and check if the join length of the string is the max possible

the string look like:MODULE,DISCRETE | OUTPUT | 100MM | ETC....

Any ideas how to do this with VBA code in Excel?

 

[sryair]

The max length of the join string is 50 characters
The first two attributes must be in the join string

The Other Attributes by the Sequence

Then required to optimize and check if the join length of the string is the max possible

the string look like:MODULE,DISCRETE | OUTPUT | 100MM | ETC....