Add data to the string

Nastya

Hello everyone!

I have a problem with adding to the string another string

I have Detail, Route and need to receive the result

Detail	Route	Result
A4	333-3456-321	333A4-3456A4-321A4

Thanks a lot for any help!

patrick_digan

@Nastya In a formula tool, you can use the + sign to concatenate, like:

[Route] + [Detail]

EDIT: I may not have read close enough. Are you trying to add the detail before every dash and at the end? 

EDIT#2: If that's the case, then perhaps something like this in the formula tool

Replace([Route],"-",[Detail]+"-")+Detail