Replace formatter adding an unwanted space

Question

I am using the replace formatter to change a ‘,’ which has been used as a delimiter in a list.

I want to replace the ‘,’ with ‘,NOS-’ so this is before every item on the list. When doing this is it is adding a space after the hyphen. So there is a unwanted space between the hyphen and list item.

I understand I can use another formatter to remove all whitespace from string but I do not wish to do this as some of our list items include spaces between words which we do not want to loose.

Does anyone have an idea on how we can solve this issue?

Thanks :)

Page 1 / 1

@StevenSimmonds

It looks like there may be a space in the original list.. have you tried replacing ‘, ‘ with ‘,NOS-’ ?

Alternatively, you could try using the Formatter > Utilities > Line Item to Text and setting the Separator as ‘,NOS-’

GetUWired · Answer

@StevenSimmondsIt looks like there may be a space in the original list.. have you tried replacing ‘, ‘ with ‘,NOS-’ ?Alternatively, you could try using the Formatter > Utilities > Line Item to Text and setting the Separator as ‘,NOS-’

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded