Modify data from a table

[#1]

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

[srchilukoori]

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

[chiru_thota]

you can use

=SubField(PRV_CODE,'#',1)

[MK_QSL · Accepted solution]

Use below in your script instead of PRV_CODE

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

[arsal_90]

Use Purge Char fuction

=purgechar(PRV_CODE,'#0')

[#6]

Thanks for all answers.
The code worked fine 🙂