Test example:
i have
1,2,3,4,5,6,7,8,10… (a random words they are seperate with the ,)
I count the phrases between the , with the follow code:
IF({Tags},
IF(LEN({Tags}) - LEN(SUBSTITUTE({Tags}, ‘,’, ‘’))>14, ‘ :x: ’
& (LEN({Tags}) - LEN(SUBSTITUTE({Tags}, ‘,’, ‘’)) + 1)&’ /15’, ' :white_check_mark: ’
& (LEN({Tags}) - LEN(SUBSTITUTE({Tags}, ‘,’, ‘’)) + 1)))
But now i need to export only the first 10 words from 15 in the table into another field?
How can i do this?