• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Formula Mode Questions
V

Vishal.Reddy

started a topic almost 2 years ago

extract data from a very Complex string which contains below pattern

Example 1 ‘ABC:null|XYZ:102546|DSP:01234567890123456789|ABC:null|DSP:01234567890123456789|’

Example 2 'ABC:null|XYZ:102547|DSP:01234567890123456789'

Example 3 'ABC:null|XYZ:102522|DSP:null'

Example 4 ‘ABC:null|XYZ:102546|DSP:01234567890123456789|ABC:null|DSP:null|’

Above is the data pill output, I need to extract the DSP Id's from above string. 


If the DSP Id's are more than 1 then I need to SKIP

If the DSP ID is exactly 1 then I need that value and stored in sql database.

If the DSP id is null then I need to SKIP it.

Each DSP id contains 20 digits

output:

Example1 : skip

Example2 : 01234567890123456789

Example3 : skip

Example4:  01234567890123456789


Please find the attachment I have tried an example as in attachment but could not get perfect answer. Please suggest.



2021-04-1216-17-44.png
2021-04-1216...
(115 KB)
Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count