# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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"

1 Solution

Accepted Solutions
MVP

## 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
MVP

## 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

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

## 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

MVP

## 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