Free Trial

Foro

Replace function in databace

FMALLEA
Átomo

I need to replace "-" in a column.

I am working indatabase, so i am using formula tool, but it not works.

 

Replace([RUT],"-","")

 

 

There is another way to replace? 

4 RESPUESTAS 4
carlosteixeira
15 - Aurora
15 - Aurora

Hola @FMALLEA 

What's your database? Oracle or SQL?

You need to use the sintaxe of your database.

 

For example Oracle

SELECT REPLACE('JACK and JUE','J','BL') "Changes"
     FROM DUAL;

 

SQL 

SELECT REPLACE('abcdefghicde','cde','xxx'); GO

Carlos A Teixeira
FMALLEA
Átomo

sql..

but still not work

carlosteixeira
15 - Aurora
15 - Aurora

Can you share with us any images to analyze?
Are you get any error?

Carlos A Teixeira
FláviaB
Alteryx Community Team
Alteryx Community Team

Hola @FMALLEA. ¿Lograste resolver tu problema o aún necesitas ayuda?

Flávia Brancato
Etiquetas