Create Simple Libreoffice Macro

En curso Publicado Apr 27, 2015 Pagado a la entrega
En curso 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

Excel Visual Basic

Nº del proyecto: #7563486

Sobre el proyecto

7 propuestas Proyecto remoto Activo Apr 30, 2015

7 freelancers están ofertando un promedio de $35 por este trabajo

cgullapalli

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

$45 AUD en 0 días
(868 comentarios)
8.0
SBITServices

Ready to do it for less price also.

$27 AUD en 1 día
(433 comentarios)
7.5
prameswara

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

$30 AUD en 0 días
(363 comentarios)
7.2
sonarkaushik

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

$45 AUD en 2 días
(45 comentarios)
5.6
jnekam

Hi Dear Hiring manager. I have a good skill of this project. I just performed one like yours. My spreadsheet has: product sheet and sales record sheet. With this information, I developed a macro to perform: sales r Más

$25 AUD en 1 día
(12 comentarios)
3.8
morrisstarling

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

$56 AUD en 1 día
(7 comentarios)
3.6
jeffhuges186

i have been trained on same project to what you are looking for ,i am confident i can exceed your expectation

$15 AUD en 1 día
(0 comentarios)
0.0