Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Remove Period from Field Value

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Remove Period from Field Value

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

or

=purgechar('50250.2041.503', '.')

5 Replies
MVP
MVP

Re: Remove Period from Field Value

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

or

=purgechar('50250.2041.503', '.')

Not applicable

Re: Remove Period from Field Value

Thanks Mássimo!

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

Thank you, again.

Not applicable

Re: Remove Period from Field Value

Same syntax:

LOAD

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

Re: Remove Period from Field Value

Try below in script

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

 

or

purgechar(YourFieldName, '.') as YourFieldName

MVP
MVP

Re: Remove Period from Field Value

same answer, just use the field

load

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

sql

select

'50250.2041.503' "field"

from dual;

Community Browser