how to break a field in 3 parts?

[rcandeo]

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?

[its_anandrjs]

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

[Anonymous]

Use subfield:
subfield(Field, '/')

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

[GabrielAraya]

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

[its_anandrjs · Accepted solution]

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