Hi All I have requirement to get the values between square brackets iam achieving it with the help of extract function but when i was trying to insert the brackets after entering value and if my text value has uneven number of brackets it is erroring out
can you suggest is their any other alternate way to achieve this
Discussion posts and replies are publicly visible
extract()
Returns the value (or values, if the text contains multiple delimited values) between the delimiters from the given text.
extract( "name: Bob, name: Karen, name: Sam", ":", "," )
not sure what the point of this is - this doesn't have much to do with the error the user describes.
May be it make sense to the other person on how the exact() function works, because the the original post and subject mentions about extract() function.
nice try...
Your work is truly appreciated around the clock and globally. It is a comprehensive and useful blog Lolbeans