I’m trying to map Google Form responses spreadsheet to Salesforce. The goal is to create a record with each response. I’m getting an error message “The operation failed with an error. [400] Ethnicity/Race: bad value for restricted picklist field: Hispanic/Latino, Black or African American, White” and I noticed the Google responses for checkbox fields are separated by comma and space. I would like to replace the comma and space with semicolon to match Salesforce multiselect picklist format. I’m trying to use the Text Parser to replace the comma and space with semicolon. I’m not very familiar with RegEx and I tried multiple formats and I’m still getting the error. The last RegEx I used was " ,\s? " based on the recommendation here Regex removing , space and replacing with , but I’m still getting the error message.
Welcome to the Make community!
When reaching out for assistance with extracting text, it would be super helpful if you could share the actual text you’re trying to match. Screenshots of text can be a bit tricky, so if you could copy and paste the text directly here, that would be awesome! It ensures we can run it against test patterns effectively. If there’s any sensitive info, feel free to change it to something fictional yet still valid by keeping the format intact.
Providing clear text examples saves time on both ends and helps us give you the best possible solution. Without proper examples, we might end up playing a guessing game, and nobody wants that as it is a waste of time! You are more likely to get a correct answer faster. So, help us help you by sharing those text snippets.
Please format the example text this way to preserve line breaks and special characters:
These are the two ways to format text so that it won’t be modified by the forum:
-
Method 1: Type code block manually
Add three backticks
```before and after the content/bundle, like this:```
content goes here
``` -
Method 2. Highlight and click the format button in the editor
Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
— @samliew