Created
March 10, 2022 07:48
-
-
Save elsanussi-s-mneina/bcb34408bb5b01fe9274412b3dbd7a31 to your computer and use it in GitHub Desktop.
Formulas for removing Middle Eastern Diacritic characters using a spreadsheet program. https://youtu.be/kQ97ubscAkY
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Full title: How to remove Hebrew, Arabic, Syriac, Mandaic, Samaritan, Yezidi diacritics (nequdot, pointing, cantillation, tashkeel) in Excel, Numbers, Google Sheets, or other Spreadsheet program using a formula | |
| Full description for the video at: https://youtu.be/kQ97ubscAkY | |
| Instructions: | |
| 1. Copy one of the formulas below into a spreadsheet program such as Excel. | |
| 2. Modify the formula changing the text "G15" to refer to the cell where you have the text with diacritics. | |
| You can use the formulas without worrying about copyright law. The license is at the bottom of this gist. | |
| If you want more information contact me in various ways or by emailing me at grassdewmorning@gmail.com | |
| generating Spreadsheet formula for removing Arabic diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G15, char(1552), ""), char(1553), ""), char(1554), ""), char(1555), ""), char(1556), ""), char(1557), ""), char(1558), ""), char(1559), ""), char(1560), ""), char(1561), ""), char(1562), ""), char(1611), ""), char(1612), ""), char(1613), ""), char(1614), ""), char(1615), ""), char(1616), ""), char(1617), ""), char(1618), ""), char(1619), ""), char(1620), ""), char(1621), ""), char(1622), ""), char(1623), ""), char(1624), ""), char(1625), ""), char(1626), ""), char(1627), ""), char(1628), ""), char(1629), ""), char(1630), ""), char(1631), ""), char(1648), "") | |
| generating Spreadsheet formula for removing Arabic but keep FATHATAN diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G15, char(1552), ""), char(1553), ""), char(1554), ""), char(1555), ""), char(1556), ""), char(1557), ""), char(1558), ""), char(1559), ""), char(1560), ""), char(1561), ""), char(1562), ""), char(1612), ""), char(1613), ""), char(1614), ""), char(1615), ""), char(1616), ""), char(1617), ""), char(1618), ""), char(1619), ""), char(1620), ""), char(1621), ""), char(1622), ""), char(1623), ""), char(1624), ""), char(1625), ""), char(1626), ""), char(1627), ""), char(1628), ""), char(1629), ""), char(1630), ""), char(1631), ""), char(1648), "") | |
| generating Spreadsheet formula for removing Arabic but keep FATHATAN and SHADDA diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G15, char(1552), ""), char(1553), ""), char(1554), ""), char(1555), ""), char(1556), ""), char(1557), ""), char(1558), ""), char(1559), ""), char(1560), ""), char(1561), ""), char(1562), ""), char(1612), ""), char(1613), ""), char(1614), ""), char(1615), ""), char(1616), ""), char(1618), ""), char(1619), ""), char(1620), ""), char(1621), ""), char(1622), ""), char(1623), ""), char(1624), ""), char(1625), ""), char(1626), ""), char(1627), ""), char(1628), ""), char(1629), ""), char(1630), ""), char(1631), ""), char(1648), "") | |
| generating Spreadsheet formula for removing Hebrew diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G15, char(1425), ""), char(1426), ""), char(1427), ""), char(1428), ""), char(1429), ""), char(1430), ""), char(1431), ""), char(1432), ""), char(1433), ""), char(1434), ""), char(1435), ""), char(1436), ""), char(1437), ""), char(1438), ""), char(1439), ""), char(1440), ""), char(1441), ""), char(1442), ""), char(1443), ""), char(1444), ""), char(1445), ""), char(1446), ""), char(1447), ""), char(1448), ""), char(1449), ""), char(1450), ""), char(1451), ""), char(1452), ""), char(1453), ""), char(1454), ""), char(1455), ""), char(1456), ""), char(1457), ""), char(1458), ""), char(1459), ""), char(1460), ""), char(1461), ""), char(1462), ""), char(1463), ""), char(1464), ""), char(1465), ""), char(1466), ""), char(1467), ""), char(1468), ""), char(1469), ""), char(1470), ""), char(1471), ""), char(1472), ""), char(1473), ""), char(1474), ""), char(1475), ""), char(1476), ""), char(1477), ""), char(1479), ""), char(1471), ""), char(64286), "") | |
| generating Spreadsheet formula for removing Hebrew but keeping consonant modifier diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G15, char(1425), ""), char(1426), ""), char(1427), ""), char(1428), ""), char(1429), ""), char(1430), ""), char(1431), ""), char(1432), ""), char(1433), ""), char(1434), ""), char(1435), ""), char(1436), ""), char(1437), ""), char(1438), ""), char(1439), ""), char(1440), ""), char(1441), ""), char(1442), ""), char(1443), ""), char(1444), ""), char(1445), ""), char(1446), ""), char(1447), ""), char(1448), ""), char(1449), ""), char(1450), ""), char(1451), ""), char(1452), ""), char(1453), ""), char(1454), ""), char(1455), ""), char(1456), ""), char(1457), ""), char(1458), ""), char(1459), ""), char(1460), ""), char(1461), ""), char(1462), ""), char(1463), ""), char(1464), ""), char(1465), ""), char(1466), ""), char(1467), ""), char(1468), ""), char(1469), ""), char(1470), ""), char(1471), ""), char(1472), ""), char(1475), ""), char(1476), ""), char(1478), ""), char(1479), "") | |
| generating Spreadsheet formula for removing Hebrew but remove only cantillation diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G15, char(1425), ""), char(1426), ""), char(1427), ""), char(1428), ""), char(1429), ""), char(1430), ""), char(1431), ""), char(1432), ""), char(1433), ""), char(1434), ""), char(1435), ""), char(1436), ""), char(1437), ""), char(1438), ""), char(1439), ""), char(1440), ""), char(1441), ""), char(1442), ""), char(1443), ""), char(1444), ""), char(1445), ""), char(1446), ""), char(1447), ""), char(1448), ""), char(1449), ""), char(1450), ""), char(1451), ""), char(1452), ""), char(1453), ""), char(1454), ""), char(1455), ""), char(1469), "") | |
| generating Spreadsheet formula for removing Hebrew but only remove vowel diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G15, char(1456), ""), char(1457), ""), char(1458), ""), char(1459), ""), char(1460), ""), char(1461), ""), char(1462), ""), char(1463), ""), char(1464), ""), char(1465), ""), char(1466), ""), char(1467), ""), char(1470), ""), char(1471), ""), char(1472), ""), char(1473), ""), char(1474), ""), char(1475), ""), char(1476), ""), char(1477), ""), char(1479), "") | |
| generating Spreadsheet formula for removing Hebrew sin dot diacritics... | |
| =SUBSTITUTE(G15, char(1474), "") | |
| generating Spreadsheet formula for removing Mandaic diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G15, char(2137), ""), char(2138), ""), char(2139), "") | |
| generating Spreadsheet formula for removing Samaritan diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G15, char(2070), ""), char(2071), ""), char(2072), ""), char(2073), ""), char(2074), ""), char(2075), ""), char(2076), ""), char(2077), ""), char(2078), ""), char(2079), ""), char(2080), ""), char(2081), ""), char(2082), ""), char(2083), ""), char(2084), ""), char(2085), ""), char(2086), ""), char(2087), ""), char(2088), ""), char(2089), ""), char(2090), ""), char(2091), ""), char(2092), ""), char(2093), "") | |
| generating Spreadsheet formula for removing Syriac diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G15, char(1809), ""), char(1840), ""), char(1841), ""), char(1842), ""), char(1843), ""), char(1844), ""), char(1845), ""), char(1846), ""), char(1847), ""), char(1848), ""), char(1849), ""), char(1850), ""), char(1851), ""), char(1852), ""), char(1853), ""), char(1854), ""), char(1855), ""), char(1856), ""), char(1857), ""), char(1858), ""), char(1859), ""), char(1860), ""), char(1861), ""), char(1862), ""), char(1863), ""), char(1864), ""), char(1865), ""), char(1866), "") | |
| generating Spreadsheet formula for removing Yezidi diacritics... | |
| =SUBSTITUTE(SUBSTITUTE(G15, char(69291), ""), char(69292), "") | |
| Programmed by youtube.com/GrassDewMorning | |
| License for the formulas and text surrounding the formulas in this gist: | |
| This is free and unencumbered software released into the public domain. | |
| Anyone is free to copy, modify, publish, use, compile, sell, or | |
| distribute this software, either in source code form or as a compiled | |
| binary, for any purpose, commercial or non-commercial, and by any | |
| means. | |
| In jurisdictions that recognize copyright laws, the author or authors | |
| of this software dedicate any and all copyright interest in the | |
| software to the public domain. We make this dedication for the benefit | |
| of the public at large and to the detriment of our heirs and | |
| successors. We intend this dedication to be an overt act of | |
| relinquishment in perpetuity of all present and future rights to this | |
| software under copyright law. | |
| THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, | |
| EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF | |
| MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. | |
| IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR | |
| OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, | |
| ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR | |
| OTHER DEALINGS IN THE SOFTWARE. | |
| For more information, please refer to <http://unlicense.org/> | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment