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.
Send us a ticket, we will try our best to assist you with your problem
Vishal.Reddy
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.