Sage 100

Need help with Visual Integrator functions in v4.50, please: is there a way to use POS() or another function to take the left [x] and right [x] characters of a text string?

There is a Mid command. It can be used with positive and negative numbers to indicate from the right or left with providex.

I recently had a situation where the source file had both the department and employee number in one field. I was able to use a Temp field to bring in the field, and then use MID({TEMP01},1,2) for the Dept #, and MID({TEMP01},3,7) for the Emp #.

Mid(string$,1,2) can work -though it's not in the functions list,

Thanks, everyone. I should've tried MID even if I didn't see it as an available option. And Larry, your advice for using the negative numbers is invaluable - thank you!!

This is an old PDF but I am sure the functions are still the same. I have found it very useful in figuring out the ""hidden"" functions that can be used in VI.

Good resource as well...http://manual.pvxplus.com/

Fantastic guides!