AnsweredAssumed Answered

How to parse text into fields and records

Question asked by pcand01 on Jun 9, 2017
Latest reply on Jun 9, 2017 by fmpdude

Hello,

I am new here and I need some pointers as where can I find examples to parse and format this type of text into fields and records.

In need to extract the Date, D0, D1, Value column to build a table. The number of records can vary, the columns are fixed.
Thanks in advance for ideas and or links to similar examples.

 

"CubeId";"devkum"

 

"PublishingDate";"2017-06-01 14:30"

 

"Date";"D0";"D1";"Value"

 

"2017-04";"M0";"EUR1";"1.0723"

"2017-04";"M0";"GBP1";"1.2637"

"2017-04";"M0";"DKK100";"14.4175"

"2017-04";"M0";"NOK100";"11.67"

"2017-04";"M0";"CZK100";"3.9959"

"2017-04";"M1";"CZK100";"3.9801"

Outcomes