TABLE OF CONTENTS

• 1. What is Extract Fields from String
• 2. Extract Fields from String Options
  • 2.1 Name 
  • 2.2 Item Separator 
  • 2.3 Values Separator 
  • 2.4 Field 1 name 
  • 2.5 Field 2 name 
  • 2.6 Type
  • 2.7 String field to extract from  
• 3. Example and how to use it

1. What is Extract Fields from String

Extract fields from string field represents a collection field consisting of pair of fields which are extracted from string value based on each pair and pair separator.

2. Extract Fields from String Options

2.1 Name 

The name of the Extract fields from String field that you would like to see in the Mapping section.

2.2 Item Separator 

• Pipe

• Tab
• Semicolon
• Slash
• Other

2.3 Values Separator 

• Pipe
• Tab
• Semicolon
• Slash
• Other

2.4 Field 1 name 

The name of the first field you are using to extract fields from a string.

2.5 Field 2 name 

The name of the second field you are using to extract fields from a string.

2.6 Type

Text, Number, or Date from the specific field

2.7 String field to extract from  

A field you will be extracting the string from.

3. Example and how to use it

In this example, a field contains a value in the format of:

 'attributename/attributeValue1|attributename/attributeValue2'. 

By separating each pair using the '|' symbol and further dividing the pairs with the '/' symbol, we can create two pairs. Each pair will have the attribute name and its corresponding attribute value extracted and assigned to separate fields.

The "Extracted values" field has been updated to reflect the following format. 

These extracted values can now be utilized without any restrictions to map them to the desired fields in the mapping section.

To check the list of the tools and features we support please click here!

If you don't see your favorite tool on our list, please take the time and send us the request here to create an integration for you or UP-vote if it's already on the list :) 

We develop integrations based on the requests and up-votes :) 

We hope that this covers everything. If you have any further questions or need additional clarification please reach out to us via support@syncspider.com or our chat widget!