Create Simple Libreoffice Macro
$10-30 AUD
Pagado a la entrega
Should take between 20-60mins for a experienced Coder..
Therefore budget is between $10-$45
Create Libreoffice Macro to delete all but needed columns in .CSV by looking at column header, then remove all "[" "]" Characters from .CSV.
e.g
"Mobile Number"
[+6143756564]
Also delete all ROWS that contain a duplicate mobile number.
Mobile number needs + symbol at beginning to match with current database.
Next.
In one column with header "SMS Sent" delete all but last character in cells.
The last character will be an Emoji icon which not a standard character so CSV will need to be opened with UTC-8 settings applied.
what is left remaining will basically be the last SMS sent to each unique mobile number, displaying only the last character which will be an emoji icon which we will use as an tracking device to update the status of communication with customer via SMS.
Fields that need to be kept are | Destination Name | Destination Mobile | Text | Date Created
Macro must be written for current version of LibreOffice Calc.
I am running it on a mac, im not sure if that matters or not.. :P
Nº del proyecto: #7563486
Sobre el proyecto
7 freelancers están ofertando un promedio de $35 por este trabajo
Hi, i am good at excel and vba macro. I have variety of experience in writing macros. I would like to start the activity. Looking in anticipation to work this project
Hello Sir. Im excel VBA Macro and formula Expert. :) please give me a chance for doing your project Sir :) for deleting this symbol "[" "]", i can do it Sir :) please see my portfolio and my feedback (the most w Más
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready Más
I know I'm bidding a bit more, but I believe the quality of my work is worth it. Here is my suggestion: 1) Define the header structure to check against the CSV file before processing starts 2) Create RULES sheet - wi Más
i have been trained on same project to what you are looking for ,i am confident i can exceed your expectation