Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Use subfield:
subfield(Field, '/')
The details depend on what you want to get...
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
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