Replace many data with other text

[oscargm_bi]

Hi all,

I need to erase the "v.1, v.2, v.3, etc..." of all the registers that I have in the Column Garantia. Im triying to use replace function, but only works with one argument:

Example:  Replace(Garantia,'EUROSCHENGEN v.8','EUROSCHENGEN') as garantia2,

How can I replace all the registers that contains v.1, v.2, v.3 for a space? 

Thank u.

[bharathadde]

try this

Left(Garantia, index(Garantia,' ',1)-1) as  garantia2

[oscargm_bi]

Thanks a lot !!

It works, but if u see the imagen attached with that formule delete me the "30 , 60 and 90" of that contracts, can you think of something to fix it?

[JGMDataAnalysis · Accepted solution]

SubField(Garantia, ' v.', 1) AS Garantia1

[oscargm_bi]

Thanks!!!!! 🙂

[oscargm_bi]

thanks!! 🙂