Hi,
I have the below value in a field,
57x40 mm MACHINE TILL CREDIT CARD,PDQ THERMAL PAPER ROLLS CASH REGISTER RECEIPT[2 x Box 20 ( 40 rolls )]
I need to find the number '2' after the [ and accordingly do some looping.
I have tried to use
Dim idx As Integer
idx = InStr(Me.ItemTitle, "[")
If idx > 0 Then
title = MID(Me.ItemTitle, 1, idx - 1)
End If
Could someone provide a better solution pl.
Thanks
I