Post reply

Truncate column with phone number

  • February 15, 2011 at 2:23 am

    #232254

    Hi all,

    I work on a package and I should want truncate a column with Phone number.

    example

    Input : +33049505059500 00 00 00 00

    And in output I want 0495050595.

    For this truncate, I use a "Deriver column" with a Conditionnal.

    For the moment I have this :

    LEN([Data Conversion 1].[Nº de tél. principal]) == 28 ? RIGHT(REVERSE(RIGHT([Data Conversion 1].[Nº de tél. principal],15)),3) : RIGHT([Data Conversion 1].[Nº de tél. principal],10)

    But it doesn't work.

    I don't have a LEFT fonctiun, and I have to play with REVERSE I think.

    Can you help me?

    Thanks

  • February 15, 2011 at 2:25 am

    #1286920

    Use SUBSTRING instead of LEFT to achieve the same thing.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • February 15, 2011 at 2:56 am

    #1286932

    Thank Phil.

    I have already use this function, and I forgot to think at this function

  • February 15, 2011 at 4:49 pm

    #1287384

    mklein2 (2/15/2011)

    Thank Phil.

    I have already use this function, and I forgot to think at this function

    Just remember that a phone number can have no country code or a country code with 1 to 3 characters. Unless you have a country code list to compare to, you may be truncating at the wrong place.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply