# RegEx for identical price in source and target

**URL:** <https://forum.xbench.net/t/regex-for-identical-price-in-source-and-target/1331>\
**Category:** Technical Support\
**Created:** [November 25, 2025, 10:01am UTC](https://forum.xbench.net/t/regex-for-identical-price-in-source-and-target/1331 "2025-11-25T10:01:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manuel](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.xbench.net/manuel/32/163_2.png) [@Manuel](https://forum.xbench.net/u/Manuel)\
**Post date:** [November 25, 2025, 10:01am UTC](https://forum.xbench.net/t/regex-for-identical-price-in-source-and-target/1331/1 "2025-11-25T10:01:54Z")

</div>

Hi all,

We have a client that wants us to keep prices exactly as per source, not even adapting price format. For instance, for prices such as “US$2,500”, “£500” or “¥100”, they want those prices stay exactly the same. Since our usual inclination would be to at least adapt format to “2500 US$”, “500 £” and “100 ¥”, respectively (following previous examples), we created the following check:

Source: `"(\$|£|¥|€)([0-9]{1,3},)?([0-9]{1,3})=1"`  
Target: `-@1`

PowerSearch: ON

Regex: ON

For some reason we do not understand, this search does not work, whereas we have other similar checks with variables that work perfectly. We tried performing only the source search and it works (if finds in source strings like “US$2,500”, “£500” or “¥100”).

For the time being, we used a workaround changing the `"-@1"` in target for `-"(\$|£|¥|€)([0-9]{1,3},)?([0-9]{1,3})=1"`. However, this is far from ideal, since it finds prices with different format, but would not spot if there was a mismatch in prices.

Agreed, one could argue that the _Numeric Mismatch_ check would already do the job for that last purpose, but we are still puzzled about why our original check does not yield any results.

Could anyone please help us see what are we doing wrong?

Kind regards,

Manuel

---

<div class="post-metadata">

**Author:** ![omartin](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.xbench.net/omartin/32/82_2.png) [@omartin](https://forum.xbench.net/u/omartin)\
**Post date:** [November 25, 2025, 11:59am UTC](https://forum.xbench.net/t/regex-for-identical-price-in-source-and-target/1331/2 "2025-11-25T11:59:25Z")

</div>

Try the following search:

Source: `"([\$£¥€]([0-9]{,3},)?[0-9]{,3})=1"`  
Target: `-@1`  
PowerSearch: on  
Search mode: Regular Expressions

---

<div class="post-metadata">

**Author:** ![Manuel](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.xbench.net/manuel/32/163_2.png) [@Manuel](https://forum.xbench.net/u/Manuel)\
**Post date:** [November 26, 2025, 9:27am UTC](https://forum.xbench.net/t/regex-for-identical-price-in-source-and-target/1331/3 "2025-11-26T09:27:39Z")

</div>

It works! Thank you Oscar!