Replace "dash" values in a field with new line- VB equivalent of Python

Joel Goldstick joel.goldstick at gmail.com
Tue Mar 19 16:50:34 CET 2013


On Tue, Mar 19, 2013 at 11:36 AM, Cathy James <nambo4jb at gmail.com> wrote:

> Dear All,
> I need some assistance with Python so that values in the "Name" field e.g.
> Murray - James - Leo can be labeled as:
>
> Murray
> James
> Leo
>
> with a new line replacing every dash.
>
> Basically I need the equivalent of this VB in Python:
> replace ( [Name]  , "-", vbNewLine)
>
> I tried this but no luck:
>
> str.[Name].replace("-", "\n")
> str.[Name].replace("-", \n)
> [Name].replace("-", \n")
>
> Your help is appreciated
>
> --
> http://mail.python.org/mailman/listinfo/python-list
>
> Is this what you need:

>>> names = 'Tom - Dick - Harry'
>>> name_list = names.split('-')
>>> name_list
['Tom ', ' Dick ', ' Harry']
>>> name_list = names.split('-')
>>> for n in name_list:
...   print n.strip()
...
Tom
Dick
Harry
>>>



-- 
Joel Goldstick
http://joelgoldstick.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20130319/c14c1f9e/attachment.html>


More information about the Python-list mailing list