Help

Count Words and export only a specific amout of them

Topic Labels: ImportingExporting
653 0
cancel
Showing results for 
Search instead for 
Did you mean: 
airtableManuel
6 - Interface Innovator
6 - Interface Innovator

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?

0 Replies 0