[RESOLVED] ListView

[lag22]

I have the attached result in ListView and would like to separate the words by commas to make them readable. Can code be added to do this and if so where? Thanks for any help.

[MattP]

What commas?

[.paul.]

you could use regex.
do you have a list of the unique (distinct) words that each listviewitem might contain?

also... that looks more like a listbox than a listview

[lag22]

you could use regex.
do you have a list of the unique (distinct) words that each listviewitem might contain?

also... that looks more like a listbox than a listview

It is listview. The words can be any or all of those in the attachment.

[proneal]

Looks like a separation at each Capitol Letter with the exception of Sci-Fi, hence leaving words that have hyphens alone - and treated as one word.

[jcis]

And there is also "Science Fiction" making things even more complicated. Before entering on how to create an AI that splits your words back, may I ask.. why are you adding them concatenated like that to the LV?

[lag22]

And there is also "Science Fiction" making things even more complicated. Before entering on how to create an AI that splits your words back, may I ask.. why are you adding them concatenated like that to the LV?

The info is extracted from an xml file

[.paul.]

can you post your code? there's got to be a simpler way, before you add the items to the listview

[proneal]

can you post your code? there's got to be a simpler way, before you add the items to the listview

I agree. I would not like to see a Listview used in this way anyhow

[lag22]

Here is the code:

code.txt

[proneal]

Can you attach the movie.xml file this program of yours operates with?

[lag22]

Sample movie.xml attached

movie.xml

[.paul.]

try this:

Dim lvi As New ListViewItem(xml.SelectSingleNode("Title/LocalTitle").InnerText)
lvi.SubItems.Add(String.Join(", ", Array.ConvertAll(xml.SelectNodes("Title/Genres/Genre").Cast(Of XmlNode).ToArray, Function(n) n.InnerText)))

[lag22]

try this:

Dim lvi As New ListViewItem(xml.SelectSingleNode("Title/LocalTitle").InnerText)
lvi.SubItems.Add(String.Join(", ", Array.ConvertAll(xml.SelectNodes("Title/Genres/Genre").Cast(Of XmlNode).ToArray, Function(n) n.InnerText)))

Thanks that worked. However when I save to Excel, each Genre is in a separate column. Is there a way to have the same appearance as in listview or would I have to adjust manually?

[.paul.]

the problem is that you're saving your listview contents as excel CSV + the delimiter in a csv file is a comma.

therefore excel sees that 1 field as several. use a semi colon ; instead of a comma:

Dim lvi As New ListViewItem(xml.SelectSingleNode("Title/LocalTitle").InnerText)
lvi.SubItems.Add(String.Join("; ", Array.ConvertAll(xml.SelectNodes("Title/Genres/Genre").Cast(Of XmlNode).ToArray, Function(n) n.InnerText)))

[lag22]

the problem is that you're saving your listview contents as excel CSV + the delimiter in a csv file is a comma.

therefore excel sees that 1 field as several. use a semi colon ; instead of a comma:

Dim lvi As New ListViewItem(xml.SelectSingleNode("Title/LocalTitle").InnerText)
lvi.SubItems.Add(String.Join("; ", Array.ConvertAll(xml.SelectNodes("Title/Genres/Genre").Cast(Of XmlNode).ToArray, Function(n) n.InnerText)))

Thanks. Works. Much appreciated.

[proneal]

rate Paul OP and mark this thread as Resolved, please.
TY

[lag22]

rate Paul OP and mark this thread as Resolved, please.
TY

I hope I did that right.

[proneal]

Well, Sir .Paul has an absolutely brilliant future of Rep points [2000+] -wow..
I am sure you did it right, even though [RESOLVED] does not appear in Thread title.
We will overlook this minor discrepancy...
for now.
mauahhahahaha



good Luck OP!

[.paul.]

I hope I did that right.

you rated me. thanks

[.paul.]

Well, Sir .Paul has an absolutely brilliant future of Rep points [2000+] -wow..
I am sure you did it right, even though [RESOLVED] does not appear in Thread title.
We will overlook this minor discrepancy...
for now.
mauahhahahaha



good Luck OP!

+ counting. thanks for that. i owe you a rating next time you post a good answer...

[lag22]

What is the correct way to mark Resolved?

[.paul.]

at the top right of your original question, there's a Thread Tools menu, which contains a Mark Thread Resolved menuitem

[lag22]

at the top right of your original question, there's a Thread Tools menu, which contains a Mark Thread Resolved menuitem

Thanks