manipulate strings in expressions

  • 6Views
  • Last Post 02 March 2020
0
votes
Julian Fernau posted this 28 February 2020

Hi there,

is there any better documentations for building expressions in data integrations?

Specifically we are trying to manipulate phone numbers coming from Shopify to be in the cooerct format before adding to Zendesk.

We have created a larger boolean expression which seems to be working but are struggling with manipulating the strin, e.g. adding a "+1" to a variable.

 

"+1"&REPLACE(REPLACE(REPLACE(REPLACE(DefaultAddress_Phone," ",""),"(",""),")",""),"-","")

The & operator is not accepted for type DT_WSTR.

Thanks,

Julian

 

 

0
votes
Mariia Zaharova posted this 02 March 2020

Hello Julian!

 

You can concatenate string by using this Expression: Str1+Str2

Please find more details here.

 

Feel free to ask any further questions.

 

Best regards,

Mariia

Close