VB Script to break out comma delimited list

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

VB Script to break out comma delimited list

Author

Topic

waxdart23
Starting Member

33 Posts

Posted - 2010-05-11 : 04:39:28

I am trying to write a custom vb function to take a comma separated list and break it out into rows
e.g.
"John,Bill,Mary"

would become

John
Bill
Mary

I guess I want to replace the comma with VbCrLf and I want to use this in a tool tip for an existing field where I would put something like:
=Code.CustomFunction(Fields!names.Value)

Thanks
Paul

Thanks
P

waxdart23
Starting Member

33 Posts

Posted - 2010-05-11 : 05:18:47

Turns out I didn't need a function I just used the standard replace function to change , to VbCrLf. Duh!

Thanks
P

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-05-11 : 09:02:51

quote:
Originally posted by waxdart23

Turns out I didn't need a function I just used the standard replace function to change , to VbCrLf. Duh!

Thanks
P

Thats my favourite way too
I used this type of approach in Crystal Reports

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources