SQL Server - how to insert a substring?

Question

I have a string like

`...<..../><... id='someID' .../><...../>....`

(the total length of that string is more than 15k chars, it's an XML form definition)

Inside of that string I have the someID value. I want to put after the element containing that value a new string:

...<..../><... id='someID' .../><my_new_string><...../>....

I tried to split that long string basing on the someID value, but that approach is too slow. How can I achieve that on the other way ?

Or maybe is it possible to select the substring <... id='someID' .../> ?

Community · Accepted Answer · 2017-05-23 11:43:17Z

1

SQL server can work with XML. You do not need to use substring. A simular problem was solved on this page: xml.modify

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Apr 12, 2013 at 13:11

Edwin Stoteler

1,2271 gold badge11 silver badges25 bronze badges

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

Comments

ulaikamor · Accepted Answer · 2013-04-12 13:08:46Z

0

Have you tried using Replace? For example:

REPLACE(yourString, yourPattern, yourPattern + newString);

Using your example, it would look something like:

REPLACE('...<..../><... id='someID' .../><...../>....',
        '<... id=''someID'' .../>',
        '<... id=''someID'' .../><my_new_string>');

Please notice I escaped the ' characters around "someID".

Best regards.

answered Apr 12, 2013 at 13:08

ulaikamor

617 bronze badges

Comments

Pondlife · Accepted Answer · 2013-04-12 14:36:28Z

0

It isn't clear what data type your string is: xml or (n)varchar? For xml, you can use the various data type methods; for (n)varchar the STUFF() function inserts one string into another string.

answered Apr 12, 2013 at 14:36

Pondlife

16.3k6 gold badges40 silver badges51 bronze badges

Collectives™ on Stack Overflow

SQL Server - how to insert a substring?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related