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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formating Names

Hi All

Im working on this project but in the name field there's digits and commas and wierd information. Is there maybe a formula that I can hide all those items that are not names but without deleting the information?

Thanks

1 Solution

Accepted Solutions
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi Blaze,

the functions Left, Right, Mid, Len and Subfield allows you, to find a string and to extract only value, you want to show.

View solution in original post

1 Reply
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi Blaze,

the functions Left, Right, Mid, Len and Subfield allows you, to find a string and to extract only value, you want to show.