Regex: Get first value from single line [duplicate]

Question

I have the below xml on a single line, I want to get the string of DBB and replace it using regex

<Configuration ConfiguredType="Property" Path="\Package.Connections[DBA DB].Properties[ConnectionString]" ValueType="String"><ConfiguredValue>Data Source=.\test;Initial Catalog=DBA;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=B;</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[DBB DB].Properties[ConnectionString]" ValueType="String"><ConfiguredValue>Data Source=.\test;Initial Catalog=DBB;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=C;</ConfiguredValue></Configuration></DTSConfiguration>

I have the following which works on multi line xml but not this single line example

Data Source=.+?(?=[a-z])*\;Initial Catalog=DBB;(.*?)Integrated(.*?)[^;]*;

The above regex highlights both DBA and DBB and ends there.

Could you help in finding the missing piece in the regex I have created

Why are you using a regex? Does your language not have proper XML support? — Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams, Commented Mar 12, 2015 at 23:40
It looks like part of a .net config file... there are tools out there to parse and process it... use them. — Jeff Mercado
– Jeff Mercado, Commented Mar 12, 2015 at 23:43
My aim was to do a simple string replace then get involved in xml — FreshRob
– FreshRob, Commented Mar 12, 2015 at 23:47

aergistal · Accepted Answer · 2015-03-12 23:44:52Z

1

Replace Data Source=.+? with Data Source=[^<]+? to avoid traversing the start of the tag.

answered Mar 12, 2015 at 23:44

aergistal

31.4k5 gold badges76 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

aergistal Over a year ago

It's far from perfect, you should really use an XML parser if possible, for the sanity of the developers that might touch your code later.

Collectives™ on Stack Overflow

Regex: Get first value from single line [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related