Substring function on Jotform Tables

According to Chat GPT,

Jotform Tables currently does not have a full SUBSTRING() function or regular expressions.

But you can simulate extracting the name part of an email using a trick with the SPLIT and INDEX functions.

Here's how to do it:

🎯 To extract the part before the @ in an email in Jotform Tables:

You can use:

INDEX(SPLIT([Email], "@"), 0)

Function Purpose SPLIT(text, delimiter) Splits the text into parts INDEX(array, position) Picks the item at position (0-based) ✅ This formula:

• Splits the email into two parts at the @
• Takes the first part (position 0) — which is the username.

🔥 Example: Email Formula Used Result john.doe@gmail.com INDEX(SPLIT([Email], "@"), 0) john.doe susan@example.org INDEX(SPLIT([Email], "@"), 0) susan ⚡ Quick Copy-Paste Formula:

INDEX(SPLIT([Email Address], "@"), 0)

(Assuming your column is called Email Address — adjust the name as needed!)

⚠️ Important Tips:

• If the email field is empty → this formula will return an empty value.
• If the email is invalid (no @) → you might get an error or blank.
• Jotform Tables does not support nested SPLIT() inside other functions (only shallow nesting like above).

❓ Bonus: What if you wanted the domain part (after the @) instead?

Use:

INDEX(SPLIT([Email], "@"), 1)

(position 1 instead of 0)

But Jotform does not have any of these string functions, so please extend the fx command set.

Hi Emile,

Thanks for reaching out to Jotform Support. I understand what you’d like to do, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

Thanks for your patience, we appreciate it.

Hi Emile,

While Jotform Tables' Advanced Formula doesn't have Index and Split functions, you can use the existing functions we have on this page. For example, if you'd like to extract the domain name from an email address, you can use the MID, SEARCH, and LEN functions altogether. Let me show you how to do it:

1. First, copy this formula.

MID({Email},SEARCH("@", {Email})+1,LEN({Email}))

2. In the Jotform Tables page, click on the Add button at the end of the rows, and click on the Formula tab.

3. Select Advanced Formula, click on Next, then enter a column name, and click on Next again.

4. In the Create a Formula box, click on the Text icon, and paste the formula you just copied from the above link to the formula box.

5. Then, remove the {email} placeholders and replace them with the existing email field from the Columns box at the bottom.

6. Now, click on the Function icon just above the Text icon, and watch the formula transforms.

7. Remove trailing spaces at the end of the formula, if any, then click on Create Column.

And that's it. The column should now contain the domain extracted from the email addresses of each row in the table. You can visit this page to learn more about Using Advanced Formula in Jotform Tables.

Give it a try and let us know how it goes.

Works Great, thanks John!

Thanks so Much John, this works great!
It would be great to enhance the string functions in the future.
Really appreciate your help!
Emile
________________________________
...