Data entry project. Add codes to text file. Need some basic Google sheets to copy/paste/paste transposed experience
Budget: ₹750 – ₹1,250 INR
We have a text file that needs to be coded with comments. You need to use notepad++ (free program) to edit the file. See the graphic attached to the project.
The purple box: this is the starting information
The Green box, this is what we need. We have about 120 characters (like my "A" example) that we need this process done for. My example shows the Capital Letter A
How to do it
1. Any values < 256 go on the first line of comments. See my example for "A"
2. Values 256+ go on the next lines. (my example has 2 lines) For visual reference the text need to line up perfectly for easy viewing
3. You can copy/paste the line of numbers (in the mapto command) into Notepad++
4. Use find/replace in notepad++ and choose "extended" under search mode
5. replace comma (,) with "\n". This will put each number 1 per line
6. Paste into Google sheet (Not Excel, it will remove high unicode characters)
7. Use the function Unichar() to display the character.
8. Now you have the numbers and the characters and you need to paste it into the file and do some editing to line up the data.
that's it. Easy work, but attention to detail is critical, it must be perfect. To show that you have attention to detail, put your favorite music group or song as the first words in your bid. This proves to me you read my project description. I am thinking $100-$150 and I'll give a $50 bonus for exceptional accuracy at the end. This means (1) it look real good, (2) you are smart enough to ask questions if you are unsure of something (3) you are focused and get this done quick. We will give the input file to the winning bidder
Good luck!
The purple box: this is the starting information
The Green box, this is what we need. We have about 120 characters (like my "A" example) that we need this process done for. My example shows the Capital Letter A
How to do it
1. Any values < 256 go on the first line of comments. See my example for "A"
2. Values 256+ go on the next lines. (my example has 2 lines) For visual reference the text need to line up perfectly for easy viewing
3. You can copy/paste the line of numbers (in the mapto command) into Notepad++
4. Use find/replace in notepad++ and choose "extended" under search mode
5. replace comma (,) with "\n". This will put each number 1 per line
6. Paste into Google sheet (Not Excel, it will remove high unicode characters)
7. Use the function Unichar() to display the character.
8. Now you have the numbers and the characters and you need to paste it into the file and do some editing to line up the data.
that's it. Easy work, but attention to detail is critical, it must be perfect. To show that you have attention to detail, put your favorite music group or song as the first words in your bid. This proves to me you read my project description. I am thinking $100-$150 and I'll give a $50 bonus for exceptional accuracy at the end. This means (1) it look real good, (2) you are smart enough to ask questions if you are unsure of something (3) you are focused and get this done quick. We will give the input file to the winning bidder
Good luck!