General

Re: Last Name, First Name

ZaiZai — Tue, 04 Aug 2009 15:38:08 GMT

It works nicely. I will tinker with it regarding the space issue. Thanks a lot ErnestoM!

Re: Last Name, First Name

ErnestoM — Tue, 04 Aug 2009 10:43:42 GMT

Yes, this is possible. The problem is detecting whether there is a space after the comma. I'm not sure how to handle this if the user doesn't enter that space, but I'll give you the sample and let you play around with it. Good luck.

Re: Last Name, First Name

ZaiZai — Tue, 04 Aug 2009 01:29:24 GMT

ErnestoM,

Thanks for that, it works perfectly!

A follow up question if I may. How would you go about creating emails strings from that same set of data? For example, "Doe, John" to jdoe@gmail.com. The email should have last name which would be proceded by the first letter of the person's first name. If you know a way to write this using the expression features in IP that would be nice.

Thanks.

Re: Last Name, First Name

ErnestoM — Mon, 03 Aug 2009 19:04:01 GMT

Please see attached. :)

Last Name, First Name

ZaiZai — Mon, 03 Aug 2009 18:37:09 GMT

Anyone know of a way to output into an expression "Dear John Doe," if you had a value in a text box from a query in this format, "Doe, John"?

Basically, I need to know how to reverese these two words so without the "," so that I can use it to addess someone formally.

Thanks,