Ad:

C# Discussion Thread
Marked Solved
Views: 1503

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Sep 17th, 2009

String formatting

Expand Post »

Hello, I am having the hardest time getting my strings to format right

I want it to only show the first 14 chars of the string. sounds simple, but I think ive been looking at the code to long to see where im messing up

.

here's the code I have

C# Syntax (Toggle Plain Text)
int fCount = mwReader.FieldCount;
            for ( int i = 0; i < fCount; i ++ )
            {
                Console.Write("{0,-15}", mwReader.GetName(i));
                Console.Write(" ");
            }
            Console.WriteLine("".PadLeft(80, '-'));
 
            while (mwReader.Read())
            {
                string description = mwReader.GetString(0);
                if (description.Length > 14)
                    description.Substring(0, 14);
 
                Console.WriteLine("{0,-15} {1,-15} {2,-12:C} {3,-12} {4,-12:C}",
                                      description,
                                      mwReader.GetString(1),
                                      mwReader.GetValue(2),
                                      mwReader.GetBoolean(3),
                                      mwReader.GetValue(4)
                                      );
            }
int fCount = mwReader.FieldCount;
            for ( int i = 0; i < fCount; i ++ )
            {
                Console.Write("{0,-15}", mwReader.GetName(i));
                Console.Write(" ");
            }
            Console.WriteLine("".PadLeft(80, '-'));

            while (mwReader.Read())
            {
                string description = mwReader.GetString(0);
                if (description.Length > 14)
                    description.Substring(0, 14);

                Console.WriteLine("{0,-15} {1,-15} {2,-12:C} {3,-12} {4,-12:C}",
                                      description,
                                      mwReader.GetString(1),
                                      mwReader.GetValue(2),
                                      mwReader.GetBoolean(3),
                                      mwReader.GetValue(4)
                                      );
            }

the IF statement was my last attempt to use sub string on it but even that is not working.

Here's the out put im getting

(Toggle Plain Text)

Description     ProductNo       Price           IsOnSale        SalePrice
--------------------------------------------------------------------------------

Heaven's Come To Eearth Today 080689016271    $1.60        False

Christmas Is Jesus 080689015274    $1.60        False
Child Of Light  080689014277    $1.60        False
You Love Me Still 080689008276    $1.60        False
You Are Holy    080689007279    $1.60        False
Worship Only You 080689006272    $1.60        False
Through The Fire 080689005275    $1.60        False
So Much God     080689004278    $1.60        False
Sing To The King 080689003271    $1.60        False
Sing            080689002274    $1.85        False
Praise To The Lord Almighty. 080689001277    $1.60        False

Jude Doxology   080689000270    $1.60        True         $12.95
Berceuse and Finale 00137           $60.00       False
Tell My Father  02501096        $1.80        False

I want it to look like

(Toggle Plain Text)

Description     ProductNo       Price           IsOnSale        SalePrice
--------------------------------------------------------------------------------
Heaven's Come T 080689016271    $1.60        False
Christmas Is Je 080689015274    $1.60        False
Child Of Light  080689014277    $1.60        False
You Love Me Sti 080689008276    $1.60        False
You Are Holy    080689007279    $1.60        False
Worship Only Yo 080689006272    $1.60        False
Through The Fir 080689005275    $1.60        False
So Much God     080689004278    $1.60        False
Sing To The Kin 080689003271    $1.60        False
Sing            080689002274    $1.85        False
Praise To The L 080689001277    $1.60        False
Jude Doxology   080689000270    $1.60        True         $12.95
Berceuse and Fi 00137           $60.00       False
Tell My Father  02501096        $1.80        False

Please Help
and Tank you

Don

Similar Threads

String Formatting in C#
VC++ bloody problem. What to use for string formatting in C++
String formatting using the "\t" character in Java
Date formatting? in Pascal and Delphi

=OTS=G-Man

Reputation Points: 37

Solved Threads: 10

Light Poster

Offline

47 posts
since Jul 2009

Permalink

Sep 17th, 2009

Re: String formatting

Use:

C# Syntax (Toggle Plain Text)
description = description.Substring(0, 14);
description = description.Substring(0, 14);

or..

under the console.WriteLine(), display description.SubString(0,14) instead of just description.

jatin24

Reputation Points: 31

Solved Threads: 21

Junior Poster in Training

Offline

74 posts
since Aug 2009

Permalink

Sep 17th, 2009

Re: String formatting

Use Console.WriteLine("{0,14}","Right"); to right align a string and Console.WriteLine("{0,-14}","Left"); left align a string.
Think you have to assign description.Substring(0, 14); to another string.

Edit: Must be getting some sleep : jantin24 already said that...

