Page Comparison

Add Text

Adds a prefix or suffix to the text in a selected column. Empty cells in the column will also contain the prefix or suffix automatically.

• Select Add Text, enter the desired text, then specify the position of the new text (Before or After the selected cell).
  

  

Fill Down

In some cases, BOM line items span multiple rows, but not every column's data is repeated in each row.

• Select a column, then select Fill Down. Any blank cell is filled with the data from above.

Delete Column

Removes a selected column from the imported BOM.

Merge

Merges two or more selected columns of data into a single column. You can also remove the original columns after the merge.

Split

Divides a single selected column into two or more columns and splits the column at the selected characters.

Image Removed

Image Added

You can also remove the original columns after the split.

Replace

Searches for and replaces the specified text from the selected cell to all the cells in the column that contain the specified text.

You can match whole words only and/or match replacement text by case.

Create IPN Column

Allows you to create a new column from the selected column. The data in the new column may be appended with a prefix or suffix.

Merge Existing References

Allows you to merge the references from an existing BOM with the imported BOM (primarily used for non-PCB assemblies).