Leading and trailing white space characters (see table 1) will be automatically trimmed from each line. If the column separator is set to tab (U+0009) tabs will not be trimmed. The first character of a line is defined as the first non-white space character, the last character as the last non-white space character.
Lines where the first characters (after trimming) equals the user-defined Comment Designator (see table 2) are treated as comment lines and will be ignored. If a comment designator is contained in a line, but is not the first character in the line it will be treated as data.
Empty lines (i.e. lines that only contain white space characters) are ignored.
Each non-comment and non-empty line is separated into cells by the user-defined column separator character (see table 2).
Class |
Members |
Space Separators |
SPACE (U+0020), OGHAM SPACE MARK (U+1680), MONGOLIAN VOWEL SEPARATOR (U+180E), EN QUAD (U+2000), EM QUAD (U+2001), EN SPACE (U+2002), EM SPACE (U+2003), THREE-PER-EM SPACE (U+2004), FOUR-PER-EM SPACE (U+2005), SIX-PER-EM SPACE (U+2006), FIGURE SPACE (U+2007), PUNCTUATION SPACE (U+2008), THIN SPACE (U+2009), HAIR SPACE (U+200A), NARROW NO-BREAK SPACE (U+202F), MEDIUM MATHEMATICAL SPACE (U+205F), and IDEOGRAPHIC SPACE (U+3000) |
Line Separator |
LINE SEPARATOR character (U+2028) |
Other |
CHARACTER TABULATION (U+0009), LINE FEED (U+000A), LINE TABULATION (U+000B), FORM FEED (U+000C), CARRIAGE RETURN (U+000D), NEXT LINE (U+0085), and NO-BREAK SPACE (U+00A0). |
Table 1: White space characters that are removed from the beginning or end of a string when a string is trimmed
