# Using AWK on CSV file using function node

**URL:** <https://discourse.nodered.org/t/using-awk-on-csv-file-using-function-node/47251>\
**Category:** General\
**Created:** [16 June 2021 14:57 UTC](https://discourse.nodered.org/t/using-awk-on-csv-file-using-function-node/47251 "2021-06-16T14:57:55Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [16 June 2021 17:34 UTC](https://discourse.nodered.org/t/using-awk-on-csv-file-using-function-node/47251/2 "2021-06-16T17:34:59Z")

</div>

Here is a recent example of joining two csv files, can not help more as you supplied no examples of your csv files.

> [@Merging 2 csv LEFT JOIN](https://discourse.nodered.org/t/merging-2-csv-left-join/46663/11):
>
> If the csvs are not same items then search for matching keys e.g. $map(csv1, function($v,$i){ $merge([$v, $$.payload[Item = $v.Item]]) }) here is testing flow, as i have no files i created cvs's with template nodes. [{"id":"bdbf843d.9a2268","type":"inject","z":"c74669a0.6a34f8","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":110,"y":4020,"wires":[["e4bc4684.bce58"]]},{"id":"e…

---

_[View the full topic](https://discourse.nodered.org/t/using-awk-on-csv-file-using-function-node/47251)._