S
SJW_OST
I am using the following formula in my Query.
Correct: Left$([List Name],InStrRev([List Name],"_")-1)
I am using this formula to convert some data to the following;
"aaaa_hi_e_28" converts to "aaaa_hi_e" or
"aaaa_e_28" converts to "aaaa_e" or
"aaaa_hi_e_0528" converts to "aaaa_hi_e"
But, if I have some data that does not have an underscore & "date" at the
end, like D86547, I get #Error. How do I change the formula to just use the
original name if #Error occurs?
Thank you in advance.
Correct: Left$([List Name],InStrRev([List Name],"_")-1)
I am using this formula to convert some data to the following;
"aaaa_hi_e_28" converts to "aaaa_hi_e" or
"aaaa_e_28" converts to "aaaa_e" or
"aaaa_hi_e_0528" converts to "aaaa_hi_e"
But, if I have some data that does not have an underscore & "date" at the
end, like D86547, I get #Error. How do I change the formula to just use the
original name if #Error occurs?
Thank you in advance.