# awk: Transpose csv row to column.

**URL:** <https://community.unix.com/t/awk-transpose-csv-row-to-column/296486>\
**Category:** Shell Programming and Scripting\
**Created:** [October 3, 2011, 8:13am UTC](https://community.unix.com/t/awk-transpose-csv-row-to-column/296486 "2011-10-03T08:13:26Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![drbiloukos](https://community.unix.com/user_avatar/community.unix.com/drbiloukos/32/6297_2.png) [@drbiloukos](https://community.unix.com/u/drbiloukos)\
**Post date:** [October 3, 2011, 8:13am UTC](https://community.unix.com/t/awk-transpose-csv-row-to-column/296486/1 "2011-10-03T08:13:26Z")

</div>

Hello,  
am I new to awk, and I am tryint to:

INPUT FILE:

```nohighlight
"73423555","73423556","73423557","73423558","73423559"

```

OUTPUT FILE:

```nohighlight
73423555
73423556
73423557
73423558
73423559

```

My useless code so far:

```nohighlight
#!/bin/awk -F ','
BEGIN
{
i=0;
}
{
for (i=1, i<=NF, i++)
print $i
}
{
}

```

Any help much appreciated.

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![jayan\_jay](https://community.unix.com/user_avatar/community.unix.com/jayan_jay/32/1006_2.png) [@jayan\_jay](https://community.unix.com/u/jayan_jay)\
**Post date:** [October 3, 2011, 8:18am UTC](https://community.unix.com/t/awk-transpose-csv-row-to-column/296486/2 "2011-10-03T08:18:27Z")

</div>

```nohighlight
$ sed 's,"\,",|,g;s,^",,g;s,"$,,g' infile | tr '|' '\n'
73423555
73423556
73423557
73423558
73423559

```

---

<div class="post-metadata">

**Author:** ![ieth0](https://community.unix.com/user_avatar/community.unix.com/ieth0/32/7377_2.png) [@ieth0](https://community.unix.com/u/ieth0)\
**Post date:** [October 3, 2011, 8:27am UTC](https://community.unix.com/t/awk-transpose-csv-row-to-column/296486/3 "2011-10-03T08:27:30Z")

</div>

with awk:

```nohighlight
awk -F',' 'BEGIN {i=0} {for (i=1;i<=NF;i++) print $i}' INPUTFILE |tr -d '"'

```

---

<div class="post-metadata">

**Author:** ![jayan\_jay](https://community.unix.com/user_avatar/community.unix.com/jayan_jay/32/1006_2.png) [@jayan\_jay](https://community.unix.com/u/jayan_jay)\
**Post date:** [October 3, 2011, 8:31am UTC](https://community.unix.com/t/awk-transpose-csv-row-to-column/296486/4 "2011-10-03T08:31:01Z")

</div>

one more ..

```nohighlight
$ tr -s ',' '\n' < infile | tr -d '"'

```

---

<div class="post-metadata">

**Author:** ![gowtham.varma](https://community.unix.com/letter_avatar/gowtham.varma/32/6_449c533f586939b6e5f246632a46421f.png) [@gowtham.varma](https://community.unix.com/u/gowtham.varma)\
**Post date:** [October 3, 2011, 8:36am UTC](https://community.unix.com/t/awk-transpose-csv-row-to-column/296486/5 "2011-10-03T08:36:36Z")

</div>

> [@](#):
>
> tr '" ', ' \n' \< infile

---

<div class="post-metadata">

**Author:** ![agn](https://community.unix.com/letter_avatar/agn/32/6_449c533f586939b6e5f246632a46421f.png) [@agn](https://community.unix.com/u/agn)\
**Post date:** [October 3, 2011, 8:48am UTC](https://community.unix.com/t/awk-transpose-csv-row-to-column/296486/6 "2011-10-03T08:48:18Z")

</div>

```nohighlight
[~]> echo "73423555","73423556","73423557","73423558","73423559" | awk 'BEGIN { RS="," }1'
73423555
73423556
73423557
73423558
73423559

```

---

<div class="post-metadata">

**Author:** ![ltomuno](https://community.unix.com/letter_avatar/ltomuno/32/6_449c533f586939b6e5f246632a46421f.png) [@ltomuno](https://community.unix.com/u/ltomuno)\
**Post date:** [October 3, 2011, 9:00am UTC](https://community.unix.com/t/awk-transpose-csv-row-to-column/296486/7 "2011-10-03T09:00:05Z")

</div>

```nohighlight
sed -n 's/"\|","/\n/gp' input

```

---

<div class="post-metadata">

**Author:** ![drbiloukos](https://community.unix.com/user_avatar/community.unix.com/drbiloukos/32/6297_2.png) [@drbiloukos](https://community.unix.com/u/drbiloukos)\
**Post date:** [October 3, 2011, 9:01am UTC](https://community.unix.com/t/awk-transpose-csv-row-to-column/296486/8 "2011-10-03T09:01:52Z")

</div>

Thank you all for your answers

---

<div class="post-metadata">

**Author:** ![getmmg](https://community.unix.com/letter_avatar/getmmg/32/6_449c533f586939b6e5f246632a46421f.png) [@getmmg](https://community.unix.com/u/getmmg)\
**Post date:** [October 4, 2011, 5:02am UTC](https://community.unix.com/t/awk-transpose-csv-row-to-column/296486/9 "2011-10-04T05:02:03Z")

</div>

```nohighlight
 
perl -pe 's/\"//g;s/,/\n/g' input.

```
