dynamic way of replacing

[beck_bakytbek]

Hi Folks,

i got a question, are there any way to replace dynamically, for instance:

Fieldvalue:

1215_A12

Expected Output:

1215A12

I dont know whethere is that possible. Does anybody have any idea?

Thanks a lot in  advance

Beck

[MayilVahanan · Accepted solution]

Hi @beck_bakytbek 

Try like below

Replace(FieldName, '_', '') as FieldName

ex: Replace('1215_A12', '_', '') gives 1215A12

[Taoufiq_Zarra · Accepted solution]

@beck_bakytbek like :

keepchar(Fieldvalue,'0123456789azertyuiopqsdfghjklmwxcvbnAZERTYUIOPQSDFGHJKLMWXCVBN') AS oUTPUTFIELD

?

[beck_bakytbek]

Hello Taoufiq_Zarra,

thanks a lot for your time and help

[beck_bakytbek]

Hello MayilVahanan,

thanks a lot for your time and help