Manipulate Text: Left, right and mid text calculation functions available? (as in Excel)

I would need to extract part of a text field to fill another field using a calculation.

Is there a way/widget that would allow me text calculation functions similar to Excel's left, right or mid functions?

Kind regards,

Michele

Hello Michele,

You may want to try the 'Substring' widget: https://widgets.jotform.com/widget/substring 
Here is the guide about How to Add a Widget to Your Form.

Also, you can check these guides in order to set conditions on your forms:

Smart Forms Using Conditional Logic
How to Manipulate Text (String) with Conditions and Calculation

Give it a try. Feel free to contact us anytime if you need any further assistance.