ksh script to add multiple lines to csv cell formatting help
ksh script to add multiple lines to csv cell formatting help
(OP)
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?
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!
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 --> script
print "EPICKLINK,Summary,Description,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!
Talk To Other Members