Identify Symbols in names

building reports webintelligence
1

Can anyone help with this one. Can BO tell me if a Name has symbols in it…

example. John O’Shea

Need to highlight this name as it contains a apostrophe (’)

I need to create an exception report that identifies all names that contain some kind of symbol. Only Letters or Numbers are allowed.

Many thanks
Zahed

:frowning:

Sims786 (BOB member since 2006-04-04)

2

Hi Saima786,

Create a variable :

=If (User Name or Object name) IN (‘give all the special characters here’);‘then display your text message’;’ ')

Now you can get all the names with special characters.

Let me know if I understood correct way.

Thanks
RK

krohanstar (BOB member since 2008-04-20)

3

Tried this

=If ([Standardpayeridentification] In (’*’);“Inv”)

got following error

The date/time ‘*’ format at position 39 is not valid. Specify a valid date/time format. (Error: WIS 10035

Have I done something wrong

Sims

Sims786 (BOB member since 2006-04-04)

4

Hi,

Please check if you are validating are of same datatypes.

What is the datatype of ([Standardpayeridentification])

Thanks
RK

krohanstar (BOB member since 2008-04-20)

5

HI,

Do not use “Inv” (No double quotes " " in Webi)

Hope this works…

Thanks
RK

krohanstar (BOB member since 2008-04-20)

6

You need to use a logical test something like:

=Match([Name];"*'*") Or Match([Name];"*-*")

Your problem is knowing which special characters to include in your list!

What are you going to do with these records anyway? Why not use the Replace function to remove the special characters.

You are far better doing this kind of data manipulation in the database anyway.

anorak :uk: (BOB member since 2002-09-13)

7

Its an Exception report to highlight these symbols in the database name fields. The User would then go into Database and correct

thanks
Sims

Sims786 (BOB member since 2006-04-04)

8

I don’t know what John O’Shea would say about that! :lol:

anorak :uk: (BOB member since 2002-09-13)

9

Hi,

Do you have a list of Characters that could possibly appear in the Name?

M H Mohammed :us: (BOB member since 2010-06-16)

10

Try using ASCII values for comparison.

Jansi :india: (BOB member since 2008-05-12)