# when I feed csv file ,It has a error say"not found value,How can I do?

**URL:** <https://community.gatling.io/t/when-i-feed-csv-file-it-has-a-error-say-not-found-value-how-can-i-do/5745>\
**Category:** Gatling (Open-Source)\
**Created:** [August 4, 2020, 3:37am UTC](https://community.gatling.io/t/when-i-feed-csv-file-it-has-a-error-say-not-found-value-how-can-i-do/5745 "2020-08-04T03:37:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yingjie\_Guan](https://avatars.discourse-cdn.com/v4/letter/y/9d8465/32.png) [@Yingjie\_Guan](https://community.gatling.io/u/Yingjie_Guan)\
**Post date:** [August 4, 2020, 3:37am UTC](https://community.gatling.io/t/when-i-feed-csv-file-it-has-a-error-say-not-found-value-how-can-i-do/5745/1 "2020-08-04T03:37:50Z")

</div>

I write a login script through using account.csv  
the account csv like this

 ![屏幕快照 2020-08-04 上午11.34.28.png](https://europe1.discourse-cdn.com/flex013/uploads/gatling2/original/1X/05f479d42ebe255c3be34bea5c23d05450336715.png)  
and I feed this account.csv in script  
 ![屏幕快照 2020-08-04 上午11.35.40.png](https://europe1.discourse-cdn.com/flex013/uploads/gatling2/original/1X/52325e7b2dad66f95ce84a92426a817e186a37d8.png)

you can see the username and password is red , then I run the simulation , the error say not found value username ,  
I don’t know how to fix the problem , help me please,  
the account.csv is in resources folder

---

<div class="post-metadata">

**Author:** ![slandelle](https://dub1.discourse-cdn.com/flex013/user_avatar/community.gatling.io/slandelle/32/4_2.png) [@slandelle](https://community.gatling.io/u/slandelle)\
**Post date:** [August 4, 2020, 6:44am UTC](https://community.gatling.io/t/when-i-feed-csv-file-it-has-a-error-say-not-found-value-how-can-i-do/5745/2 "2020-08-04T06:44:58Z")

</div>

[https://gatling.io/docs/current/session/expression\_el/](https://gatling.io/docs/current/session/expression_el/)

Warning

By default, IntelliJ will automatically prepend your String with an `s` as soon as you start typing `${` because it thinks you want to use [Scala’s String interpolation](https://docs.scala-lang.org/overviews/core/string-interpolation.html). You need to remove this `s` to use Gatling EL.

---

<div class="post-metadata">

**Author:** ![Nalin\_A](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@Nalin\_A](https://community.gatling.io/u/Nalin_A)\
**Post date:** [August 6, 2020, 7:35am UTC](https://community.gatling.io/t/when-i-feed-csv-file-it-has-a-error-say-not-found-value-how-can-i-do/5745/3 "2020-08-06T07:35:46Z")

</div>

**slandelle -** In the screenshot I did not find extra s.  
but I can see as ${userName}

---

<div class="post-metadata">

**Author:** ![slandelle](https://dub1.discourse-cdn.com/flex013/user_avatar/community.gatling.io/slandelle/32/4_2.png) [@slandelle](https://community.gatling.io/u/slandelle)\
**Post date:** [August 6, 2020, 7:55am UTC](https://community.gatling.io/t/when-i-feed-csv-file-it-has-a-error-say-not-found-value-how-can-i-do/5745/4 "2020-08-06T07:55:19Z")

</div>

s"""

---

<div class="post-metadata">

**Author:** ![Nalin\_A](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@Nalin\_A](https://community.gatling.io/u/Nalin_A)\
**Post date:** [August 6, 2020, 8:34am UTC](https://community.gatling.io/t/when-i-feed-csv-file-it-has-a-error-say-not-found-value-how-can-i-do/5745/5 "2020-08-06T08:34:58Z")

</div>

Superb observation 🙂  
Thanks.

---

<div class="post-metadata">

**Author:** ![Yingjie\_Guan](https://avatars.discourse-cdn.com/v4/letter/y/9d8465/32.png) [@Yingjie\_Guan](https://community.gatling.io/u/Yingjie_Guan)\
**Post date:** [August 6, 2020, 12:20pm UTC](https://community.gatling.io/t/when-i-feed-csv-file-it-has-a-error-say-not-found-value-how-can-i-do/5745/6 "2020-08-06T12:20:29Z")

</div>

Thank you ,I fixed it through change the asJSON method to stripMargin like it and I still need delete the ‘s’  
then it work

 ![屏幕快照 2020-08-06 下午8.19.28.png](https://europe1.discourse-cdn.com/flex013/uploads/gatling2/original/1X/e4873250202408a3391f2317c9b6b0954c34160f.png)