# How do I validate the data inside the Column in an Excel File or of an CSV File?

**URL:** <https://community.automationedge.com/t/how-do-i-validate-the-data-inside-the-column-in-an-excel-file-or-of-an-csv-file/11650>\
**Category:** Get Help & Discuss\
**Tags:** rpa, learning, process-studio, ps-steps\
**Created:** [February 28, 2024, 5:31am UTC](https://community.automationedge.com/t/how-do-i-validate-the-data-inside-the-column-in-an-excel-file-or-of-an-csv-file/11650 "2024-02-28T05:31:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![fdc\_jpg](https://avatars.discourse-cdn.com/v4/letter/f/ba8739/32.png) [@fdc\_jpg](https://community.automationedge.com/u/fdc_jpg)\
**Post date:** [February 28, 2024, 5:31am UTC](https://community.automationedge.com/t/how-do-i-validate-the-data-inside-the-column-in-an-excel-file-or-of-an-csv-file/11650/1 "2024-02-28T05:31:45Z")

</div>

I have already configured my CSV File in the plugin/design of “CSV File Input” process in the .psw file and now I do want to validate the column name, for example. in the column roles, I want to extract all employees that has the role of software engineer.

are there any query like syntax here in order to establish it?  
I am relatively new and does have less than a week since started.

any helps will be appreciated.

please refer to the image below.  
 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/1/1adfbd11dcb92a92b6649e802215294b61fff498.png)

---

<div class="post-metadata">

**Author:** ![wllmdjngh](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/wllmdjngh/32/952_2.png) [@wllmdjngh](https://community.automationedge.com/u/wllmdjngh)\
**Post date:** [February 28, 2024, 1:13pm UTC](https://community.automationedge.com/t/how-do-i-validate-the-data-inside-the-column-in-an-excel-file-or-of-an-csv-file/11650/2 "2024-02-28T13:13:17Z")

</div>

Hi @fdc_jpg  
If it is a fixed text you wish to filter out, you may use regex expressions.  
If you do not know how regex works, it could be intimidating at first but is a very powerful mechanism to identify or manipulate particular strings. Lots of information on the web and to try if an expression works, I use site regex101.  
Many plugins you may use REGEX expressions.

---

<div class="post-metadata">

**Author:** ![Jane](https://avatars.discourse-cdn.com/v4/letter/j/ecb155/32.png) [@Jane](https://community.automationedge.com/u/Jane)\
**Post date:** [March 4, 2024, 6:54am UTC](https://community.automationedge.com/t/how-do-i-validate-the-data-inside-the-column-in-an-excel-file-or-of-an-csv-file/11650/3 "2024-03-04T06:54:01Z")

</div>

Hi! Jai,

You can use the Flow and Lookup category steps like Switch Case, Stream Lookup, Filter Rows etc. to design your workflow.