Solved: always hide 5 from left - Qlik Community - 1613191

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

I have 10.10.10.10:2323

Just want to have 10.10.10.10

Left, right, mid? My brain is killing me 🙂

1 Solution

Accepted Solutions

here are some options:

subfield('10.10.10.10:2323', ':', 1)
left( '10.10.10.10:2323', len('10.10.10.10:2323')-5)
mid( '10.10.10.10:2323', 1, len('10.10.10.10:2323')-5)

talk is cheap, supply exceeds demand

View solution in original post

2 Replies

here are some options:

subfield('10.10.10.10:2323', ':', 1)
left( '10.10.10.10:2323', len('10.10.10.10:2323')-5)
mid( '10.10.10.10:2323', 1, len('10.10.10.10:2323')-5)

talk is cheap, supply exceeds demand

Author

Haha, Big thanx, so easy but my brain says friday 😄