Topic: Double quotation marks in the data Posted: 21 Sep 2009 at 12:08pm
I have data in certain fields that has double quotation marks around it. I need to use the instr function to find stuff, but some of the data is partially duplicated.
Here's an example of what I'm talking about.
data thingy 1 is "MyName" = John more data more data some more data data thingy 2 is "Name" = That Tune
I want the data after "Name" and NOT the data after "MyName"
I've tried telling instr to start after x amount of characters to look for "Name", but the problem is, there is no set amount (or even close) of characters to start at.
Ultimately what I need is a way to use instr to search for ""Name"" and not just "Name"
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum