Remove Period from Field Value

[#1]

Hi all,

I'm new to the Qlikview tool and currently working from datas extracted directly from the Oracle JDE database.

I would like to know is there a way to remove periods from field value.

Example:

Transform 50250.2041.503 to 502502041503

Thanks in advance!!

Best.

[maxgro · Accepted solution]

=replace( '50250.2041.503', '.', '')

or

=purgechar('50250.2041.503', '.')

[#3]

Thanks Mássimo!

But I would like to know how can I apply it to the whole field.

Thank you, again.

[#4]

Same syntax:

LOAD

     REPLACE([FieldName],'.','') AS FieldName

[MK_QSL]

Try below in script

replace( YourFieldName, '.', '') as YourFieldName

or

purgechar(YourFieldName, '.') as YourFieldName

[maxgro]

same answer, just use the field

load

replace (field, '.', '') as newfield;

sql

select

'50250.2041.503' "field"

from dual;