Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

SSRS or MS SQL Irish Names case conversion

  • 10-03-2014 01:05PM
    #1
    kidneyfan
    Banned (with Prison Access) Posts: 1,279 ✭✭✭


    Hi Guys,

    This question is completely arcane and I am just tossing it out there.

    My problem is that I work with a data source that stores names in the format
    Firstname (ALL CAPS) Surname (ALL CAPS).

    In SSRS I have the expression =StrConv(Fields!Firstname.Value,3) &" "& StrConv(Fields!Surname.Value,3)

    Great stuff as SEAN KIDNEYFAN now becomes Sean Kidneyfan and MARY KIDNEYFAN becomes Mary Kidneyfan.

    BUT

    MARY O'KIDNEYFAN is now Mary O'kidneyfan
    SEAN MCKIDNEYFAN is now Sean Mckidneyfan

    I can control the data and replace the names O'KIDNEYFAN with O' KIDNEYFAN etc. but I'd prefer not to do that.

    Thanks in advance?


Comments

  • #2
    CreepingDeath
    Closed Accounts Posts: 8,015 ✭✭✭CreepingDeath


    Can you use regular expressions ?


  • #3
    kidneyfan
    Banned (with Prison Access) Posts: 1,279 ✭✭✭kidneyfan


    The application supports regular expressions.
    So far as my ability to use them is concerned ...


    What I did in the end was to =StrConv(Replace(Fields!SurName.Value,”'”, "' "),3) Buried in all those double quotes is an apostrophe replaced with apostrophe space. The string conversion works fine.


Advertisement