Is it possible to change the results of each values of a list (using right() or left() for ex.) ?

[baba_sawane]

Hi !

I would like to know if there is a way to do so, it would be a nice trick to avoid a specific error that I get using the desktop mode.

For comprehension, let's say I have values in a table that are like :

value1-data.pdf , value2-data.pdf , value3-data.pdf

And I want to do an enumlist of these data, but don't want the part after the '-', like this :

- value1 , value2 , value3

Is there an expression to do so ?

Thank you for any help.

[Suvrutt_Gurjar · Accepted solution]

You could try 

SPLIT(SUBSTITUTE(LIST("value1-data.pdf" , "value2-data.pdf" , "value3-data.pdf"),"-data.pdf",""),",")

[baba_sawane]

Thank you @Suvrutt_Gurjar and @Steve 

It works perfectly 🤓

[Steve]

If -data.pdf is the literal text, you could use SUBSTITUTE() to remove it:

SUBSTITUTE("-data.pdf", "", "value1-data.pdf , value2-data.pdf , value3-data.pdf")