Pentaho

 View Only

 How do you handle fixed text file with a multi line unevenely wrapped column?

  • Pentaho
  • Pentaho
  • Pentaho Data Integration PDI
Enniwes Mashonganyika's profile image
Enniwes Mashonganyika posted 10-01-2021 16:09

wrapped column Description

Enniwes Mashonganyika's profile image
Enniwes Mashonganyika posted 10-05-2021 07:53

Text file input should handle it acording to this post https://www.youtube.com/watch?v=9j1pjF04sk4 but aparently only in version 4.4 i am on version 8.3 and it does not work.....

Enniwes Mashonganyika's profile image
Enniwes Mashonganyika posted 11-30-2021 10:20
Just thought i should share, Solved this by using regex evaluation step with below regex

^\s*(\d*)\s*(\d*)\s*(\d*)\s*(\d*)\s*\((\s*\d*.\d*\%)\)\s{4}([A-H0-9]{4}).*

Related Content