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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login