Hi,
I have a formula in Excel that looks up the nth string after the comma.
@Itm1 is the source data containing the strings and @Itm3 is the nth string to return.
is it possible to get this working in Access?
I have a formula in Excel that looks up the nth string after the comma.
Code:
=TRIM(MID([@Itm1],FIND("#",SUBSTITUTE([@Itm1],",","#",[@Itm3]))+1,255))
@Itm1 is the source data containing the strings and @Itm3 is the nth string to return.
Code:
Example string:
@Itm1:
690-10090,690-10090-A,619-6240,608-0319,659-0126,A860-0006-CUBB,860-0006,,,
@Itm3:
6
Would return 860-0006
is it possible to get this working in Access?