![learning_Script learning_Script](https://community.airtable.com/legacyfs/online/avatars/3X/1/9/197147bfce5eed5bb74b63db83698171208076ac.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 02, 2022 03:29 AM
I am a bit of a newb to scripting in general so still learning… But can someone help me parse parts of this text into columns within another table?
“Ether Protocol :black_small_square: 0xE2e335Ef26281ae3feaD48d79cF8F35Fb206fB54”
For example in one column to include “Ether Protocol” and in another the token address “0xE2e335Ef26281ae3feaD48d79cF8F35Fb206fB54”
![kuovonne kuovonne](https://community.airtable.com/legacyfs/online/avatars/3X/b/c/bcecb2d58f8302e9d9f520621c02ff41be54488c.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 02, 2022 06:28 AM
Welcome to the Airtable community!
If all of the records will have this exact format, you could use formula fields to extract the two parts. Then use a linked record field and lookups/rollups to get the values in the other table.
The exact format of the formulas depends on the exact structure of the data.
If you want to go a scripting route, that is also possible. How far have you gotten so far?
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)