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

Modify data from a table

Hi,

I am loading data from a table and would like to remove the two last characters of the field PRV_CODE. (#0)

These characters is allways in the end of the value, but the length of the PRV_CODE can vary.

Any idea?

PRV_RENTITYPRV_PROPERTYPRV_CODEPRV_NVALUE
PMCFESTTIMER83#05.000000

Best regards
Dag

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Use below in your script instead of PRV_CODE

Replace(PRV_CODE,'#0','') as PRV_CODE

View solution in original post

5 Replies
srchilukoori
Specialist
Specialist

if its '#0' always. You can use the Replace function to replace the '#0'  with a '' (blank).

chiru_thota
Specialist
Specialist

you can use

=SubField(PRV_CODE,'#',1)

MK_QSL
MVP
MVP

Use below in your script instead of PRV_CODE

Replace(PRV_CODE,'#0','') as PRV_CODE

arsal_90
Creator III
Creator III

Use Purge Char fuction

=purgechar(PRV_CODE,'#0')

Not applicable
Author

Thanks for all answers.
The code worked fine 🙂