adding incremental number between ' '

SpeedRider · Jul 7, 2020, 11:32 AM

'13':
    type: SHOP
    id: SPRUCE_WOOD
    buy-price: 200.0
  '14':
    type: SHOP
    id: BIRCH_LOG
    buy-price: 200.0
  '15':
    type: SHOP
    id: BIRCH_WOOD
    buy-price: 200.0
  '16':
    type: SHOP
    id: JUNGLE_LOG
    buy-price: 200.0
  '17':
    type: SHOP
    id: JUNGLE_WOOD
    buy-price: 200.0
  '18':
    type: SHOP
    id: ACACIA_LOG
    buy-price: 200.0
  '19':
    type: SHOP
    id: ACACIA_WOOD
    buy-price: 200.0
  '20':
    type: SHOP
    id: DARK_OAK_LOG
    buy-price: 200.0
  '21':
    type: SHOP
    id: DARK_OAK_WOOD
    buy-price: 200.0
  '22':
    type: SHOP
    id: SPONGE
    buy-price: 260.0
  '23':
    type: SHOP
    id: BRICKS
    buy-price: 270.0
  '24':
    type: SHOP
    id: WHITE_WOOL
    buy-price: 320.0

I would like to be able to replace all the numbers inside the ‘0-1000’

guy038 · Jul 7, 2020, 12:34 PM

Hello, @speedrider and All,

Here is my solution :

From your text :

  '13':
    type: SHOP
    id: SPRUCE_WOOD
    buy-price: 200.0
  '14':
    type: SHOP
    id: BIRCH_LOG
    buy-price: 200.0
  '15':
    type: SHOP
    id: BIRCH_WOOD
    buy-price: 200.0
  '16':
    type: SHOP
    id: JUNGLE_LOG
    buy-price: 200.0
  '17':
    type: SHOP
    id: JUNGLE_WOOD
    buy-price: 200.0
  '18':
    type: SHOP
    id: ACACIA_LOG
    buy-price: 200.0
  '19':
    type: SHOP
    id: ACACIA_WOOD
    buy-price: 200.0
  '20':
    type: SHOP
    id: DARK_OAK_LOG
    buy-price: 200.0
  '21':
    type: SHOP
    id: DARK_OAK_WOOD
    buy-price: 200.0
  '22':
    type: SHOP
    id: SPONGE
    buy-price: 260.0
  '23':
    type: SHOP
    id: BRICKS
    buy-price: 270.0
  '24':
    type: SHOP
    id: WHITE_WOOL
    buy-price: 320.0

Do this regex S/R :

SEARCH \R(?!\h*')|('\d+')
REPLACE ?1'':|
Select the Regular expression search mode

You should get this text :

  '':|    type: SHOP|    id: SPRUCE_WOOD|    buy-price: 200.0
  '':|    type: SHOP|    id: BIRCH_LOG|    buy-price: 200.0
  '':|    type: SHOP|    id: BIRCH_WOOD|    buy-price: 200.0
  '':|    type: SHOP|    id: JUNGLE_LOG|    buy-price: 200.0
  '':|    type: SHOP|    id: JUNGLE_WOOD|    buy-price: 200.0
  '':|    type: SHOP|    id: ACACIA_LOG|    buy-price: 200.0
  '':|    type: SHOP|    id: ACACIA_WOOD|    buy-price: 200.0
  '':|    type: SHOP|    id: DARK_OAK_LOG|    buy-price: 200.0
  '':|    type: SHOP|    id: DARK_OAK_WOOD|    buy-price: 200.0
  '':|    type: SHOP|    id: SPONGE|    buy-price: 260.0
  '':|    type: SHOP|    id: BRICKS|    buy-price: 270.0
  '':|    type: SHOP|    id: WHITE_WOOL|    buy-price: 320.0|

Now place the caret between the first '' zone
Open the Column editor ( Alt + C ) and renumber as you like
Don’t forget to tick the Leading zeros option

For instance, we could end with this text :

  '01':|    type: SHOP|    id: SPRUCE_WOOD|    buy-price: 200.0
  '02':|    type: SHOP|    id: BIRCH_LOG|    buy-price: 200.0
  '03':|    type: SHOP|    id: BIRCH_WOOD|    buy-price: 200.0
  '04':|    type: SHOP|    id: JUNGLE_LOG|    buy-price: 200.0
  '05':|    type: SHOP|    id: JUNGLE_WOOD|    buy-price: 200.0
  '06':|    type: SHOP|    id: ACACIA_LOG|    buy-price: 200.0
  '07':|    type: SHOP|    id: ACACIA_WOOD|    buy-price: 200.0
  '08':|    type: SHOP|    id: DARK_OAK_LOG|    buy-price: 200.0
  '09':|    type: SHOP|    id: DARK_OAK_WOOD|    buy-price: 200.0
  '10':|    type: SHOP|    id: SPONGE|    buy-price: 260.0
  '11':|    type: SHOP|    id: BRICKS|    buy-price: 270.0
  '12':|    type: SHOP|    id: WHITE_WOOL|    buy-price: 320.0|

Now, use this simple regex S/R to get your initial list :

SEARCH \|

REPLACE \r\n for Windows files OR \n for Unix files

  '01':
    type: SHOP
    id: SPRUCE_WOOD
    buy-price: 200.0
  '02':
    type: SHOP
    id: BIRCH_LOG
    buy-price: 200.0
  '03':
    type: SHOP
    id: BIRCH_WOOD
    buy-price: 200.0
  '04':
    type: SHOP
    id: JUNGLE_LOG
    buy-price: 200.0
  '05':
    type: SHOP
    id: JUNGLE_WOOD
    buy-price: 200.0
  '06':
    type: SHOP
    id: ACACIA_LOG
    buy-price: 200.0
  '07':
    type: SHOP
    id: ACACIA_WOOD
    buy-price: 200.0
  '08':
    type: SHOP
    id: DARK_OAK_LOG
    buy-price: 200.0
  '09':
    type: SHOP
    id: DARK_OAK_WOOD
    buy-price: 200.0
  '10':
    type: SHOP
    id: SPONGE
    buy-price: 260.0
  '11':
    type: SHOP
    id: BRICKS
    buy-price: 270.0
  '12':
    type: SHOP
    id: WHITE_WOOL
    buy-price: 320.0

Voila !

Best Regards,

guy038