# Data Manipulation

**URL:** <https://community.brightpattern.com/t/data-manipulation/50>\
**Category:** Product Q&A\
**Tags:** salesforce\
**Created:** [September 14, 2020, 10:02pm UTC](https://community.brightpattern.com/t/data-manipulation/50 "2020-09-14T22:02:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeneva.meares](https://avatars.discourse-cdn.com/v4/letter/j/f08c70/32.png) [@jeneva.meares](https://community.brightpattern.com/u/jeneva.meares)\
**Post date:** [September 14, 2020, 10:02pm UTC](https://community.brightpattern.com/t/data-manipulation/50/1 "2020-09-14T22:02:49Z")

</div>

How can I remove a leading ‘1’ from caller id

---

<div class="post-metadata">

**Author:** ![greg.luttbrightpatte](https://avatars.discourse-cdn.com/v4/letter/g/a6a055/32.png) [@greg.luttbrightpatte](https://community.brightpattern.com/u/greg.luttbrightpatte)\
**Post date:** [September 14, 2020, 10:05pm UTC](https://community.brightpattern.com/t/data-manipulation/50/2 "2020-09-14T22:05:20Z")

</div>

To manipulate the incoming callerID (presumably to search in Salesforce, or other CRM), you may take the following steps in your scenario

Set variable DID to (item.from) - (item.from) is the built in CallerID variable  
Set variable DID to =replace("$(DID)","(\d{1})(\d{10})","\2","")

For more on our built in replace function, please see the documentation link on our website at [https://help.brightpattern.com/5.3:Scenario-builder-reference-guide/Reference/VariablesandExpressions/Built-inFunctions](https://help.brightpattern.com/5.3:Scenario-builder-reference-guide/Reference/VariablesandExpressions/Built-inFunctions)