{"id":1614,"date":"2024-02-13T06:30:26","date_gmt":"2024-02-13T06:30:26","guid":{"rendered":"https:\/\/www.aegissofttech.com\/insights\/?p=1614"},"modified":"2025-09-24T11:10:33","modified_gmt":"2025-09-24T11:10:33","slug":"replace-special-character-with-similar-character","status":"publish","type":"post","link":"https:\/\/www.aegissofttech.com\/insights\/replace-special-character-with-similar-character\/","title":{"rendered":"Does Replace a Special Character With Similar Character!"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1614\" class=\"elementor elementor-1614\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7511bd36 e-flex e-con-boxed e-con e-parent\" data-id=\"7511bd36\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-483b5fc2 elementor-widget elementor-widget-text-editor\" data-id=\"483b5fc2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Overview: Special Character With Similar Character<\/h2><p>In any kind of File Integration (Export\/Import of a file) in <a href=\"https:\/\/www.aegissofttech.com\/microsoft-dynamics-365-business-central.html\">dynamics 365 business central services<\/a>, it is often required for the developer to check the data before whether they contain any special characters which can lead to a wrong file generation.<\/p><p>So, in most of the cases, it is required to replace any special character i.e., Comma (,) or Dot(.) with space or any other character.<\/p><p>For example, if we need to export a CSV file from BC containing master data information or journal entries, we need to be careful about Comma (,) coming into any cell value. Otherwise, the cell will move to next because of the comma.<br \/><img decoding=\"async\" class=\"alignnone wp-image-1616 size-full\" src=\"https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/02\/special-character-step1.jpg\" alt=\"special-character-step1\" width=\"211\" height=\"83\" title=\"\"><br \/>After export,<br \/><img decoding=\"async\" class=\"alignnone wp-image-1617 size-full\" src=\"https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/02\/special-character-step2.jpg\" alt=\"special-character-step2\" width=\"267\" height=\"71\" title=\"\"><br \/>So, to replace this comma we can use a function called CONVERTSTR.<br \/><code>String: = CONVERTSTR (String, FromCharacters, ToCharacters)<\/code><\/p><h3>Example:<\/h3><p><code>String: = CONVERTSTR(String,\u2019,\u2019,\u2019-\u2019); Here I am replacing comma with \u2018-\u2018<\/code><\/p><p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-1618 size-full\" src=\"https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/02\/special-character-step3.jpg\" alt=\"special-character-step3\" width=\"508\" height=\"166\" title=\"\" srcset=\"https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/02\/special-character-step3.jpg 508w, https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/02\/special-character-step3-300x98.jpg 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/p><p>The new value will be:<br \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1619 size-full\" src=\"https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/02\/special-character-step4.jpg\" alt=\"special-character-step4\" width=\"267\" height=\"99\" title=\"\"><\/p><h2>Conclusion<\/h2><p>That is how we can replace commas or any similar special character in a field by using this <strong>string function CONVERTSTR<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":" ","protected":false},"author":9,"featured_media":1615,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[124],"tags":[348,349,350],"class_list":["post-1614","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-central","tag-business-central-services","tag-similar-character","tag-special-character"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/posts\/1614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/comments?post=1614"}],"version-history":[{"count":7,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/posts\/1614\/revisions"}],"predecessor-version":[{"id":12221,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/posts\/1614\/revisions\/12221"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/media\/1615"}],"wp:attachment":[{"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/media?parent=1614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/categories?post=1614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/tags?post=1614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}