How to remove special chars from input data using php
My dataentry team searches for records online and then copy paste some records. That goes in my DB and then through PHP code I am generating XLS file to download those records.
I am removing HTML tags from the input records. But from time to time I get some invalid chars because of which XLS file don't open and give an error.What is best solution to overcome this issue. Thanks.
php
edited Nov 12 '18 at 5:15
Billal Begueradj
5,699132638
asked Nov 12 '18 at 3:48
farazch
6
add a comment |
My dataentry team searches for records online and then copy paste some records. That goes in my DB and then through PHP code I am generating XLS file to download those records.
I am removing HTML tags from the input records. But from time to time I get some invalid chars because of which XLS file don't open and give an error.What is best solution to overcome this issue. Thanks.
php
edited Nov 12 '18 at 5:15
Billal Begueradj
5,699132638
asked Nov 12 '18 at 3:48
farazch
6
1
welcome to StackOverflow; please review how to ask a good question; please provide a minimal, complete, and verifiable example
– landru27
Nov 12 '18 at 3:57
add a comment |
My dataentry team searches for records online and then copy paste some records. That goes in my DB and then through PHP code I am generating XLS file to download those records.
I am removing HTML tags from the input records. But from time to time I get some invalid chars because of which XLS file don't open and give an error.What is best solution to overcome this issue. Thanks.
php
edited Nov 12 '18 at 5:15
Billal Begueradj
5,699132638
asked Nov 12 '18 at 3:48
farazch
6
My dataentry team searches for records online and then copy paste some records. That goes in my DB and then through PHP code I am generating XLS file to download those records.
I am removing HTML tags from the input records. But from time to time I get some invalid chars because of which XLS file don't open and give an error.What is best solution to overcome this issue. Thanks.
php
php
edited Nov 12 '18 at 5:15
Billal Begueradj
5,699132638
asked Nov 12 '18 at 3:48
farazch
6
edited Nov 12 '18 at 5:15
Billal Begueradj
5,699132638
asked Nov 12 '18 at 3:48
farazch
6
edited Nov 12 '18 at 5:15
Billal Begueradj
5,699132638
edited Nov 12 '18 at 5:15
Billal Begueradj
5,699132638
edited Nov 12 '18 at 5:15
Billal Begueradj
5,699132638
5,699132638
asked Nov 12 '18 at 3:48
farazch
6
asked Nov 12 '18 at 3:48
farazch
6
asked Nov 12 '18 at 3:48
farazch
6
6
1
welcome to StackOverflow; please review how to ask a good question; please provide a minimal, complete, and verifiable example
– landru27
Nov 12 '18 at 3:57
add a comment |
1
welcome to StackOverflow; please review how to ask a good question; please provide a minimal, complete, and verifiable example
– landru27
Nov 12 '18 at 3:57
1
1
welcome to StackOverflow; please review how to ask a good question; please provide a minimal, complete, and verifiable example
– landru27
Nov 12 '18 at 3:57
welcome to StackOverflow; please review how to ask a good question; please provide a minimal, complete, and verifiable example
– landru27
Nov 12 '18 at 3:57
add a comment |
1 Answer
1
active
oldest
votes
your remove special char one by with this shot line of code.
<?php
$spl_arr = array("<",">"@","$","!","$"); //put all special char here
$your_string="here !s @ s@ample $tring to remove $pecial char";
foreach ($spl_arr as $value) {
//$your_string.replace($value,"new_char or blank space");
$your_string.replace($value,"");
}
// $your_string is now "here s sample tring to remove pecial char"
?>
answered Nov 12 '18 at 4:54
Mahendra Gohil
8510
Thanks for the answer. I can remove special char with this code but i am seeing strange characters like â‚ € and few more. How these can be removed from the string using php ?
– farazch
Nov 12 '18 at 11:18
have you checked this : stackoverflow.com/questions/1189007/…
– Mahendra Gohil
Nov 12 '18 at 11:35
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53255717%2fhow-to-remove-special-chars-from-input-data-using-php%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
your remove special char one by with this shot line of code.
<?php
$spl_arr = array("<",">"@","$","!","$"); //put all special char here
$your_string="here !s @ s@ample $tring to remove $pecial char";
foreach ($spl_arr as $value) {
//$your_string.replace($value,"new_char or blank space");
$your_string.replace($value,"");
}
// $your_string is now "here s sample tring to remove pecial char"
?>
answered Nov 12 '18 at 4:54
Mahendra Gohil
8510
Thanks for the answer. I can remove special char with this code but i am seeing strange characters like â‚ € and few more. How these can be removed from the string using php ?
– farazch
Nov 12 '18 at 11:18
have you checked this : stackoverflow.com/questions/1189007/…
– Mahendra Gohil
Nov 12 '18 at 11:35
add a comment |
your remove special char one by with this shot line of code.
<?php
$spl_arr = array("<",">"@","$","!","$"); //put all special char here
$your_string="here !s @ s@ample $tring to remove $pecial char";
foreach ($spl_arr as $value) {
//$your_string.replace($value,"new_char or blank space");
$your_string.replace($value,"");
}
// $your_string is now "here s sample tring to remove pecial char"
?>
answered Nov 12 '18 at 4:54
Mahendra Gohil
8510
Thanks for the answer. I can remove special char with this code but i am seeing strange characters like â‚ € and few more. How these can be removed from the string using php ?
– farazch
Nov 12 '18 at 11:18
have you checked this : stackoverflow.com/questions/1189007/…
– Mahendra Gohil
Nov 12 '18 at 11:35
add a comment |
your remove special char one by with this shot line of code.
<?php
$spl_arr = array("<",">"@","$","!","$"); //put all special char here
$your_string="here !s @ s@ample $tring to remove $pecial char";
foreach ($spl_arr as $value) {
//$your_string.replace($value,"new_char or blank space");
$your_string.replace($value,"");
}
// $your_string is now "here s sample tring to remove pecial char"
?>
answered Nov 12 '18 at 4:54
Mahendra Gohil
8510
your remove special char one by with this shot line of code.
<?php
$spl_arr = array("<",">"@","$","!","$"); //put all special char here
$your_string="here !s @ s@ample $tring to remove $pecial char";
foreach ($spl_arr as $value) {
//$your_string.replace($value,"new_char or blank space");
$your_string.replace($value,"");
}
// $your_string is now "here s sample tring to remove pecial char"
?>
answered Nov 12 '18 at 4:54
Mahendra Gohil
8510
answered Nov 12 '18 at 4:54
Mahendra Gohil
8510
answered Nov 12 '18 at 4:54
Mahendra Gohil
8510
answered Nov 12 '18 at 4:54
Mahendra Gohil
8510
8510
Thanks for the answer. I can remove special char with this code but i am seeing strange characters like â‚ € and few more. How these can be removed from the string using php ?
– farazch
Nov 12 '18 at 11:18
have you checked this : stackoverflow.com/questions/1189007/…
– Mahendra Gohil
Nov 12 '18 at 11:35
add a comment |
Thanks for the answer. I can remove special char with this code but i am seeing strange characters like â‚ € and few more. How these can be removed from the string using php ?
– farazch
Nov 12 '18 at 11:18
have you checked this : stackoverflow.com/questions/1189007/…
– Mahendra Gohil
Nov 12 '18 at 11:35
Thanks for the answer. I can remove special char with this code but i am seeing strange characters like â‚ € and few more. How these can be removed from the string using php ?
– farazch
Nov 12 '18 at 11:18
Thanks for the answer. I can remove special char with this code but i am seeing strange characters like â‚ € and few more. How these can be removed from the string using php ?
– farazch
Nov 12 '18 at 11:18
have you checked this : stackoverflow.com/questions/1189007/…
– Mahendra Gohil
Nov 12 '18 at 11:35
have you checked this : stackoverflow.com/questions/1189007/…
– Mahendra Gohil
Nov 12 '18 at 11:35
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53255717%2fhow-to-remove-special-chars-from-input-data-using-php%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
welcome to StackOverflow; please review how to ask a good question; please provide a minimal, complete, and verifiable example
– landru27
Nov 12 '18 at 3:57