Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ksh script to add multiple lines to csv cell formatting help

Status
Not open for further replies.

grazinggoat2

Systems Engineer
Jun 25, 2019
6
US
Hello -

I'm using a shell script to create a CSV file to load the data into JIRA.
I've searched the net but can find how a .csv cell needs to be formated to handle multilines from a grep output.

I'm grepping for entries from a file and it may return 1 line or 10 or more. I'd like to get say

grep birds inputfile
eagle
crow
dove
blue jay


added into the description field. Anyone have experience with how this can be generated?

Code:
print "EPICKLINK,Summary,[b]Description[/b],Reporter,Assignee,Issue Type,Status,Labels,Labels2" > test.csv
FOUND_JOB_ENTRY=$( grep -hw "${job}" searchfile | awk '{print}' ORS='\' )
print "EPIC-007,${job} has no deployment found,"${FOUND_JOB_ENTRY}",uid,uid,Task,Open,testlabel,testlabel2" >> test.csv

the description cell should basically be,eagle\crow\dove\blue jay, I assume i need to add \n or \r so each bird found is on a single line in the cell,
but don't know how to accomplish this after many attempts

Thanx for any insight!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top