Add Thousands Comma Separator to Currency Amounts in Word DOCX Document C# .NET

Aspose.Words Product Family
1

Hi team,
Do you have solution for comma separation in docX, in thousand places (i,e., for example if I entered values like $100000,it has to be displayed like $100,000.

2

@SAGITYA,

Please see these sample input & output Word documents (Docs 229982.zip (18.5 KB)) and try running the following C# code of Aspose.Words for .NET. The code will add thousands separator (comma) to the amounts starting with $ sign.

Document doc = new Document("C:\\Temp\\source.docx");

Regex regExpression = new Regex(@"\$\d+");
FindReplaceOptions findReplaceOptions = new FindReplaceOptions();
findReplaceOptions.Direction = FindReplaceDirection.Backward;
findReplaceOptions.ReplacingCallback = new MyReplaceEvaluator();

doc.Range.Replace(regExpression, "", findReplaceOptions);

doc.Save("C:\\Temp\\word.docx");

private class MyReplaceEvaluator : IReplacingCallback
{
    ///
    /// This is called during a replace operation each time a match is found.
    /// This method appends a number to the match string and returns it as a replacement string.
    ///
    ReplaceAction IReplacingCallback.Replacing(ReplacingArgs e)
    {
        // This is a Run node that contains either the beginning or the complete match.
        Node currentNode = e.MatchNode;

        // The first (and may be the only) run can contain text before the match,
        // in this case it is necessary to split the run.
        if (e.MatchOffset > 0)
            currentNode = SplitRun((Run)currentNode, e.MatchOffset);

        // This array is used to store all nodes of the match for further highlighting.
        ArrayList runs = new ArrayList();

        // Find all runs that contain parts of the match string.
        int remainingLength = e.Match.Value.Length;
        while (
            (remainingLength > 0) &&
            (currentNode != null) &&
            (currentNode.GetText().Length <= remainingLength))
        {
            runs.Add(currentNode);
            remainingLength = remainingLength - currentNode.GetText().Length;

            // Select the next Run node.
            // Have to loop because there could be other nodes such as BookmarkStart etc.
            do
            {
                currentNode = currentNode.NextSibling;
            }
            while ((currentNode != null) && (currentNode.NodeType != NodeType.Run));
        }

        // Split the last run that contains the match if there is any text left.
        if ((currentNode != null) && (remainingLength > 0))
        {
            SplitRun((Run)currentNode, remainingLength);
            runs.Add(currentNode);
        }

        DocumentBuilder builder = new DocumentBuilder((Document)e.MatchNode.Document);
        builder.MoveTo((Run)runs[runs.Count - 1]);

        builder.Font.Color = Color.Red;

        builder.Write("$" + Convert.ToDouble(e.Match.Value.Replace("$", "")).ToString("N").Replace(".00", ""));

        foreach (Run run in runs)
            run.Remove();

        return ReplaceAction.Skip;
    }

    ///
    /// Splits text of the specified run into two runs.
    /// Inserts the new run just after the specified run.
    ///
    private static Run SplitRun(Run run, int position)
    {
        Run afterRun = (Run)run.Clone(true);
        afterRun.Text = run.Text.Substring(position);
        run.Text = run.Text.Substring(0, position);
        run.ParentNode.InsertAfter(afterRun, run);
        return afterRun;
    }
}