How can remove the 'tp.' from below string from each place where it is coming
str = " tp.FirstName, tp.FamilyName, tp.DOB, tp.TypeOfLocation
WHERE
tp.DateStamp BETWEEN '2012-02-12 15:13:00' AND '2013-02-12 15:13:00'
AND tp.db_name_id =21
AND
tp.FirstName = 'Darlene'";
I need result as below:
FirstName, FamilyName, DOB, TypeOfLocation
WHERE
DateStamp BETWEEN '2012-02-12 15:13:00' AND '2013-02-12 15:13:00'
AND db_name_id =21
AND
FirstName = 'Darlene'";
Simple:
str = str.replace(/\btp\./g, '');
This uses a regex to search for all occurrences of tp\. in the string, and replaces them with a empty string, effectively removing it.
(The period is escaped, since that's a special character in regexes. It literally searches for tp..
The \b is a word boundary, making sure that tp. is at the start of a word.)
Or, the split/ join method:
str = str.split('tp.').join('');
This will split up the string at every occurrence of 'tp.' (Without copying that along), then join the array together, resulting in a string where 'tp.' was removed.
/\btp\./ just in case.
=sign can be switched around). What I'm trying to say is: jQuery is a JS library. Saying "JavaScript or jQuery" makes perfect sense, since there's a difference between using native JS and jQuery.jQeury is not javascriptandjavascript is not jqueryshould both be either true or false. Which is not the case. Further the mathematical binary relation equality is also transitive so if the is was indeed a mathematical operation then "jquery is javascript" and "javascript is a scripting language" would also imply that "jquery is a scripting language" which is clearly not the case either :)