Dear Gabrieli. I have here a question.
I need to rebuild KLADR (all-Russian classifier of addresses) in a digestible hierarchical structure. After a sleepless night, fifty cigarettes and a bucket of coffee you only have to parse the rows in the table HOME.
As you know, in the database KLADR the names of the houses are kept roughly in this format:
N(19-31), N(67-77), H(2-40),65
How, using C# and T-SQL, you can Preobrazovatel these lines just in the list of buildings, structures, enclosures and so on in order? I understand that here it is possible to use regular expressions, but I, alas, they are not strong.