topic Re: Remove Period from Field Value in QlikView

Remove Period from Field Value

Wed, 02 Apr 2014 20:58:32 GMT

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 — Wed, 02 Apr 2014 21:08:34 GMT

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

=purgechar('50250.2041.503', '.')

Wed, 02 Apr 2014 21:10:38 GMT

Thanks Mássimo!

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

Thank you, again.

Wed, 02 Apr 2014 21:15:28 GMT

Same syntax:

LOAD

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

MK_QSL — Wed, 02 Apr 2014 21:16:15 GMT

Try below in script

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

purgechar(YourFieldName, '.') as YourFieldName

maxgro — Wed, 02 Apr 2014 21:21:41 GMT

same answer, just use the field

load

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

sql

select

'50250.2041.503' "field"

from dual;