fork(1) download
copy 
  1. import csv
  2. from sys import stdin
  3.  
  4. def transform_csv(data):
  5. 	reader = csv.DictReader(data, delimiter='|')
  6. 	next(reader) #skips separator
  7. 	for item in reader:
  8. 		period, plant, salesAm = item[' Period'].strip(), item['Plnt'], item['LCurr'].strip()
  9. 		yield  period, plant, salesAm
  10.  
  11. for i in transform_csv(stdin):
  12. 	print(i)
Success #stdin #stdout 0.03s 9500KB
comments (?)
stdin
copy 
|  DocumentNo|Doc..Date |PK|Pstng Date|   Amt in loc.cur.|LCurr|BusA|Typ|Year/month| Period|Year|Plnt|Ref. Key 1  |
-------------------------------------------------------------------------------------------------------------------
|  2000007189|03.01.2020|01|03.01.2020|         2,368.12 |USD  |USCD|DR |2020/01   |      1|2020|7209|72096047    |
|  2000008904|03.01.2020|01|03.01.2020|         4,669.23 |USD  |USCD|DR |2020/01   |      1|2020|7181|71811239    |
stdout
copy 
('1', '7209', 'USD')
('1', '7181', 'USD')
https://ideone.com/Lgfali
language:
Python 3 (python  3.9.5)
created:
4 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!