Sage 100

Is there a way to intelligently parse a field in VI? I have the following data: 10102-11 Gladiator 2.8 1:10 Mounted Tires - Stampede 4x4 - 12mm Hex I need to extract the part number, 10102-11. The problem is, it is not always 8 characters. Essentially, I need to find the first space and take everything prior to that. In Excel I would do this: =left(A1,find("" "",A1)-1) Can that be done with the VI toolset?

I think @PhilipWhirley addressed this very recently with a similar question - check back maybe 1-2 weeks in SC

Thanks @WayneSchulz, found the post.

Insert a Temp field and set as Replace from the appropriate column in source file. Then insert ItemCode and make Operation = Calc. For calculation expression: `MID(Temp001$,1,POS("" ""=Temp001$)-1)`

Yup, that's what I got as well from @PhilipWhirley's post. Thanks @AlnoorCassim