Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
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)

Regards,

Przemek

0 Replies