Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

rcandeo
Contributor III

how to break a field in 3 parts?

Hi, I need to separate the content in the field in 3 parts like this:

Always will exist 2 "/" separating the thre parts.

"FIRST PART/SECONT PART/THIRD PART" --> "FIRST PART", "SECOND PART", "THIRD PART"

Can anyone help me please?

1 Solution

Accepted Solutions

Re: how to break a field in 3 parts?

Hi,

See the sample file

1. By subfield command like

          =Subfield(ColA,'/',1)

          =Subfield(ColA,'/',2)

          =Subfield(ColA,'/',3)

2. By  Left( ), Mid( ) and Right( ) command you are able to break fields.

          =Left(ColA,10)

          =Mid(ColA,12,11)

          =Right(ColA,10)

HTH

Rgds

Anand

4 Replies

Re: how to break a field in 3 parts?

Hi,

You want to break field or its column data if so

Yes you can with the help of Left( ), Right( ), Mid( )  And Subfield ( / ) commands you break it into parts.

Rgds

Anand

mov
Esteemed Contributor III

how to break a field in 3 parts?

Use subfield:
subfield(Field, '/')

The details depend on what you want to get...

Highlighted
Employee
Employee

how to break a field in 3 parts?

Hi ..

You can use the SUBFIELD function

Like: Subfield(field,'/',1) is the first part
        Subfield(field,'/',2) is the second part ... and so on

Gabriel

Re: how to break a field in 3 parts?

Hi,

See the sample file

1. By subfield command like

          =Subfield(ColA,'/',1)

          =Subfield(ColA,'/',2)

          =Subfield(ColA,'/',3)

2. By  Left( ), Mid( ) and Right( ) command you are able to break fields.

          =Left(ColA,10)

          =Mid(ColA,12,11)

          =Right(ColA,10)

HTH

Rgds

Anand