Last edited by ddanbe; Sep 17th, 2009 at 10:39 pm.

ddanbe

Reputation Points: 2035

Solved Threads: 644

Senior Poster

Offline

3,736 posts
since Oct 2008

Permalink

Sep 18th, 2009

Re: String formatting

Take a look at MSDN page - Composite Formatting

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Sep 18th, 2009

Re: String formatting

I think you may consider abandoning string format because you're getting more in to formatting a line than an individual value.

C# Syntax (Toggle Plain Text)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
 
namespace daniweb
{
  public partial class frmStringFormat : Form
  {
    public frmStringFormat()
    {
      InitializeComponent();
    }
 
    private static string[] GetTestData()
    {
      List<string> result = new List<string>();
      result.Add("Description |    ProductNo    |   Price     |      IsOnSale    |    SalePrice|");
      result.Add("Heaven's Come To Eearth Today| 080689016271 |   $1.60  |      False");
      result.Add("Christmas Is Jesus| 080689015274|    $1.60 |       False|");
      result.Add("Child Of Light|  080689014277 |   $1.60  |      False|");
      result.Add("You Love Me Still| 080689008276|    $1.60 |       False|");
      result.Add("You Are Holy|    080689007279|    $1.60  |      False|");
      result.Add("Worship Only You| 080689006272|    $1.60  |      False|");
      result.Add("Through The Fire| 080689005275|    $1.60 |       False|");
      result.Add("So Much God|     080689004278 |   $1.60  |      False|");
      result.Add("Sing To The King| 080689003271|    $1.60 |       False|");
      result.Add("Sing|            080689002274|    $1.85  |      False|");
      result.Add("Praise To The Lord Almighty.| 080689001277|    $1.60|        False|");
      result.Add("Jude Doxology|   080689000270 |   $1.60  |      True  |       $12.95");
      result.Add("Berceuse and Finale| 00137|           $60.00|       False|");
      result.Add("Tell My Father|  02501096|        $1.80  |      False |");
      return result.ToArray();
    }
 
