Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Removing characters after the first occurrence of a character

Hello Anyone,
How do I remove characters after the first occurrence of a character(in this case "/") in a string?
Input: 3456439/3456432
Output: 3456439
Thanks! 

Labels (2)
10 Replies
Anonymous
Not applicable
Author

That wasn't meant as a challenge TRF :-)

I just noticed your suggestion and realised I should explain that what I was doing was covering an extrapolation of what was originally shown. Yours will be far more efficient than mine if the required logic is as you've used.