Taking string within quotation marks in javascript

Question

I'm trying to get the content of a string within a string, delimited by double quotation marks ("). My HTML is as following:

<body>
  <div>
    sqlString = "UPDATE galleria SET image_description = @image_description WHERE id = " + image.Id;
  </div>
</body>

and I'm trying to get the

UPDATE galleria SET image_description = @image_description WHERE id =

as a single string via my javascript. I know this is probably possible using indexOf or some related method, but I can't seem to get it to work.

zdesam · Accepted Answer · 2013-03-14 10:01:58Z

1

Try this on the sqlString variable

var lastIndex = sqlString.lastIndexOf("=");
var subString = sqlString.substring(1, lastIndex);

subString should contain your required string.

answered Mar 14, 2013 at 10:01

zdesam

2,9863 gold badges29 silver badges32 bronze badges

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

4 Comments

Yeah. That would work. Do you have any idea if I want to concatanate the string even further? Like with sqlString = "UPDATE " + dbName + " SET "...

and in such case you want only UPDATE SET as a return string?

I would want UPDATE as one string and SET as another string.

You could extract every second value from the array sqlString.split ('"')

net892z · Accepted Answer · 2013-03-14 10:21:59Z

1

Give you DIV tag an id attribute, and reference the div by that id.

<body>
   <div id="div1">
     sqlString = "UPDATE galleria SET image_description = @image_description WHERE id = " + image.Id;
  </div>
</body>

Then match the string using regular expression:

var $div = document.getElementById('div1');
var matches = $div.innerHTML.match(/(?!")([^"]+)/g);

if(matches!==null) {
    alert(matches[1]); 
}

answered Mar 14, 2013 at 10:21

net892z

614 bronze badges