On 2010-09-23 14:58, John Bowling wrote:
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) so they never can be equal.
So, I'm reverting to using the .csv of the spreadsheet, and then using
bash (in Linux) to do the compare where I can extract specific
characters, then rebuilding the .csv using bash. CLI always comes
through when GUI fails!
By the way, the newly re-written help functions on the Internet for
calc still tell you to use ';' when only '.' is valid.
John
John:
Try this function: =Exact(A2&" "&B2;C2)
'Exact' determines if two strings are identical. I padded a space
between the two cell values to get the correct format.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
