Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Seperate numbers from non numbers

Hi All,

I'm looking for a way to seperate brackets and numbers from other characters i.e. if a bracket (externally only) or a number is in an immediate neighbourhood of non bracket or number character a space should be inserted between them like in the following strings:

1. String: milk(fat), sugar (white), (green)tea to string: milk (fat), sugar (white), (green) tea

2. String: milk 3, sugar12, tea56(green) to string: milk 3, sugar 12, tea 56 (green)



Community Browser