# String Transformations **URL:** \ **Category:** General\ **Created:** [April 14, 2026, 7:48am UTC](https://jsonforms.discourse.group/t/string-transformations/2811 "2026-04-14T07:48:58Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![cgrigg](https://avatars.discourse-cdn.com/v4/letter/c/6de8d8/32.png) [@cgrigg](https://jsonforms.discourse.group/u/cgrigg)\ **Post date:** [April 14, 2026, 7:48am UTC](https://jsonforms.discourse.group/t/string-transformations/2811/1 "2026-04-14T07:48:58Z")
Hi team I am new to your site and new to JSON so please be gentle. I am utilising Power Automate to look at categories assigned to my emails and then push some data back to an SQL database. I used graph explorer to help me get the right API message and have added a JSON parse into my workflow. With that context out of the way - one of the fields from the email is Subject which caontains a refernce number. My question is - how do I extract the reference number as a seperate value from the subject in order to use that as a coilumn to push to SQL. Essentially how do I use mid and string type syntax in JSON. I hope this resembles some sense and appricaite any feedback. Happy to upload somethign if needed. cheers ---
**Author:** ![lucas-koehler](https://yyz2.discourse-cdn.com/free1/user_avatar/jsonforms.discourse.group/lucas-koehler/32/336_2.png) [@lucas-koehler](https://jsonforms.discourse.group/u/lucas-koehler)\ **Post date:** [April 17, 2026, 8:20am UTC](https://jsonforms.discourse.group/t/string-transformations/2811/2 "2026-04-17T08:20:02Z")
Hi @cgrigg , I think you have confused what this forum is about. It is **not** about the general usage of JSON but using the Javascript/Typescript framework [JSON Forms](https://jsonforms.io/) to render forms based on a JSON schema. Good luck with your issue and feel free to come back with questions relating to JSON Forms anytime 🙂 Best regards, Lucas ---
**Author:** ![lucas-koehler](https://yyz2.discourse-cdn.com/free1/user_avatar/jsonforms.discourse.group/lucas-koehler/32/336_2.png) [@lucas-koehler](https://jsonforms.discourse.group/u/lucas-koehler)\ **Post date:** [April 17, 2026, 8:20am UTC](https://jsonforms.discourse.group/t/string-transformations/2811/3 "2026-04-17T08:20:24Z")