Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Double quotation marks in the data Post Reply Post New Topic
Author Message
joverdorff
Newbie
Newbie


Joined: 10 Sep 2009
Online Status: Offline
Posts: 9
Quote joverdorff Replybullet 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"

Any ideas?

Thanks in advance.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Sep 2009 at 12:43pm
try and put single quotes aroun d the inner double quotes and search by that...
IP IP Logged
joverdorff
Newbie
Newbie


Joined: 10 Sep 2009
Online Status: Offline
Posts: 9
Quote joverdorff Replybullet Posted: 21 Sep 2009 at 12:49pm
Holy cow! Well, that was easy (not to mention it works perfectly)!

THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Sep 2009 at 12:55pm
No prob.
The inverse process works if you find you require a search for something with an apostrophe like say Jay's....
instr(field,"Jay's")
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.