Remove vowels from the string

[Kuroshi]

Hi, is it possible to remove the vowels from the string? For example, my field name contains 'Kuroshi', it should be returned as Krsh. Is that possible? Do you have any articles for this or a sample formula that I can refer to?

Thanks,

Kuroshi

[Barbie]

Hello there @Kuroshi,

 

I believe they have this article called Function reference which includes all the function that you can use in a formula. Here it is: https://howto.caspio.com/function-reference/. You can check the replace function as this can achieve your current workflow. Here's the formula:
 

replace(replace(replace(replace(replace([@field:Name],'a',''),'e',''),'i',''),'o',''),'u','')

You can change the field Name, by the way.

 

Hope this works. 

 

- Barbie

[ParkLoey]

Hi! Just wanted to add Caspio's function reference article where they have a sample of the function, REPLACE, which is used above.

https://howto.caspio.com/function-reference/