We need long titles converted to short titles suitable for use in a URL path for a content migration we are carrying out.
The data will be provided in two files in CSV format (attached) called [url removed, login to view] and [url removed, login to view] which each consist of an id and the long title on each row. An extra entry is to be added to each row containing the shortened title.
The shortened title should contain only alphanumeric characters and no spaces.
HTML entities should be either removed or in the case of Umlaut characters replaced with the non-umlaut version of the character (ie, "&auml;" or "&aacute" become "a", "&quot" is dropped).
Long titles should be shortened. Preference will be given to bidders with basic knowledge of German who can generate sensible shortened titles.
95, Sage &uuml;ber den Tausendj&auml;hrigen Rosenstock
95, Sage &uuml;ber den Tausendj&auml;hrigen Rosenstock, tausendjahrigerrosenstock
75, Meine Aufgabe in Canc&uacute;n
75, Meine Aufgabe in Canc&uacute;n, aufgabecancun
349, Briefe aus Strassburg aus dem Jahr 2004
349, Briefe aus Strassburg aus dem Jahr 2004, briefestrassburgjahr2004
343, Pressemitteilung vom 30. November 2004
343, Pressemitteilung vom 30. November 2004, pressemitteilungen30november2004
There are a total of 717 lines to process in this manner. I have timed myself at less than 10s per line, so this should be doable in around 2 hours for a fast worker.
If you want to bid on this project please reply with edited versions of the following two lines to avoid copy&paste bids:
199, Pressemitteilung vom [url removed, login to view]
302, Gemeinsame Au&szlig;en- & Sicherheitspolitik
9 freelancer đang chào giá trung bình $39 cho công việc này
Hi! We are the experts in such things and ready to start immediately on your project. 100% guarantee of high quality and professional work. Waiting for your selection. Thanks!