in reply to Splitting a long row with multiple delimiters.
That format is not only ugly, but also problematic when the gecos field contains an '=' sign (if it is the same as a /etc/passwd gecos field, I think it would be allowed). If you have the possibility, request that your input format be improved.