Compare against all single values of a comma delimited string 2

[nilsbinnemans]

Hi,

I'm using CR 2011.
I have a table containing a string field with comma separated values.
Data could look like this:
Record

String​

1

StringA​

2

String A, String AB​

3

null​

4

StringAB​

5

StringB​

I want to suppress all records where {Table.String} contains 'StringA'.
I can't use 'StringA' in {Table.String} because record 4 with string 'StringAB' must be kept.
Desired outcome:
Record

String​

3

null​

4

StringAB​

5

StringB​

Which formula could help me out here?

Thanks,
Nils

 

[HowardHammerman]

Try this:
if isnull (table.string} true else "stringA" in {table.string}

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support

http://www.hammerman.com

 

[pmax9999]

What about:

'StringA,' in {Table.String}

Cheers
Pete

 

[BettyJ]

I think the following works. (Using pmax9999's post above - Thanks for the clever idea.)

Create the following formulas

@AddComma
[tt](Table.String}&",";[/tt]


@HasStringA
[tt]if "String A," in {@AddComma} then 1 else 0[/tt]

Use [tt]{@HasStringA}=1[/tt] as the Suppress Condition for the Details section.

 

[nilsbinnemans]

Thanks, that simple trick did it.