Extract Fields from String

Created by Maja Bradonjic, Modified on Thu, 1 Jun, 2023 at 5:09 PM by Ivana B

TABLE OF CONTENTS




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 [email protected] or our chat widget!

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article