public void CharacterJustSeparators()
{
var opts = new ExplodeOptions(new Delimiters());
var text = ",,,";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.False(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(4, sl.Count);
Assert.Equal("", sl[0]);
Assert.Equal("", sl[1]);
Assert.Equal("", sl[2]);
Assert.Equal("", sl[3]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(4, sl.Count);
Assert.Equal("", sl[0]);
Assert.Equal("", sl[1]);
Assert.Equal("", sl[2]);
Assert.Equal("", sl[3]);
}
public void InsideDoubleTextDelimitersEnablesStrictPositioningDisabled()
{
var opts = new ExplodeOptions(new Delimiters());
opts.AllowInsideDoubleTextDelimiters = true;
opts.StrictTextDelimiterPositioning = true;
var text = @"one,""t""""wo"",three";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.True(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("t\"wo", sl[1]);
Assert.Equal("three", sl[2]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("\"t\"\"wo\"", sl[1]);
Assert.Equal("three", sl[2]);
}
public void TextDelimiterDisabledWithInsideSeparator()
{
var opts = new ExplodeOptions(new Delimiters());
opts.EnableTextDelimiter = false;
var text = @"one,""t,wo"",three";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.False(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(4, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal(@"""t", sl[1]);
Assert.Equal(@"wo""", sl[2]);
Assert.Equal("three", sl[3]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(4, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal(@"""t", sl[1]);
Assert.Equal(@"wo""", sl[2]);
Assert.Equal("three", sl[3]);
}
public void InsideDoubleTextDelimitersDisabledStrictPositioningDisabledAsLastField()
{
var opts = new ExplodeOptions(new Delimiters());
opts.AllowInsideDoubleTextDelimiters = false;
opts.StrictTextDelimiterPositioning = false;
var text = @"one,""t""""wo""";
// " in string
// t take t
// " out string
// " in string
// w take w
// o take o
// " out string
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.True(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(2, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal(@"two", sl[1]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(2, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("\"t\"\"wo\"", sl[1]);
}
public void CharacterEmptyFieldAtEnd()
{
var opts = new ExplodeOptions(new Delimiters());
var text = "one,two,three,";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.False(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(4, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("two", sl[1]);
Assert.Equal("three", sl[2]);
Assert.Equal("", sl[3]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(4, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("two", sl[1]);
Assert.Equal("three", sl[2]);
Assert.Equal("", sl[3]);
}
private void TextToStringArrayTest()
{
var opts = new ExplodeOptions(new Delimiters());
//defaults
opts.StrictTextDelimiterPositioning = true;
opts.StrictTextDelimiterPositioningAllowLeadingTrailingSpaces = true;
var text = @"one,""two"",""three""";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.True(sr.WereAnyCellsTextDelimited);
string[] sa = sr.Cells.ToStringArray();
Assert.Equal(3, sa.Length);
Assert.Equal("one", sa[0]);
Assert.Equal("two", sa[1]);
Assert.Equal("three", sa[2]);
sa = sr.Cells.RawTextToStringArray();
Assert.Equal(3, sa.Length);
Assert.Equal("one", sa[0]);
Assert.Equal("\"two\"", sa[1]);
Assert.Equal("\"three\"", sa[2]);
}
private void TerminatedWithTextDelimitedFieldMultiCharTextDelimiterTrailingSpaces()
{
var opts = new ExplodeOptions(new Delimiters(',', "<>"));
//defaults
opts.StrictTextDelimiterPositioning = true;
opts.StrictTextDelimiterPositioningAllowLeadingTrailingSpaces = true;
var text = @"one,<>two<>,<>three<> ";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.True(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("two", sl[1]);
Assert.Equal("three", sl[2]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("<>two<>", sl[1]);
Assert.Equal("<>three<> ", sl[2]);
}
public void StrictTextDelimiterPositioningEnabledSpacesEnabledWithTrailingSpacesMultiCharSeperator()
{
var opts = new ExplodeOptions(new Delimiters("_x_"));
opts.StrictTextDelimiterPositioning = true;
opts.StrictTextDelimiterPositioningAllowLeadingTrailingSpaces = true;
var text = @"one_x_ ""two"" _x_three";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.True(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("two", sl[1]);
Assert.Equal("three", sl[2]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal(" \"two\" ", sl[1]);
Assert.Equal("three", sl[2]);
}
/// <summary>
/// Explode multipage document to single pages
/// </summary>
/// <param name="parameters">Parameters of explosion</param>
/// <returns>Result of operation</returns>
public ExplodeResult Explode(ExplodeParams parameters)
{
UrlBuilder urlBuilder = new UrlBuilder(
m_api.ApiUrlImgUpV.
Action("explode").
BuildUrl());
using (HttpWebResponse response = m_api.Call(
HttpMethod.POST, urlBuilder.ToString(), parameters.ToParamsDictionary(), null))
{
ExplodeResult result = ExplodeResult.Parse(response);
return(result);
}
}
public void CharacterDifferentSeperator()
{
var opts = new ExplodeOptions(new Delimiters(':'));
var text = "one:two:three";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.False(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("two", sl[1]);
Assert.Equal("three", sl[2]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("two", sl[1]);
Assert.Equal("three", sl[2]);
}
public void StringTextDelimitersWithEmbeddedTextDelimiterAndFieldSeparator()
{
var opts = new ExplodeOptions(new Delimiters(",", "_x_"));
var text = @"one,_x_two_x__x_,q,uote_x_,three";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.True(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("two_x_,q,uote", sl[1]);
Assert.Equal("three", sl[2]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("_x_two_x__x_,q,uote_x_", sl[1]);
Assert.Equal("three", sl[2]);
}
public void StringTextDelimiters()
{
var opts = new ExplodeOptions(new Delimiters("_x_", "<>"));
var text = "one_x_<>two<>_x_three";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.True(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("two", sl[1]);
Assert.Equal("three", sl[2]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("<>two<>", sl[1]);
Assert.Equal("three", sl[2]);
}
public void CharacterTextDelimitersWithEmbeddedTextDelimiter()
{
var opts = new ExplodeOptions(new Delimiters());
var text = @"one,""two""""quote"",three";
ExplodeResult sr = Explode.ExplodeString(text, opts);
Assert.True(sr.WereAnyCellsTextDelimited);
List <string> sl = sr.Cells.ToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal(@"two""quote", sl[1]);
Assert.Equal("three", sl[2]);
sl = sr.Cells.RawTextToStringList();
Assert.Equal(3, sl.Count);
Assert.Equal("one", sl[0]);
Assert.Equal("\"two\"\"quote\"", sl[1]);
Assert.Equal("three", sl[2]);
}
private void AssertExplodeStatus(ExplodeResult result)
{
Assert.AreEqual("processing", result.Status);
}
private void AssertExplodeStatus(ExplodeResult result)
{
Assert.AreEqual("processing", result.Status, result.Error?.Message);
}
