I have the data in my code like below which I need to format differently(C# code).
3.99E+03 5.3082E+03 4.719E+03 8.001E-01 7.3568E+02 5.759E+02 1.9892E+03
3.99E+03 6.0085E+03 4.5499E+03 8.321E-01 7.3305E+02 5.749E+02 2.0866E+03
3.99E+03 6.7089E+03 4.3104E+03 8.53E-01 7.2935E+02 5.738E+02 2.1531E+03
3.99E+03 7.4092E+03 4.0095E+03 8.625E-01 7.2471E+02 5.727E+02 2.1877E+03
3.99E+03 8.1096E+03 3.6563E+03 8.602E-01 7.1929E+02 5.716E+02 2.1892E+03
3.99E+03 8.8099E+03 3.2602E+03 8.461E-01 7.1325E+02 5.704E+02 2.156E+03
3.99E+03 9.5103E+03 2.8306E+03 8.212E-01 7.0675E+02 5.692E+02 2.082E+03
3.99E+03 1.0211E+04 2.3637E+03 7.848E-01 6.9973E+02 5.68E+02 1.9544E+03
Formatted data should look like below:
3.99E+03
5.3082E+03 4.719E+03 8.001E-01 7.3568E+02 5.759E+02 1.9892E+03
6.0085E+03 4.5499E+03 8.321E-01 7.3305E+02 5.749E+02 2.0866E+03
6.7089E+03 4.3104E+03 8.53E-01 7.2935E+02 5.738E+02 2.1531E+03
7.4092E+03 4.0095E+03 8.625E-01 7.2471E+02 5.727E+02 2.1877E+03
8.1096E+03 3.6563E+03 8.602E-01 7.1929E+02 5.716E+02 2.1892E+03
8.8099E+03 3.2602E+03 8.461E-01 7.1325E+02 5.704E+02 2.156E+03
9.5103E+03 2.8306E+03 8.212E-01 7.0675E+02 5.692E+02 2.082E+03
1.0211E+04 2.3637E+03 7.848E-01 6.9973E+02 5.68E+02 1.9544E+03
What I have tried:
Here is the piece of code I am trying.
var sb = new StringBuilder();
var csvSb = new StringBuilder();
string result = string.Empty;
var rpmvalue = dto.FirstOrDefault()?.data.FirstOrDefault();
for (int i = 0; i < dto[0].data.Count; i++)
{
for (int j = 1; j < dto.Count; j++)
{
result = dto[j].data.Count > 0 && dto[j].data[i] != 0 ? Convert.ToString(dto[j].data[i]) : string.Empty;
double dresult = 0.00;
if (Double.TryParse(result, out double number))
{
dresult = number;
}
result = string.Format("{0:0.#####E+00}", dresult);
AppendPadded(sb, csvSb, result, OperatingParamsValueWidth);
}
sb.AppendLine();
csvSb.AppendLine();
}
public void AppendPadded(StringBuilder sb, StringBuilder csvSb, string s, int count)
{
if (null == s)
s = string.Empty;
int maxLength = 10;
sb.Append(s);
//if (count - s.Length > 0)
sb.Append(' ', maxLength - s.Length + 2);
csvSb.Append(s);
csvSb.Append(',');
}