Opcode flag +4 enables "CSV mode", which attempts to parse the source string as if it were comma separated (CSV) or TAB separated fields. This mode is similar to the existing quoted mode (+2), but with following differences:
• | While +2 mode recognizes quoted sub-fields anywhere within a field, +4 (CSV) mode only considers quotes as possible delimiters if the first non-blank character in the field is a quote. Any quotes which occur mid-field are treated as data characters. A subsequent quote will only be considered as the trailing quote of the field if it is followed by a field or record delimiter. |
• | Leading and trailing spaces are removed from the returned field |
• | Pairs of adjacent double-quote characters ("") are coalesced into single ones, i.e. 6"" Banana becomes 6" Banana. |