How can search for text containg " (Quotation mark)

building reports webintelligence
1

Hi,

In XI Webi - If I use the Pos function or the Substr function on to search for " (Quotation mark) how do I do this. How do break it on " (Quotation)

i.e MyText = Laptop 14.1" TFT

What is the correct syntax for this Function :

=Pos([MyText ];“14.1"”)

I want to search 14.1" with the qutotaion mark at end

AsadR (BOB member since 2008-10-03)

2

Hi,

Try using

=Pos([MyText ];"14.1\"")

Here \ is the escape character.

[Moderator Edit: Added code formatting - Jansi]

priyanka1410 :uk: (BOB member since 2007-01-13)