initial output :
C76_XX_XXXX_INVOICE_LIV_XXXX_XXX.001.pdf
what i would like :
C76_XX_XXXX_INVOICE_LIV_XXXX_XXX_001.pdf
Thanks for your help
Solved
Hello guys,I have a varchar column in my database and i would like to replace the 7th character (starting by the end) from a . to a _ I try to use the function LEN but its not working... error message :ERROR: Function LEN(varchar) does not exist
Best answer by guillermo.gost12
LENGTH and CHARACTER_LENGTH are implemented in SQL Vertica in Celonis
RIGHT, LEFT and CONCAT works. I gues you want something similar to:
select COLUMN, LENGTH(COLUMN), LEFT(COLUMN,3), RIGHT(COLUMN,6), CONCAT(CONCAT(LEFT(COLUMN,3),'A'),RIGHT(COLUMN,6)) AS MiddleCharChanged from "TABLE"
HTH
LENGTH and CHARACTER_LENGTH are implemented in SQL Vertica in Celonis
RIGHT, LEFT and CONCAT works. I gues you want something similar to:
select COLUMN, LENGTH(COLUMN), LEFT(COLUMN,3), RIGHT(COLUMN,6), CONCAT(CONCAT(LEFT(COLUMN,3),'A'),RIGHT(COLUMN,6)) AS MiddleCharChanged from "TABLE"
HTH
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.