Forum Discussion
Solved
Parsing excel strings with variable delimiters and variable lengths
I have large excel files with one column that I need to parse out specific words that are delimited with 3 different delimiters that are defined but are variable on 2 of them. The cells of the colum...
- I found my error. R was set as LONG, should have been string. My error in typing, not yours.
Now it works great!
Thanks a ton! I owe you one!
Ok, that I did not know!
I inserted and now when I call the function is does show up in the autocomplete, but it now throws the #VALUE! error.
=extractit(E5)
I inserted and now when I call the function is does show up in the autocomplete, but it now throws the #VALUE! error.
=extractit(E5)
I found my error. R was set as LONG, should have been string. My error in typing, not yours.
Now it works great!
Thanks a ton! I owe you one!
Now it works great!
Thanks a ton! I owe you one!