BusinessObjects Board

Splits with space

I have some field Place (New Delhi ) I need in 2 columns (first one “New” and second one “Delhi”)

It can be “Navi Mumbai”, “Raj Pura” .

What function will be use for Find " "?.

Pls Guide

BR
Sultan

Pos(" ";[placefield])

Will give you the position of the space