Loading
Point of Sale
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Transformations & Regular Expressions

            You are here:

            1. Salesforce Help
            2. Docs
            3. Point of Sale

            Transformations & Regular Expressions

            Point of Sale data mapping uses transformations and regular expressions so you can get values in the correct formats. Use transformations such as applying arithmetic operations, formatting text, and converting date and time values. Regular expressions use patterns to find and replace strings to refine your data mapping.

            Populate Target Field with Constant Value

            If you want a target field to always have some constant value, map a required field (e.g., id) to the target field with a regex replace all.

            Regex Replace All

            • Regex: ^.*$
            • Replace: [CONSTANT_VALUE]
            • Group Index: [empty]

            Strip Currency Code from Price

            Input price:

            • 59.50 USD

            Replace All

            • Find: USD
            • Replace: [empty]

            Output price:

            • 59.50

            Transform Date into Milliseconds

            Input date:

            • 2019-12-21 10:00:00-05:00

            Date to Epoch

            • Transformation Type: Date to Epoch
            • Date Format: yyyy-MM-dd HH:mm:ssX
            • Epoch Type: Milliseconds

            Output date:

            • 1576940400000

            Transform Store Hours

            Input values for store hours:

            • Sunday 11AM TO 7PM
            • Monday 10AM TO 9:30PM
            • Tuesday 9:30AM TO 9:30PM
            • Wednesday 10:30AM TO 9PM

            Composite (Multiple Operations):

            • Regex Replace All
              • Regex: (Monday|Tuesday|Wednesday|Thursday|Friday|Saturday|Sunday) ([\d]{1,2})(AM|PM) TO ([\d]{1,2})(AM|PM)
              • Replace: $1:$2:00:$3:$4:00:$5,
              • Group Index: [empty]
            • Regex Replace All
              • Regex: (Monday|Tuesday|Wednesday|Thursday|Friday|Saturday|Sunday) ([\d]{1,2})(AM|PM) TO ([\d]{1,2}:[\d]{2})(AM|PM)
              • Replace: $1:$2:00:$3:$4:$5,
              • Group Index: [empty]
            • Regex Replace All

              • Regex: (Monday|Tuesday|Wednesday|Thursday|Friday|Saturday|Sunday) ([\d]{1,2}:[\d]{2})(AM|PM) TO ([\d]{1,2}:[\d]{2})(AM|PM)

              • Replace: $1:$2:$3:$4:$5,

              • Group Index: [empty]

            • Regex Replace All

              • Regex: (Monday|Tuesday|Wednesday|Thursday|Friday|Saturday|Sunday) ([\d]{1,2}:[\d]{2})(AM|PM) TO ([\d]{1,2})(AM|PM)
              • Replace: $1:$2:$3:$4:00:$5,
              • Group Index: [empty]

            • Replace All

              • Find: Sunday

              • Replace: 1

            • Replace All

              • Find: Monday

              • Replace: 2

            • Replace All

              • Find: Tuesday

              • Replace: 3

            • Replace All
              • Find: Wednesday
              • Replace: 4
            • Replace All
              • Find: Thursday
              • Replace: 5
            • Replace All
              • Find: Friday
              • Replace: 6
            • Replace All
              • Find: Saturday
              • Replace: 7

            Output values for store hours:

            • 1:11:00:AM:7:00:PM,
            • 2:10:00:AM:9:30:PM,
            • 3:9:30:AM:9:30:PM,
            • 4:10:30:AM:9:00:PM,
             
            Loading
            Salesforce Help | Article