At 11:58 23/09/2010 -0700, John Bowling wrote:
... OOcalc has no substring functions
Er, what about such functions as CONCATENATE(), FIND(), LEFT(), MID(), RIGHT(), REPLACE(), SEARCH(), SUBSTITUTE(), TRIM(), ...?
I have columns that contain addresses. Column A is number and street as in '1234 N Main'. Column B is the building and unit number as in 'F456'. Column C is the address as it would be placed on an envelope: '1234 N Main F456'. I need to indicate in another column if the combination of column A concatenated to column B is exactly the same as column C. In OO calc, when concatenated, it becomes '1234 N MainF456' (trailing spaces are deleted by OOcalc) ...
Hold on! What do you mean by "trailing spaces are deleted"? Not in any version of Calc I have used! In any case, you make clear above that the contents of your column A do not contain trailing blanks. Concatenation won't invent blanks that were not there in the originals - but that's helpful, not a problem.
... so they never can be equal.
If there is never a trailing blank in column A, you need to compare C1 with A1&" "&B1, not with A1&B1 (as has already been suggested). If the values in column A may have trailing blanks, you may need something like TRIM(A1)&" "&B1.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
