Find occurence of a char ?

[forstera]

Hello all,

I'm really new in jasper, so doesn't know if possible ...

I need to print a product name. If this product name has a code, the variable to print will be formed by the product code  and the product name. The product code will be placed between [ ]. So, it will look like this :

[My product code] Here's my product name

If the product has no code, onl y the procduct name will be displayed. What I've to do is : if there's a code, I need to remove the [ ] and if there's no code, so I've to fill with white spaces (15). The idea, when printing, is to have always the first column reserved for the product code .

So, I don't know if there's a function to find a char in a string. According to the fact that when there's a product code, the first char of the sring will be a [, I need to know where will be the ] char (the code has not always the same length).

is there a way to do that ? Per advance, thanks very much for your help

Best Regards

Arnaud

[gervase]

You might be able to do this in your SQL as a CASE statement:

 

(CASE

WHEN table.productcode is null THEN 'product name'

ELSE table.productcode

END) as PRODUCTCODE

 

Does that sound feasible?

[mdahlman]

Arnaud,

Try something like this:

$F{prod}.substring( $F{prod}.indexOf( ']' ) + 1 )

 

gervase,

It seems like you might be answering a different question.

 

Regards,
Matt