Hi All,
I have a column that has random correctors and I want to exclude it with BIRT function,
value appears like "<~cb==bt=columnxc> London,Paris,Berlin<~ccl>
I want to only show London, Paris, London and preferably like below format in one cell
London
Paris
Berlin
could you please advice me what function to use and the syntax's please
thanks