Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_RENTITY | PRV_PROPERTY | PRV_CODE | PRV_NVALUE |
PMCF | ESTTIMER | 83#0 | 5.000000 |
Best regards
Dag
Use below in your script instead of PRV_CODE
Replace(PRV_CODE,'#0','') as PRV_CODE
if its '#0' always. You can use the Replace function to replace the '#0' with a '' (blank).
you can use
=SubField(PRV_CODE,'#',1)
Use below in your script instead of PRV_CODE
Replace(PRV_CODE,'#0','') as PRV_CODE
Use Purge Char fuction
=purgechar(PRV_CODE,'#0')
Thanks for all answers.
The code worked fine 🙂