[SOLVED] Zenity List Command

[Simon]

Hello people. I am trying to get a Zenity command to do something, I am almost certain this is possible. I want it to read in the list from a csv file.

#!/bin/bash
# Replace CRLF with commas
file=$(cat test.csv| tr , '\n')
# Fill Array
item=($file)
zenity --list --title="Zenity List" --width=640 --height=480 --column="Name" --column="Phone" --column="Address" "${item[@]}"

When I tried separator="," or separator=, it still separates the fields on space. What am I not seeing here?

[oshunluvr]

Can you give an example of input and output desired? Might be another way to skin the cat, like setting IFS instead of stripping CRLF

[oshunluvr]

Or maybe just separator=', '

[Simon]

Most CSV file formats are commonly separated with commas;

Simon Tomoko,1234578,909 My Street
Jane Doe,private,behind the Chinese Steakhouse 
Michael A. John,999,April Street

At the end they use the CRLF to separate the rows. Zenity hard coded would be this;

#!/bin/bash
zenity --list --title="Zenity List" --width=640 --height=480 --column="Name" --column="Phone" --column="Address"  "Simon Tomoko" "1234578" "909 My Street" "Jane Doe" "private" "behind the Chinese Steakhouse" "Michael A. John" "999" "April Street"

--update--
Upon further study my line to replace the end of line is somewhat botched. Also I guess I should be converting the file string variable from this:

Simon Tomoko,1234578,909 My Street
Jane Doe,private,behind the Chinese Steakhouse 
Michael A. John,999,April Street

to this:

"Simon Tomoko" "1234578" "909 My Street" "Jane Doe" "private" "behind the Chinese Steakhouse" "Michael A. John" "999" "April Street"

I have done some searching and still I am not finding method.
I can do the reverse very easy:

zenity --forms --title "Zenity Form" --separator="," --add-entry=Name --add-entry="User ID" --add-password=Password >> password.csv

[andystmartin]

The problems is not in Zenity, it is in the creating of the array:

# save old IFS
oldifs=$IFS
# fields defined by comma and newline
IFS=',
'
item=($(cat file.csv))
# restore IFS
IFS=$oldifs
echo ${item[0]}

this should show the correct first field.

[Simon]

Thanks! This is the the way I implemented it;

#!/bin/bash
#
oldifs=$IFS
IFS=','
item=($(cat file.csv|tr '\n' ','))
IFS=$oldifs
zenity --list --title="Zenity List" --width=640 --height=480 --column="Name" --column="Phone" --column="Adress"  "${item[@]}"