    private void button1_Click(object sender, EventArgs e)
    {
      StringBuilder sb = new StringBuilder();
      string[] lines = GetTestData();
      //0= header
      //1+ = values
 
      const string space = " ";
 
      for (int i1 = 0; i1 < lines.Length; i1++)
      {
        //0-Desc, 1-Prod#, 2-$$, 3-On Sale, 4-Sale Price
        string[] values = lines[i1].Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
        sb.Append(values[0].Trim().PadRight(15).Left(15));
        sb.Append(space + values[1].Trim().PadRight(15).Left(15));
        sb.Append(space + values[2].Trim().PadRight(15).Left(15));
        sb.Append(space + values[3].Trim().PadRight(15).Left(15));
 
        if (values.Length >= 5)
          sb.Append(space + values[4].Trim().PadRight(15).Left(15));
 
        sb.AppendLine(string.Empty);
        if (i1 == 0)
        {
          sb.AppendLine(new string('-', sb.Length));
        }
      }
      Console.WriteLine(sb.ToString());
    }
  }
  public static class Extensions
  {
    /// <summary>
    /// Takes the left N characters of a string
    /// </summary>
    /// <param name="str"></param>
    /// <param name="Length">The number of characters to return</param>
    /// <returns></returns>
    public static string Left(this string str, int Length)
    {
      if (string.IsNullOrEmpty(str) || Length.Equals(0))
        return string.Empty;
      else
        return str.Substring(0, Math.Min(Length, str.Length) - 1);
    }
  }
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace daniweb
{
  public partial class frmStringFormat : Form
  {
    public frmStringFormat()
    {
      InitializeComponent();
    }

    private static string[] GetTestData()
    {
      List<string> result = new List<string>();
      result.Add("Description |    ProductNo    |   Price     |      IsOnSale    |    SalePrice|");
      result.Add("Heaven's Come To Eearth Today| 080689016271 |   $1.60  |      False");
      result.Add("Christmas Is Jesus| 080689015274|    $1.60 |       False|");
      result.Add("Child Of Light|  080689014277 |   $1.60  |      False|");
      result.Add("You Love Me Still| 080689008276|    $1.60 |       False|");
      result.Add("You Are Holy|    080689007279|    $1.60  |      False|");
      result.Add("Worship Only You| 080689006272|    $1.60  |      False|");
      result.Add("Through The Fire| 080689005275|    $1.60 |       False|");
      result.Add("So Much God|     080689004278 |   $1.60  |      False|");
      result.Add("Sing To The King| 080689003271|    $1.60 |       False|");
      result.Add("Sing|            080689002274|    $1.85  |      False|");
      result.Add("Praise To The Lord Almighty.| 080689001277|    $1.60|        False|");
      result.Add("Jude Doxology|   080689000270 |   $1.60  |      True  |       $12.95");
      result.Add("Berceuse and Finale| 00137|           $60.00|       False|");
      result.Add("Tell My Father|  02501096|        $1.80  |      False |");
      return result.ToArray();
    }

    private void button1_Click(object sender, EventArgs e)
    {
      StringBuilder sb = new StringBuilder();
      string[] lines = GetTestData();
      //0= header
      //1+ = values

      const string space = " ";

      for (int i1 = 0; i1 < lines.Length; i1++)
      {
        //0-Desc, 1-Prod#, 2-$$, 3-On Sale, 4-Sale Price
        string[] values = lines[i1].Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
        sb.Append(values[0].Trim().PadRight(15).Left(15));
        sb.Append(space + values[1].Trim().PadRight(15).Left(15));
        sb.Append(space + values[2].Trim().PadRight(15).Left(15));
        sb.Append(space + values[3].Trim().PadRight(15).Left(15));
        
        if (values.Length >= 5)
          sb.Append(space + values[4].Trim().PadRight(15).Left(15));
          
        sb.AppendLine(string.Empty);
        if (i1 == 0)
        {
          sb.AppendLine(new string('-', sb.Length));
        }
      }
      Console.WriteLine(sb.ToString());
    }
  }
  public static class Extensions
  {
    /// <summary>
    /// Takes the left N characters of a string
    /// </summary>
    /// <param name="str"></param>
    /// <param name="Length">The number of characters to return</param>
    /// <returns></returns>
    public static string Left(this string str, int Length)
    {
      if (string.IsNullOrEmpty(str) || Length.Equals(0))
        return string.Empty;
      else
        return str.Substring(0, Math.Min(Length, str.Length) - 1);
    }
  }
}

Results in:

text Syntax (Toggle Plain Text)

Description    ProductNo      Price          IsOnSale       SalePrice     
----------------------------------------------------------------------------
Heaven's Come  080689016271   $1.60          False         
Christmas Is J 080689015274   $1.60          False         
Child Of Light 080689014277   $1.60          False         
You Love Me St 080689008276   $1.60          False         
You Are Holy   080689007279   $1.60          False         
Worship Only Y 080689006272   $1.60          False         
Through The Fi 080689005275   $1.60          False         
So Much God    080689004278   $1.60          False         
Sing To The Ki 080689003271   $1.60          False         
Sing           080689002274   $1.85          False         
Praise To The  080689001277   $1.60          False         
Jude Doxology  080689000270   $1.60          True           $12.95        
Berceuse and F 00137          $60.00         False         
Tell My Father 02501096       $1.80          False

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Sep 18th, 2009

Re: String formatting

Thanks Scott for the nice explanation on formatting issue using Generic and StringBuilder.

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Sep 18th, 2009

Re: String formatting

And Extension methods brought to you by framework 3.x!

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Sep 18th, 2009

Re: String formatting

I learnt a lot from this threadm thanks thanks thanks

Ramy Mahrous

Featured Poster

Reputation Points: 480

Solved Threads: 276

Postaholic

Offline

2,189 posts
since Aug 2006

Permalink

Sep 18th, 2009

Re: String formatting

Click to Expand / Collapse Quote originally posted by sknake ...

And Extension methods brought to you by framework 3.x!

I had to +rep you for this example, which was my first exposure to usage of Extension Methods. The fist thing I did of course was drop the code into another class, which produced an error and forced me to read up on the subject a little.

DdoubleD

Reputation Points: 341

Solved Threads: 233

Posting Shark

Offline

984 posts
since Jul 2009

Permalink

Sep 18th, 2009

Re: String formatting

Wow, that you all for the replies, and Glad this topic helped some other people out!

Click to Expand / Collapse Quote originally posted by sknake ...

And Extension methods brought to you by framework 3.x!

I notice you mention thats from .NET 3.x

I should say, I'm stuck using .NET 2.5 because I only have VS 2005. unless there is a way to get 2005 to use the 3.x compiler?

I was messing around with it after work and ended up just doing what jatin24 mentioned and was what i had originally but my ,and i should have been smarter, ReSharper said was redundant.

=OTS=G-Man

Reputation Points: 37

Solved Threads: 10

Light Poster

Offline

47 posts
since Jul 2009

Page 1
2
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: Program my object to add itself to an ArrayList?

Next Thread in C# Forum Timeline: How can we assign or revok permission to users on apllications through C#.NET?

DaniWeb Message

Cancel Changes

User Name
Password