I have split an OCRtext with SPLIT into a LIST
Column name: Split Vin Info
SPLIT([Vin Information], "
I then have created multiple references to the list with
Column name example: Split 9
**FORMULA:**INDEX([Split Vin info], 9)
I have a specific word within a the original text that has 17 characters, so i used these breakouts to check which one of these index’es has 17 characters to use that word.
FInal Formula below for the text that should contain 17 characters
Column name is: “Vin Number Split” and formula is below. It says the formula looks right but i am doing something wrong?
LEN([Split 7]) = 17, [Split 7],
LEN([Split 8]) = 17, [Split 8],
LEN([Split 9]) = 17, [Split 9],
LEN([Split 10]) = 17, [Split 10] ,
Is there another way to extract the word that has a character count of 17 within a large text string?