I was looking at this and the core issue is that a space at the beginning or end of a name could theoretically be a valid org unit name. I question why anyone would do that but .... there are more things in heaven and earth than dreamt of in my philosophies.
Still, if we want to trim surrounding spaces from it this should do it:
Hi Jane,
I was looking at this and the core issue is that a space at the beginning or end of a name could theoretically be a valid org unit name. I question why anyone would do that but .... there are more things in heaven and earth than dreamt of in my philosophies.
Still, if we want to trim surrounding spaces from it this should do it:
http:// git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=blobdiff; f=Open- ILS/src/ sql/Pg/ 030.schema. metabib. sql;h=17b39fbcc 380737d01c5f309 d4bb2feb6b54558 9;hp=bc72c89601 7f793b21623132d a28b20f0ec76d3f ;hb=d9f0334c29b 242f27bf8f6b853 81595c7e2719c9; hpb=d6a247f3847 fa26e8e5cadf8cd 92ff573a828584
/user/rogan/ lp1722827_ trim_spaces_ from8569s
FWIW, I think this is worth doing, barring anyone pointing out use cases it would break and it worked in my (admittedly brief) testing.