sorry should have clarified, all the values are in a single field
"table.dimension" but is designated through a separate field "table.dimensionelement"
I tried a if/then on element but need it to loop all the way through and it was just picking the first dimension.
basically i need it to read...
I might be making this too complicated but basically I need to sort a report by dimensions each dimension has an element.
Overall
Opening
Length
Sometimes an object can have all 3 or just one or 2 of the options.
if there are 3 objects the first one has all 3 elements and the other two only...
Dear all,
can't get my head around this,
basically i have a set of values
1234.43.23.12
458.12.32.14
1234.43.23.13
I'd like to concatenate them like so:
1234.43.23.12,.13; 458.12.32.14
so basically compare all the numbers before the last "." if they are the same then only concatenate the last...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.