JSFiddle - React, Tailwind, and code Playground

by mrcl

HTML

DQ2<br>
<textarea id=alt></textarea>

<hr>

DQ3<br>
<textarea id=neu></textarea>

<hr>

DQ3<br>

<textarea id=neu2></textarea>

<hr>
SQL this as that<br>
<textarea rows=10 id=sqlas></textarea>

CSS

textarea {
  width: 100%;
  font-size: 12pt;
}

JavaScript

var mapping = {
  "d_time_date": "date",
  "cl_436744": "redaktion",
  "d_page_chap1": "page_chapter1",
  "d_page_chap2": "page_chapter2",
  "d_page_chap3": "page_chapter3",
  "cl_26761": "content_id",
  "cl_26762": "objekttyp",
  "d_page.uid": "page_id",
  "d_page": "page",
  "cl_421337": "datum_uhrzeit",
  "m_visits": "m_visits",
  "m_page_loads": "m_page_loads",
  "CM_39301": "m_visits_search",
  "CM_177710": "m_visits_chrome_content_suggestions",
  "CM_177712": "m_visits_google_news",
  "d_app_version": "app_version",
  "d_os_group":"os_group",
  "d_source": "src",
  "CM_158816": "m_visits_app",
  "d_l2": "site_level2",
  "d_device_type": "device_type",
  "m_visitors": "m_visitors",
  "m_visitors_page": "m_visitors",
  "d_rm_l2": "site_level2",
  "d_rm_type": "av_content_type",
  "d_rm_theme1": "av_content_theme1",
  "d_rm_theme2": "av_content_theme2",
  "d_rm_theme3": "av_content_theme3",
  "d_rm_content": "av_content",
  "d_rm_duration": "av_duration",
  "m_rm_playcounts": "m_av_playbacks",
  "m_rm_time_spent": "m_av_time_spent",
  "d_time_hour_visit": "visit_hour",
  "CM_39302": "m_visits_referring_sites",
  "CM_39253": "m_visits_social_media",
  "CM_158802": "m_visits_facebook",
  "CM_158803": "m_visits_instagram",
  "m_bounces": "m_bounces",
  "cl_421176": "url",
  "d_rm_broadcast": "av_broadcasting_type",
  "d_space_l2": "site_level2",
  "d_space_l2.uid": "site_level2",
  "d_pub_campaign": "onsitead_campaign",
  "d_pub_creative": "onsitead_creation",
  "m_pub_clicks": "m_pub_clicks",
  "d_pub_url": "onsitead_url" 
};

document.getElementById("alt").addEventListener("change",
function() {
var alt=this.value;
try  { localStorage.setItem("alt",alt); } catch(e) {}
var neu=alt.replace(/[\r|\n]$/,'');
var sqlas="";

for (var key in mapping) {
	neu = neu.replace(key,mapping[key]);
  if (alt.indexOf(key) > -1)
    {
    		//sqlas = sqlas + "\n" + key + ' as "'+ mapping[key] +'",'
    		sqlas = sqlas + "\n" + mapping[key] + ' as "'+ key +'",'
    }
}...