how to extract some characters in a text expression

[delphine armagnac]

Dear all

I have a text expression which is :

"onde/onde_pub_inforemise/depot_id_deposant,depot_id_ptd,inforemise_date"

I would like to extract all characters before the first "/". All characters before the first "/" = "onde".

Do you you how to do it with tibco

Best regards

D

[Gaia Paolini]

assuming it is Spotfire, try this calculated column:

Split([mycolumn],'/',1)