Handlebar help with substring

Integrator.io
1

Is it possible to strip the first and last character off of a string using a Handlebar expression? I have a product code of "BQ24-00000123542N" that I want to be "Q24-000001233542".

Or does this require javascript?

2

hi, it is possible using regex. Assuming simple structure such as {"productCode": "abba"},

the following should do the job: {{regexReplace productCode "" "^.|.$" "gm"}} and output is "bb".

More info here: https://docs.celigo.com/hc/en-us/articles/360039326071-Handlebars-helper-reference

I'm by no means a regex expert but this is a useful resource for testing: https://regex101.com/

3

You could also do this

{{substring (substring code 1) 0 (subtract code.length 2)}}

This image displays a Handlebars template code snippet that processes a substring operation on a code, and shows both the available resource data and the resulting output. (Captioned by AI)
This image displays a Handlebars template code snippet that processes a substring operation on a code, and shows both the available resource data and the resulting output. (Captioned by AI)1763×120 14.7 KB