RUA Volunteer2?
asked on
Crystal Reports retreiving specific characters from a stringvar array?
I have a formula that works perfect for finding a value in a string field. How can I expand on that
and actually pull and print out either a value of "ft" or "in" . Currently the formula pulls out everything like "12 ft" or "24 in" I need to use this formula in some capacity then expand on it.
local stringvar array strArray := split({InvoiceLine.Invoice LineDesc}, ",");
if ubound(strArray) >= 5
then trim(strArray[5])
else ""
how can I do that?
and actually pull and print out either a value of "ft" or "in" . Currently the formula pulls out everything like "12 ft" or "24 in" I need to use this formula in some capacity then expand on it.
local stringvar array strArray := split({InvoiceLine.Invoice
if ubound(strArray) >= 5
then trim(strArray[5])
else ""
how can I do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am sorry gentlemen I really am trying to get better about creating a question. never was that good at Jeopardy. My brother was. Seems that gene missed me altogether. I understood the formula that I had at the top given by an EE member. I was trying to have it look at the value created by my formula at top and have it pluck out the value if the unit of measure was in "inches =in" or in "feet = ft". I was not sure how to do that. Thanks for the input.
mlmcc