split characters

[msasan1367]

how to split characters:


example: my expression is
2+12*1+10

I want split this and put it to 4 text field
field1: 2
field2: 12
field3: 1
field4: 10

[June7]

This is a value in a table field? Are all values in this same structure - the same math operators in same position and same number of terms? Consistency is critical when parsing strings. Assuming yes to all:

x represents the field

Val(x) = 2

Val(Mid(x, InStr(x,"+")+1)) = 12

Val(Mid(x,(InStr(x,"*")+1))) = 1

Mid(x,InStrRev(x,"+")+1) = 10

[msasan1367]

how about this string:
2φ14+1φ16

field1:2
field2:14
field3:1
field4:16

[June7]

Looks like Greek lower case phi.

Can use ASCII character codes with Chr() function in place of actual characters. As example, for the + sign:

Val(Mid(x, InStr(x,Chr(43))+1))

However, phi is not in the ASCII character set.

Sorry, don't know how to work with Greek characters, only English.