1

Topic: Question on

All greetings!
Something I can not understand as the second quote to remove
Itself  here ( the company title between inverted commas also eliminates Joint-Stock Company Open Company):

[^|]. [^ ` "] *

Example: Open Company "Daisy wheel"
Result: " the Daisy wheel
The first quote became how to remove?? Prompt please

2

Re: Question on

Something is not clear, how it generally eliminates. Result the code, its using.

3

Re: Question on

Antonariy;
Through RegExp

4

Re: Question on

[^|] is generally should not to work

5

Re: Question on

kos20 wrote:

Antonariy;
Through RegExp

yes it is fine? And I thought through ADODB.
More shortly, works so:

Dim oRegExp, txt
Set oRegExp = CreateObject ("VBScript. RegExp")
oRegExp. Global = True
oRegExp. Multiline = True
oRegExp. IgnoreCase = True
txt = "Open Company" "Daisy wheel" ""
oRegExp. Pattern = "(|) [`" "] ([^ `" "] +) [`" "]"
Debug. Print oRegExp. Replace (txt, "$2")

6

Re: Question on

Antonariy;
THANKS HUGE!!! THAT that is necessary!

7

Re: Question on

Antonariy;
And it is possible to rewrite  that eliminated inverted commas, instead of took the text in between,  not  there are inverted commas in a company title...

8

Re: Question on

txt = "Rum" "Open Company" "" ""
oRegExp. Pattern = "^ (|) [`" "] (. +) [`" "] $"

9

Re: Question on

But only the line is mandatory should begin Open Company or Joint-Stock Company, and to come to an end with a quote.

10

Re: Question on

Antonariy;
And if Open Company or Joint-Stock Company specify some in front or behind, others with a quote, others without...
Those generally it turns out it is impossible  simply to throw out inverted commas and Open Company words, Joint-Stock Company????

11

Re: Question on

In this case most easier to collect variants of a spelling and to make  for each variant.

12

Re: Question on

Antonariy;
Understood. All the same thanks big for power.