Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. splitrows col: column1 on: '\r\n'
  2. split col: column1 on: ',' limit: 92 quote: '\"'
  3. header
  4. drop col: Country_Code
  5. drop col: Item_Code
  6. drop col: Element_Code
  7. drop col: Y1971F
  8. drop col: Y1970F
  9. drop col: Y1972F
  10. drop col: Y1973F
  11. drop col: Y1974F
  12. drop col: Y1975F
  13. drop col: Y2010F
  14. drop col: Y2009F
  15. drop col: Y2008F
  16. drop col: Y2011F
  17. drop col: Y2012F
  18. drop col: Y2007F
  19. drop col: Y2006F
  20. drop col: Y2005F
  21. drop col: Y2004F
  22. drop col: Y2003F
  23. drop col: Y2002F
  24. drop col: Y2001F
  25. drop col: Y2000F
  26. drop col: Y1999F
  27. drop col: Y1998F
  28. drop col: Y1997F
  29. drop col: Y1996F
  30. drop col: Y1995F
  31. drop col: Y1994F
  32. drop col: Y1993F
  33. drop col: Y1992F
  34. drop col: Y1991F
  35. drop col: Y1990F
  36. drop col: Y1989F
  37. drop col: Y1988F
  38. drop col: Y1987F
  39. drop col: Y1986F
  40. drop col: Y1985F
  41. drop col: Y1984F
  42. drop col: Y1983F
  43. drop col: Y1982F
  44. drop col: Y1981F
  45. drop col: Y1980F
  46. drop col: Y1979F
  47. drop col: Y1978F
  48. drop col: Y1977F
  49. drop col: Y1976F
  50. delete row: !in(Element, ['Emissions (CO2) (Energy)'])
  51. delete row: !in(Item, ['Total Energy'])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement