Merge field with Newlines

Using VB.net

Switching from homegrown word merge program to yours.

I currently have a merge field named that looks like this:
'Restitution of $100.00 to:\br\br\t\ABC Company\t\br\t$60.00\br\br\t\DEF Company\t\br\t$40.00’

My homegrown program honors the breaks (\br) and tabs (\t) and it appears this way when merged:

Restitution of $100.00 to:

ABC Company
$60.00

DEF Company
$40.00

How would I structure my merge field to achieve the same result using Aspose?

Thank you.
Hi Brian,

Thanks for your inquiry. In your case, I suggest you please find and replace the \br\ and \t\ as shown in following code example. You can achieve your requirement by implementing IReplacingCallback interface.

Please read the following article about 'Find and Replace' and check the following code example for your kind reference.
http://www.aspose.com/docs/display/wordsnet/Find+and+Replace+Overview

Hope this helps you. Please let us know if you have any more queries.

Document doc = new Document(MyDir + "in.docx");

doc.Range.Replace(new Regex(@"\\br\\"), new ReplaceEvaluator(ControlChar.LineBreak), false);

doc.Range.Replace(new Regex(@"\\t\\"), new ReplaceEvaluator (ControlChar.Tab), false);

doc.Save(MyDir + "Out.docx");

private class ReplaceEvaluator : IReplacingCallback

{

private string repalcetext;

public ReplaceEvaluatorInsertField(String str)

{

repalcetext = str;

}

///

/// This method is called by the Aspose.Words find and replace engine for each match.

///

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 removing.

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);

}

// Create Document Buidler aond insert MergeField

DocumentBuilder builder = new DocumentBuilder(e.MatchNode.Document as Document);

builder.MoveTo((Run)runs[runs.Count - 1]);

builder.Write(repalcetext);

// Now remove all runs in the sequence.

foreach (Run run in runs)

run.Remove();

// Signal to the replace engine to do nothing because we have already done all what we wanted.

return ReplaceAction.Skip;

}

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;

}

}


This worked for me, thank you!

Hi Brian,

Thanks for your feedback. Please feel free to ask if you have any question about Aspose.Words, we will be happy to help you.