Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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