0

Parsing information contained in a single field

Jean Ryan

July 23, 2019 09:34

None

Follow

We have an input field coming from a .csv that has 3 pieces of data in it separated by periods (.). Example: 1111.2222.33333. Is there a way to parse out the three pieces of information into distinct field outputs in Centerprise?

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Astera Support 3 July 25, 2019 12:50 Official comment

  Hi Jean,

  Yes, you can achieve the desired output using a built-in function in Centerprise, which is the SplitString function. You can refer to the following article to see how you can use the SplitString function in your dataflow:

  https://astera.zendesk.com/hc/en-us/articles/360032397953-How-to-parse-information-in-a-field-using-Astera-s-built-in-functions

  So you pass the input field (string) coming from the .csv file and specify the delimiter/separator in the SplitString function and it will split the information contained in the input field into distinct outputs.

• 0
  
  Jean Ryan July 29, 2019 07:35

  Okay, got it. The article was really helpful, thanks!