awk to convert CSV into colums


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers awk to convert CSV into colums
# 1  
awk to convert CSV into colums

My file (FILE1) looks like this:
Code:
HiringManager_RHMC, DirectSupervisor_RHMC, ProcessServerReadAccess_ST

I'd like to turn into:
Code:
HiringManager_RHMC
DirectSupervisor_RHMC
ProcessServerReadAccess_ST

I tried awk -F, '{print $1 $3}' FILE1
and result as this:
Code:
HiringManager_RHMC ProcessServerReadAccess_ST

Thank you in advance!
Moderator's Comments:
Mod Comment
Please use code tags when posting data and code samples!

Last edited by vgersh99; 02-19-2020 at 12:42 PM.. Reason: code tags, please!
# 2  
Hi,

If you're wanting to print the separate fields of a CSV out one per line, then something like this would work:

Code:
$ cat test.csv
HiringManager_RHMC,DirectSupervisor_RHMC,ProcessServerReadAccess_ST
$ awk -F, '{print $1"\n"$2"\n"$3}' < test.csv      
HiringManager_RHMC
DirectSupervisor_RHMC
ProcessServerReadAccess_ST
$

Hope this helps - if it doesn't quite work for you then if you can let us know what doesn't work I'm sure we can help further.
This User Gave Thanks to drysdalk For This Post:
# 3  
Code:
echo 'HiringManager_RHMC, DirectSupervisor_RHMC, ProcessServerReadAccess_ST' | awk -F, '$1=$1' OFS='\n'

This User Gave Thanks to vgersh99 For This Post:
# 4  
Not sure this works with all tr versions:


Code:
echo "HiringManager_RHMC, DirectSupervisor_RHMC, ProcessServerReadAccess_ST" | tr -s ', ' '\n'
HiringManager_RHMC
DirectSupervisor_RHMC
ProcessServerReadAccess_ST


Code:
tr --version
tr (GNU coreutils) 8.30

These 2 Users Gave Thanks to RudiC For This Post:
# 5  
All 3 resolutions worked for me perfectly. Thank you so much. you guys never fail to help out. Thanks again!
# 6  
Quote:
Originally Posted by RudiC
Not sure this works with all tr versions:


Code:
echo "HiringManager_RHMC, DirectSupervisor_RHMC, ProcessServerReadAccess_ST" | tr -s ', ' '\n'
HiringManager_RHMC
DirectSupervisor_RHMC
ProcessServerReadAccess_ST

Code:
tr --version
tr (GNU coreutils) 8.30

Does not work with all tr versions, because each character,range,class in arg1 should match a character,range,class in arg2.
The following is portable:
Code:
echo "HiringManager_RHMC, DirectSupervisor_RHMC, ProcessServerReadAccess_ST" | tr -s ', ' '\n\n'

The tr substitutes each space or comma, regardless where they occur.
The following sed script takes a ", " (two character) delimiter; a single comma or space remains.
Code:
echo "HiringManager RHMC, DirectSupervisor RHMC, Process,ServerReadAccess_ST" | sed 's/, /\
/g'
HiringManager RHMC
DirectSupervisor RHMC
Process,ServerReadAccess_ST

GNU sed takes \n in the substitution string, so you can do
Code:
echo "HiringManager RHMC, DirectSupervisor RHMC, Process,ServerReadAccess_ST" | sed 's/, /\n/g'

Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #434
Difficulty: Medium
jQuery is a vanilla JavaScript library designed to simplify DOM-oriented client-side HTML scripting along with offering cross-browser compatibility.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

awk on multiple colums

HI, I need to filter my data based on 3 different columns. Two of the columns are unique so it worked if u use something like grep 'PASS.*HIGH|HIGH.*PASS' file.tsv However the other column is not unique .. So basically I want to extract out lines that match only match these 3... (4 Replies)
Discussion started by: janshamsani
4 Replies

2. Shell Programming and Scripting

Convert XML to CSV using awk or shell script

Hello, I am working on a part of code where I need a awk or shell script to convert the given XML file to CSV or TXT file. There are multiple xml files and of different structure, so a single script is required for converting data. I did find a lot of solutions in the forum but... (16 Replies)
Discussion started by: Rashmitha
16 Replies

3. Shell Programming and Scripting

Awk to convert a text file to CSV file with some string manipulation

Hi , I have a simple text file with contents as below: 12345678900 971,76 4234560890 22345678900 5971,72 5234560990 32345678900 71,12 6234560190 the new csv-file should be like: Column1;Column2;Column3;Column4;Column5 123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies

4. Shell Programming and Scripting

Help on convert rows to colums

Need help to convert the following data Account name: admin Role: admin Description: Administrator Enabled: Yes to Account Name Role Description Enabled admin admin Administrator Yes Perl or AWK? Thanks San (9 Replies)
Discussion started by: sanguy
9 Replies

5. Solaris

awk - Print variable number of colums from a starting column

Hi guys, I usualy am able to google awk stuff but I can't find it so far and there are so many awking gurus here that I will give it a shot. I want to print $1;$3;"$5 up to the $NF". In other words, I can have 1000 colums, but need to have $5 up to the end. I started with the idea of... (2 Replies)
Discussion started by: plmachiavel
2 Replies

6. Shell Programming and Scripting

awk convert xml to csv

Hi, I have an xml file and I want to convert it with awk in to a csv file Test.xml <Worksheet ss:Name="Map1"> <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="2" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="60"> <Row> <Cell><Data... (6 Replies)
Discussion started by: research3
6 Replies

7. Programming

awk script to convert a text file into csv format

hi...... thanks for allowing me to start a discussion i am collecting usb usage details of all users and convert it into csv files so that i can export it into some database.. the input text file is as follows:- USB History Dump by nabiy (c)2008 (1) --- Kingston DataTraveler 130 USB... (2 Replies)
Discussion started by: certteam
2 Replies

8. Shell Programming and Scripting

Awk script to convert csv to html

Hi Written some script to convert csv to html but could not add table headers.Below are the errors iam getting ./csv2html | more + awk -v border=1 -v width=10 -v bgcolor=black -v fgcolor=white BEGIN { printf("<table border=\"%d\" bordercolor=\"%s\" width=\"%d\"... (2 Replies)
Discussion started by: zeebala1981
2 Replies

9. Shell Programming and Scripting

Compare two csv files by two colums and create third file combining data from them.

I've got two large csv text table files with different number of columns each. I have to compare them based on first two columns and create resulting file that would in case of matched first two columns include all values from first one and all values (except first two colums) from second one. I... (5 Replies)
Discussion started by: agb2008
5 Replies

10. Shell Programming and Scripting

convert this into csv using awk/shell script

Hi Scripting gurus, I need to convert following text snippet into csv. please help Input heading1 = data1 heading2 = data2 .. .. heading n = data n heading 1 = data1 .. .. Output data1,data2,....,data n (3 Replies)
Discussion started by: azs0309
3 Replies

Featured Tech Videos