How do i move decimal points over using "Ctrl+h" Replace with function?



  • I have a sql document and it has prices of stuff for a game but i wanna know how do i move the decimal point over by 2 spaces for each number value.
    My Document



  • @Matthew-Plueard said in How do i move decimal points over using "Ctrl+h" Replace with function?:

    move the decimal point over by 2 spaces for each number value

    You will need to be a bit more precise in your explanation. Move can go either left or right.

    So an excerpt from your file:

    (2, 'Work Jeans', '12.00', '6.00'),
    (3, 'Orange Hoodie', '15.00', '7.50'),
    (6, 'Military Magazine', '1200.00', '600.00'),
    (7, 'Military Suppressor', '100.00', '50.00'),
    (8, 'Vertical Grip', '200.00', '100.00'),
    

    I assume you’d probably want to go right, it makes more sense (cents) to do so, although I’m not going to provide any solution until you can be precise.

    In fact with regards the examples I provided from your file, can you provide the result you expect?

    When inserting the examples into your post, enter them first, then highlight all the example lines and hit the </> button immediately above the window in which you are typing. They will then appear in the black box as I did.

    Terry


Log in to reply