public static string EncodeValue(object value, SharpValueType valueType, char delimiter = '\0', bool quoteQuotes = false) { if (value == null) { return(""); } if (value is DateTime) { return(EncodedString.TrimStandardDate((DateTime)value)); } if (!(value is string)) { return(value.ToString()); } var result = value.ToString(); if (EncodedString.IsQuotedStringEncodingRequired(result, delimiter: delimiter, quoteQuotes: quoteQuotes)) { return(EncodedString.EncodeQuotedString(result)); } return(result); }
public void WriteDelimited(IEnumerable <SharpRow> rows, SharpMapType mapType = SharpMapType.None, char delimiter = ',', List <string> columns = null, Dictionary <string, string> aliases = null) { columns = columns ?? new List <string>(); if (mapType == SharpMapType.Variable && IncludeHeader) { var columnNames = columns.Select(x => aliases != null && aliases.ContainsKey(x) ? aliases[x] : x); var header = string.Join(delimiter.ToString(), AlwaysQuote ? columns.Select(x => EncodedString.EncodeQuotedString(x)) : columns); _writer.WriteLine(header); } var includeNodes = new HashSet <string>(columns); foreach (var row in rows) { var nodeRow = row as SharpNodeRow; if (nodeRow != null) { var next = nodeRow.First; var valRow = next as SharpValueRow; var rowValues = new Dictionary <string, string>(); if (valRow != null && valRow.Node is SharpNodeMap) { var nodeMap = valRow.Node as SharpNodeMap; var columnValues = valRow.Values; if (nodeMap.MapType == SharpMapType.Fixed || nodeMap.MapType == SharpMapType.Variable) { if (valRow.Values.Count == 1) { columnValues = nodeMap.ExpandRow((string)valRow.Values[0]).Select(x => x.Value).ToList(); } } for (int i = 0; i < nodeMap.Columns.Count && i < columnValues.Count; i++) { var col = nodeMap.Columns[i]; if (includeNodes.Contains(col.Node.Name)) { rowValues[col.Node.Name] = SharpValue.ToString(columnValues[i], col.ValueType); } } } else { while (next != null) { if (!includeNodes.Contains(next.Node.Name)) { next = next.Next; continue; } valRow = next as SharpValueRow; var val = ""; if (valRow != null && valRow.Node.IsSingleValueNode) { val = SharpValue.ToString(valRow.Values[0], valRow.Node.ValueType); } rowValues[next.Node.Name] = val; next = next.Next; } } StringBuilder line = new StringBuilder(); bool first = true; foreach (var col in columns) { if (!first) { line.Append(delimiter); } first = false; if (rowValues.ContainsKey(col)) { var val = rowValues[col]; if (AlwaysQuote || (AllowQuotes && EncodedString.IsQuotedStringEncodingRequired(val, delimiter : delimiter, allowOnlyWhitespace : true))) { val = EncodedString.EncodeQuotedString(val); } line.Append(val); } } _writer.WriteLine(line); } } }