here I have a column shows tracking number from multiple shipping carriers.
some are something like ‘6495-4289-3463’(number+‘-’) or some are like ‘343918 ai19’ (text+number+space).
I would like to turn these into only number and text without any ‘-’ or space.
It seems like I can use trim and substitute for formula, however, I don’t want to create extra column for it. Therefore, I want to use script using automation when context is filled.
what would be the script l can use?
You mentioned automation. So, you have to input your text into script step and then use output for next step. Like this:
‘text’ and ‘txt’ are variable names, you can choose it on your own.
in my example, line breaks also present, that’s why output looks like still contain spaces
Usually, scripts in airtable following this scenario:
automation can help with better understanding of process, you may construct steps 1 and 3 in automation gui, without code. despite you can’t update several records in a single update action, you can ‘mark’ them if they linked to other table and setup other automation to process all marked.
in your case, script just transforms input value ‘text’ to output value ‘txt’