2 posters

Data Extraction

Ravi: Posts : 10
Points : 1879
Join date : 2019-03-22

Post n°1

Data Extraction

by Ravi Tue Sep 17, 2019 11:36 am

Hi Experts,
Can you please help me with below:
I got below string and I need to extract values in variables as per below”

"2ic Pallets docket","Version 2.81","App 2.85e","S",184,0,1,"2014-02-27",1,"CHEP","10001","CHEP pallets","1610123456","AD","Sample Business","Adelaide",,"1610768390","0003","DK Distribution",,"Dennis","T8","123","CN68166",,,79,"Transfer","2014-03-13","ABCD00000063E",-1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

1^st: 2ic Pallets docket
2^nd: Version 2.81
3^rd: App 2.85e
.
.
.
.
.
.
Last: -1

I have Reg Expression but no luck. Any help would be appreciated.

jking

jking: Posts : 103
Points : 3852
Join date : 2014-03-01
Location : USA

Post n°2

Re: Data Extraction

by jking Tue Sep 17, 2019 7:52 pm

Without knowing where you are getting the data, but looking at the structure of the data below, 2 solutions come to mind:

Extract CSV:
If you data is in a file, insert a Load File Step
Insert a View as CSV Step.
Set Step Parameters:
Use Headers
Separator Character
Quote Character
Additional Escape Character
Encoding
Skip Top Lines
Skip Bottom Lines
Loop each row and extract data

Loop For Each Text Part:
Assign your data to a Long Text variable
Remove quotes (")
Insert a Loop For Each Text Part
Iterate over variable and assign output into your variables