translate

Follow

Aditya Koyyaamudi

• July 02, 2018 16:21

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

0

• Official comment

  

  Sabeel

  • July 02, 2018 18:27

  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.

  Comment actions Permalink
• 

  Aditya Koyyaamudi

  • July 02, 2018 19:08

  Thank you Sabeel! that works.

  0

  Comment actions Permalink

Please sign in to leave a comment.