# Issue with substring function

**URL:** <https://forum.cloverdx.com/t/issue-with-substring-function/2082>\
**Category:** CloverDX Platform\
**Created:** [April 3, 2020, 12:00am UTC](https://forum.cloverdx.com/t/issue-with-substring-function/2082 "2020-04-03T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![av686165](https://avatars.discourse-cdn.com/v4/letter/a/9e8a1a/32.png) [@av686165](https://forum.cloverdx.com/u/av686165)\
**Post date:** [April 3, 2020, 12:00am UTC](https://forum.cloverdx.com/t/issue-with-substring-function/2082/1 "2020-04-03T00:00:00Z")

</div>

I have a column named as DEAL\_NUMBER which consists below four values,  
2442660018000120000000  
0000002442660018000124733590XAUUSDM  
0000002442660018000124733590XAUUSD  
0000002442660018000124733590AUDUSDM  
0000002442660018000124733590AUDUSD

After using the substring($in.0.DEAL\_NUMBER,12,16) function, the values has been transformed as below,  
18000110798858  
18000110798858  
18000110798858  
18000110798858  
18000110798858

not sure, why the first record has been replaced by the below deal numbers. Pls help.

---

<div class="post-metadata">

**Author:** ![vitd](https://avatars.discourse-cdn.com/v4/letter/v/dc4da7/32.png) [@vitd](https://forum.cloverdx.com/u/vitd)\
**Post date:** [April 8, 2020, 9:23am UTC](https://forum.cloverdx.com/t/issue-with-substring-function/2082/2 "2020-04-08T09:23:39Z")

</div>

Hello,

I do not understand what happens in your graph. Would you be so kind and place your sample graph as the attachment, please? The substring function should return:

```auto

0120000000
0018000124733590
0018000124733590
0018000124733590
0018000124733590

```

Please check the attached graph [DealNumber.grf](https://cdn.cloverdx.com/forum/19146%5Fa8ce0b4506cd1c09996c15914bbead63/DealNumber.grf).

- [DealNumber.grf](https://cdn.cloverdx.com/forum/19146%5Fa8ce0b4506cd1c09996c15914bbead63/DealNumber.grf)