Discussion Board for collaboration related to QlikView App Development.
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?
Go to Solution.
See the sample file
1. By subfield command like
2. By Left( ), Mid( ) and Right( ) command you are able to break fields.
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.
Use subfield:subfield(Field, '/')
The details depend on what you want to get...
You can use the SUBFIELD function
Like: Subfield(field,'/',1) is the first part Subfield(field,'/',2) is the second part ... and so on