---
title: Using Source Values Window, Xpath Operators and Functions?
description: When adding a new xpath to the webstore configuration, you might need to do operations on values coming into that node. The following are some basic operators used under the “Select” section.
---

[Skip to content](https://hub.acctivate.com/articles/webstore-xpath-operators-and-functions#main-content)

![Acctivate - A CAI Solution](https://hub.acctivate.com/hubfs/Images/Logos/acctivate-cai-logo-svg.svg)

- [Knowledge Base](https://hub.acctivate.com/articles)

Open main navigation

Close main navigation

- [Knowledge Base](https://hub.acctivate.com/articles)
- [Support Resources / Create Ticket](https://acctivate.com/support)

[Support Resources / Create Ticket](https://acctivate.com/support)

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://hub.acctivate.com/articles?hsLang=en)
2. [Web Store Integrations](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en)
3. [Templates and Options](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#templates-and-options)

April 14, 2025

# Using Source Values Window, Xpath Operators and Functions?

## When adding a new xpath to the webstore configuration, you might need to do operations on values coming into that node. The following are some basic operators used under the “Select” section.

Note: Xpath is CASE SENSITIVE. It’s recommended to use “Xpath Scratch Pad” to create and test you xpaths. These are common operators and functions. See W3.org documentation on more functions: [https://www.w3.org/TR/xpath/#namespace-nodes](https://www.w3.org/TR/xpath/#namespace-nodes)

If you are running into a problem with your webstore, please see our common list of webstore xpath configurations that might help.

**Selecting All**

```
“.” means to get all nodes under the given MATCH. Example below (using Xpath ScratchPad)
```

 

**Browsing Nodes**

```
This follows the same convention as browsing files. The statement below goes up the path and selects the “status” node.Match: /array/value/billing_addressSelect: ../status
```

 

**Contains**

```
Select any node under comment node that has the string “test”match: /array/value/status_history/arrayselect: value[contains(comment,’test’)]/comment[text()]
```

 

**Concatenation**

```
match: /array/value/shipping_addressselect: concat(firstname, ‘ ‘, lastname)
```

 

**Division**

```
node1 div node2 (value or node)
```

 

**Multiplication**

```
node1 * node2 (or value)
```

 

**Subtraction**

```
node1 – node2 (or value)
```

 

**Addition**

```
node1 + node2 (or value)
```

 

**Acctivate Functions**

If Statement

```
a:IIf(Expression as Boolean, TruePart as Object, FalsePart as Object) as ObjectInline If.  If Expression evalues to true, returns TruePart, otherwise FalsePart.
```

 

Concatenating name and email

*a:ConcatNameAndEmail(FirstName as String, LastName as String, Email as String) as String*  
*Concatenates first name, last name, and email together. Trims to fit Customer ID field.  E.g. “John Doe (john.doe@example.com)”*

```
a:ConcatNameAndEmail(Name as String, Email as String) as StringConcatenates name and email.  Trims to fit Customer ID field. E.g. “John Doe (john.doe@example.com)”
```

 

Coalesce

```
a:StrCoalesce(Param1 as String, Param2 as String) as StringReturns the value of the first non-empty-string parameter.
```

```
a:StrCoalesce(Param1 as String, Param2 as String, Param3 as String) as StringReturns the value of the first non-empty-string parameter.a:StrCoalesce(Param1 as String, Param2 as String, Param3 as String, Param4 as String) as StringReturns the value of the first non-empty-string parameter.a:StrCoalesce(Param1 as String, Param2 as String, Param3 as String, Param4 as String, Param5 as String) as StringReturns the value of the first non-empty-string parameter.Boolean String operationsa:StrEquals(Param1 as String, Param2 as String) as BooleanCase-insensitive string comparison according to the system’s current language.a:CBoolean(Value as String) as BooleanConverts string to a boolean.  Defaults to false.a:StrIsIn(Value as String, Param1 as String, Param2 as String) as BooleanCase-insensitive string IsIn operator.a:StrIsIn(Value as String, Param1 as String, Param2 as String, Param3 as String) as BooleanCase-insensitive string IsIn operator.a:StrIsIn(Value as String, Param1 as String, Param2 as String, Param3 as String, Param4 as String) as BooleanCase-insensitive string IsIn operator.a:StrIsIn(Value as String, Param1 as String, Param2 as String, Param3 as String, Param4 as String, Param5 as String) as BooleanCase-insensitive string IsIn operator.
```

 

Replacing a current string with another

```
a:StrReplace(Value as String, ValueToFind as String, ValueToReplace as String) as BooleanCase-insensitive string replacement function.
```

 

Changing letter case

```
a:ToLower(Value as String) as StringConverts text to lower case using the system’s current language.a:ToUpper(Value as String) as StringConverts text to upper case using the system’s current language.
```

 

Convert to Xml

```
a:Xml(XmlString as String) as XPathNodeIteratorConverts strings to xml.Trimming whitespacea:LTrim(Value as String) as StringTrims whitespace on the left.a:RTrim(Value as String) as StringTrims whitespace on the right.a:Trim(Value as String) as StringTrims whitespace both left and right.
```

 

Tokenize strings

```
a:Split(Value as String, Delimiter as String) as XPathNodeIteratorSplits string.  Returns result in <Value> elements.
```

 

Line Operations

```
a:GetLine(Value as String, LineNumber as Int32) as StringSplits string by return characters and returns line.  Line Number is 1-based.
```

 

```
a:NewLine() as StringAdds a new New line.
```

 

String Delimiter

```
a:StrJoin(Values as XPathNodeIterator, Delimiter as String) as StringConverts node list into array of strings, and concatenates them into a string, inserting delimiter string between nodes.
```

For more information regarding XPaths, check out our [docs](https://docs.acctivate.com/docs/ConfigurationWebStore.html#source-values)page.

- [Getting Started](https://hub.acctivate.com/articles/getting-started?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/getting-started?hsLang=en#basics)
    - [User Interface](https://hub.acctivate.com/articles/getting-started?hsLang=en#user-interface)
    - [Manager windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#manager-windows)
    - [List windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#list-windows)
    - [Transaction windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#transaction-windows)
    - [License and Users](https://hub.acctivate.com/articles/getting-started?hsLang=en#license-and-users)
    - [Email](https://hub.acctivate.com/articles/getting-started?hsLang=en#email)
    - [Getting Help](https://hub.acctivate.com/articles/getting-started?hsLang=en#getting-help)
- [Installation](https://hub.acctivate.com/articles/installation?hsLang=en#main-content)

    - [Acctivate](https://hub.acctivate.com/articles/installation?hsLang=en#acctivate)
    - [Database Server](https://hub.acctivate.com/articles/installation?hsLang=en#database-server)
    - [Mobile WMS Setup](https://hub.acctivate.com/articles/installation?hsLang=en#mobile-wms-setup)
    - [Software Updates](https://hub.acctivate.com/articles/installation?hsLang=en#software-updates)
    - [Email Setup](https://hub.acctivate.com/articles/installation?hsLang=en#email-setup)
    - [Remote Access](https://hub.acctivate.com/articles/installation?hsLang=en#remote-access)
- [Configuration](https://hub.acctivate.com/articles/configuration?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/configuration?hsLang=en#basics)
    - [Users](https://hub.acctivate.com/articles/configuration?hsLang=en#users)
    - [Company Info](https://hub.acctivate.com/articles/configuration?hsLang=en#company-info)
    - [Customers](https://hub.acctivate.com/articles/configuration?hsLang=en#customers)
    - [Sales Orders](https://hub.acctivate.com/articles/configuration?hsLang=en#sales-orders)
    - [Inventory](https://hub.acctivate.com/articles/configuration?hsLang=en#inventory)
    - [Custom Fields](https://hub.acctivate.com/articles/configuration?hsLang=en#custom-fields)
    - [Email Message Templates](https://hub.acctivate.com/articles/configuration?hsLang=en#email-message-templates)
    - [Services](https://hub.acctivate.com/articles/configuration?hsLang=en#services)
- [Inventory](https://hub.acctivate.com/articles/inventory?hsLang=en#main-content)

    - [Products](https://hub.acctivate.com/articles/inventory?hsLang=en#products)
    - [Costing](https://hub.acctivate.com/articles/inventory?hsLang=en#costing)
    - [Prices and Units](https://hub.acctivate.com/articles/inventory?hsLang=en#prices-and-units)
    - [Warehouses and Locations](https://hub.acctivate.com/articles/inventory?hsLang=en#warehouses-and-locations)
    - [Lot Numbers](https://hub.acctivate.com/articles/inventory?hsLang=en#lot-numbers)
    - [Inventory Manager](https://hub.acctivate.com/articles/inventory?hsLang=en#inventory-manager)
    - [Receipts](https://hub.acctivate.com/articles/inventory?hsLang=en#receipts)
    - [Assemblies](https://hub.acctivate.com/articles/inventory?hsLang=en#assemblies)
    - [Kits and Assortments](https://hub.acctivate.com/articles/inventory?hsLang=en#kits-and-assortments)
    - [Landed Cost](https://hub.acctivate.com/articles/inventory?hsLang=en#landed-cost)
    - [Transfers](https://hub.acctivate.com/articles/inventory?hsLang=en#transfers)
    - [Adjustments](https://hub.acctivate.com/articles/inventory?hsLang=en#adjustments)
    - [Counts](https://hub.acctivate.com/articles/inventory?hsLang=en#counts)
    - [Reports](https://hub.acctivate.com/articles/inventory?hsLang=en#reports)
- [Purchasing](https://hub.acctivate.com/articles/purchasing?hsLang=en#main-content)

    - [Purchase Orders](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-orders)
    - [Purchase Order Manager](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-order-manager)
    - [Purchase Invoices](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-invoices)
    - [Vendors](https://hub.acctivate.com/articles/purchasing?hsLang=en#vendors)
- [Customers](https://hub.acctivate.com/articles/customers?hsLang=en#main-content)

    - [Customers](https://hub.acctivate.com/articles/customers?hsLang=en#customers)
    - [Locations](https://hub.acctivate.com/articles/customers?hsLang=en#locations)
    - [Credit & Terms](https://hub.acctivate.com/articles/customers?hsLang=en#credit-terms)
    - [Pricing](https://hub.acctivate.com/articles/customers?hsLang=en#pricing)
    - [Broadcast Email](https://hub.acctivate.com/articles/customers?hsLang=en#broadcast-email)
- [Sales](https://hub.acctivate.com/articles/sales?hsLang=en#main-content)

    - [Orders](https://hub.acctivate.com/articles/sales?hsLang=en#orders)
    - [Sales Order Manager](https://hub.acctivate.com/articles/sales?hsLang=en#sales-order-manager)
    - [Picking](https://hub.acctivate.com/articles/sales?hsLang=en#picking)
    - [Drop Shipments](https://hub.acctivate.com/articles/sales?hsLang=en#drop-shipments)
    - [Sales Tax](https://hub.acctivate.com/articles/sales?hsLang=en#sales-tax)
    - [Packaging](https://hub.acctivate.com/articles/sales?hsLang=en#packaging)
    - [Shipping](https://hub.acctivate.com/articles/sales?hsLang=en#shipping)
    - [Invoices](https://hub.acctivate.com/articles/sales?hsLang=en#invoices)
    - [Payments](https://hub.acctivate.com/articles/sales?hsLang=en#payments)
    - [Credits](https://hub.acctivate.com/articles/sales?hsLang=en#credits)
- [Business Activities](https://hub.acctivate.com/articles/business-activities?hsLang=en#main-content)

    - [Business Activities](https://hub.acctivate.com/articles/business-activities?hsLang=en#business-activities)
    - [Business Alerts](https://hub.acctivate.com/articles/business-activities?hsLang=en#business-alerts)
- [QuickBooks](https://hub.acctivate.com/articles/quickbooks?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/quickbooks?hsLang=en#basics)
    - [QuickBooks Online](https://hub.acctivate.com/articles/quickbooks?hsLang=en#quickbooks-online)
    - [QuickBooks Desktop](https://hub.acctivate.com/articles/quickbooks?hsLang=en#quickbooks-desktop)
- [Mobile WMS](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#basics)
    - [Picking](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#picking)
    - [Receiving](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#receiving)
    - [Counts](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#counts)
    - [Assemblies](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#assemblies)
- [Web Store Integrations](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#basics)
    - [Templates and Options](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#templates-and-options)
- [EDI](https://hub.acctivate.com/articles/edi?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/edi?hsLang=en#basics)
    - [Orders - 850](https://hub.acctivate.com/articles/edi?hsLang=en#orders-850)
    - [Shipments - 856](https://hub.acctivate.com/articles/edi?hsLang=en#shipments-856)
    - [Invoices - 810](https://hub.acctivate.com/articles/edi?hsLang=en#invoices-810)
    - [Warehouse - 940/945](https://hub.acctivate.com/articles/edi?hsLang=en#warehouse-940-945)
- [Reports](https://hub.acctivate.com/articles/reports?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/reports?hsLang=en#basics)
    - [Standard Reports](https://hub.acctivate.com/articles/reports?hsLang=en#standard-reports)
    - [Crystal Reports](https://hub.acctivate.com/articles/reports?hsLang=en#crystal-reports)
    - [Excel](https://hub.acctivate.com/articles/reports?hsLang=en#excel)
- [Database](https://hub.acctivate.com/articles/database?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/database?hsLang=en#basics)
    - [Backup & Restore](https://hub.acctivate.com/articles/database?hsLang=en#backup-restore)
    - [Microsoft SQL Server](https://hub.acctivate.com/articles/database?hsLang=en#microsoft-sql-server)
    - [Imports](https://hub.acctivate.com/articles/database?hsLang=en#imports)
- [Troubleshoot](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#main-content)

    - [General](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#general)
    - [Installation](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#installation)
    - [Inventory](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#inventory)
    - [Purchasing](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#purchasing)
    - [Sales](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#sales)
    - [Shipping](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#shipping)
    - [QuickBooks Desktop](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#quickbooks-desktop)
    - [QuickBooks Online](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#quickbooks-online)
    - [Mobile WMS](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#mobile-wms)
    - [Web Store Integration](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#web-store-integration)
    - [EDI](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#edi)
    - [Reports](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#reports)
    - [Database](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#database)
    - [Imports](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#imports)
    - [Email](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#email)
    - [Integrations](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#integrations)

[![Acctivate Inventory Software](https://hub.acctivate.com/hubfs/Images/Logos/acctivate-cai-logo-svg.svg "Acctivate Inventory Software")](https://acctivate.com)

Acctivate Knowledge Base

<https://www.twitter.com/acctivate> <https://www.linkedin.com/company/alterity-inc-/> [mailto:support@acctivate.com](mailto:support@acctivate.com)

Copyright © 2025, Alterity, LLC