extracting positive values

[ABC_Anonymous]

Hello

I wanted to share a little exercise with you!
In fact, I'll need to start from the field column and extract the first value greater than 0 if it exists, otherwise 0.

ID	Field	output
xxxxxxxxxxxxx	0,1,3,4,10	1
yyyyyyyyyyyyy	0,0,0,0,0	0
zzzzzzzzzzzzzzz	3,5,9,10	3

Thanks for your support

[alexnajm · Accepted solution]

Done!

[ABC_Anonymous]

I found this solution : 

IF isEmpty(REGEX_Replace([Field], "0|,| ","")) THEN '0'
ELSE
left(Replace([Field], '0,', ''),1)
ENDIF