# formatNumber in script

**URL:** <https://forum.inductiveautomation.com/t/formatnumber-in-script/4837>\
**Category:** Ignition\
**Created:** [July 18, 2012, 4:35pm UTC](https://forum.inductiveautomation.com/t/formatnumber-in-script/4837 "2012-07-18T16:35:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AJBerera](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\
**Post date:** [July 18, 2012, 4:35pm UTC](https://forum.inductiveautomation.com/t/formatnumber-in-script/4837/1 "2012-07-18T16:35:13Z")

</div>

value1 = event.source.parent.getComponent(‘GroupName’).text  
value2 = event.source.parent.getComponent(‘Spinner’).intValue  
value3 = numberFormat(value2, 0000)

#idNumber = system.db.runScalarQuery(“SELECT MAX(store) + 1 FROM shipping\_stores”)  
system.db.runUpdateQuery(“INSERT INTO shipping\_stores (store) VALUES (’%s’)” % (value3), ‘Sample’)  
system.db.runUpdateQuery(“UPDATE shipping\_stores SET groupname = ‘%s’ WHERE store = ‘%s’”% (value1, value3), ‘Sample’)

Here is a script that works fine for value 2, but I am inserting an int value that needs formating.  
I keep getting an error saying that numberFormat does not exist.

What should I use to format my int to a 4 digit value?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [July 18, 2012, 4:52pm UTC](https://forum.inductiveautomation.com/t/formatnumber-in-script/4837/2 "2012-07-18T16:52:22Z")

</div>

Try:

```auto
value3 = "%04d" % value2
```

You’re trying to use the numberFormat function from the expression language inside a jython script, which isn’t going to work.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [July 18, 2012, 4:54pm UTC](https://forum.inductiveautomation.com/t/formatnumber-in-script/4837/3 "2012-07-18T16:54:08Z")

</div>

numberFormat is an expression function, not a scripting one.

Try using:

value3 = “%04d” % value2

EDIT: Dang! Kevin beat me to it! 😆

---

<div class="post-metadata">

**Author:** ![AJBerera](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\
**Post date:** [July 18, 2012, 5:18pm UTC](https://forum.inductiveautomation.com/t/formatnumber-in-script/4837/4 "2012-07-18T17:18:39Z")

</div>

[quote=“JordanCClark”]

EDIT: Dang! Kevin beat me to it! 😆[/quote]  
thanks, you guys