translate

2 followers
0
Avatar

Hi 

I have column named Address

now i want to apply below logic in datameer . can some one help me with this

upper(translate(ADDRESS, ' ~`!@#$%^&*()_+-={}|[]\:";<>?,./', '')

Aditya Koyyaamudi

Official comment

  • Avatar
    Sabeel

    Hi Aditya,

    Thanks for bringing up this question!

    You could use below function to replace any special character with a null character or no character at all. I used few special characters in my source string for understanding purpose.

     upper(REPLACEALL(#A;'[#|$|^|?|,]'; ''))

    ->(REPLACEALL is the alternative function to translate, Refer this link for more details: https://documentation.datameer.com/documentation/display/DAS70/REPLACEALL)

    You could use as many special characters as you want to be separated by '|' character.

    Example:

    Here is the sample output using the function which I mentioned earlier.

    My source string = "1567 M?a,i#n $^67"

    Output using the fucntion upper(replaceall(<Stirng>;' <special characters>';'<string with replacement>') = "1567 MAIN 67"

     

     

    You can try this function for one of your worksheets and let me know if this works.

    Regards,

    Mohammad Sabeel

    Datameer Inc.

    0
    Comment actions Permalink

2 comments

Please sign in to leave a comment.