I have a column named Address which has CITY, ZIP values stored in it. But I would like to break the column into two with CITY as one column and ZIP as another one.
Sorry, no experience of ReportStudio, so can't offer solution. I would expect you'll need a combination of the functions REVERSE, LEFT and LOCATE to parse out the two items from the single field.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.