Step-by-Step List Manipulation

Input

Operations

  1. splitColumn ({"position":5})
  2. splitColumn ({"position":11})
  3. insertAt ({"position":0,"text":"- [ ]\t2020-"})
  4. regex ({"from":"(USD|EUR)","to":"\t$&\t"})
  5. regex ({"from":"(.IO|.COM|STOCKHOLM)","to":"$&\t"})
  6. regex ({"from":"(CCÖ)","to":" $& "})
  7. regex ({"from":"(INC.|LLC|EMEA|IMGIX|GITHUB|MLAB)","to":"$& "})
  8. regex ({"from":"(FB.ME|STOCKHOLM)","to":" $&"})
  9. regex ({"from":"AZURE","to":"AZURE\t"})
  10. regex ({"from":",[0-9]{2}","to":"$&\t"})
  11. regex ({"from":"\t$","to":""})
Add step:

Output

0123456
- [ ]2020-02-0302-03AWS EMEA AWS.AMAZON.COUSD78,00774,13
- [ ]2020-02-0202-03GOOGLE *CLOUD_01DF0B-D CCÖ GOOGLE.COM2 184,07
- [ ]2020-02-0102-03FASTLY, INC. 415-6045348USD250,002 481,19
- [ ]2020-02-0102-03ADOBE PHOTOGPHY PLANADOBE.COM96,00
- [ ]2020-02-0102-03GOOGLE*GSUITE WELD.IOINTERNETEUR38,40419,20
- [ ]2020-02-0102-03DIGITALOCEAN.COM6463978051USD2,3923,73
- [ ]2020-02-0102-03MLAB 4157582748USD78,50779,10
- [ ]2020-02-0102-03IMGIX 4154845964USD104,201 034,16
- [ ]2020-01-3102-03FACEBK *TFAT3RSMH2 FB.ME/ADSUSD5,8958,46
- [ ]2020-01-3002-03CULTUR STOCKHOLM360,00
- [ ]2020-01-3001-31FACEBK *DXGH3RSMH2 FB.ME/ADSUSD750,007 426,30
- [ ]2020-01-2901-30GITHUB 8774484820USD25,00246,74
- [ ]2020-01-2801-29INTERCOM.IO8778877815USD131,801 302,60
- [ ]2020-01-2801-28GOOGLE *ADS7865733355 CCÖ GOOGLE.COM5 000,00
- [ ]2020-01-2401-27SCANDINAVIAN PHOTO STOCKHOLM2 125,00
- [ ]2020-01-2401-27MSFT *MSFT AZURE3,49
- [ ]2020-01-2401-27CLOUDBEES, INC. 3238424483USD49,00480,84
- [ ]2020-01-2301-24ADESPRESSO, INC. 4156889467USD69,00675,76
- [ ]2020-01-2201-23NPM, INC. 5109073049USD14,00136,80
- [ ]2020-01-2101-22NETDNA. LLC 8776292361USD25,00244,43
- [ ]2020-01-2101-22GHOSTINSPECTOR.COM2063953635USD79,00772,40