cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Content center expression column format parameter name with leading spaces and trailing zeros for correct order

Content center expression column format parameter name with leading spaces and trailing zeros for correct order

Add some more functionality for modifying the content center expression with a expression column without using excel directly in the configuration.
Formatting a parameter name with leading space or/and trailing zeros.
Substring functions Mid, Left, Right,
String Length, Instr, RevInStr,
If then else conditions

Table ordered by 1st column:

expressionexpression with leading spaces an trailing zeros and if condition (length > 1, no trailing zeros)
M1,6M  1,6
M10M 10
M100M100
M2M  2,0

 

table ordered by 2nd column:

expressionexpression with leading spaces an trailing zeros and if condition (length > 1, no trailing zeros)
M1,6M  1,6
M2M  2,0
M10M 10
M100M100

Can't find what you're looking for? Ask the community or share your knowledge.

Submit Idea