Remove value from comma delimited string

[Access]

I have a string: A-001, A-003, A-004, A-0016

This is what i'm doing to remove a value(strValue) from this string:

var strPatternComma = new RegExp(', ' + strValue, 'gi');
tempText = tempText.replace(strPatternComma , '');
var strTextPattern = new RegExp(strValue, 'gi');
tempText = tempText.replace(strTextPattern , '');

I have a small problem with it. Let's say i need to remove value "A-001" from it, it does remove it but it also removes a "A-0016" part of the "A-0016".

Please help, thanks

[Rakuli]

If you construct your patter and don't remove the commas, you can just search for the commas on either side. If you need the commas to remain, use backreferences in your replace.

Code: Select all

var strPattern = new RegExp('(,[\s]{1})(' + strValue + ',)', 'gi');

tempText = tempText.replace(strPattern, '$1');

[Access]

Originally Posted by Rakuli

If you construct your patter and don't remove the commas, you can just search for the commas on either side. If you need the commas to remain, use backreferences in your replace.

Code: Select all

 
var strPattern = new RegExp('(, )(' + strValue + ',)', 'gi');
 
tempText = tempText.replace(strPattern, '$1');

Sorry not clear for me, can you elaborate it a little. Also there is a possibility that one of the values may have a comma inside of it as well., like this(in red): A-001, B-CD, A,BC, A-003

[Rakuli]

Well I assume that strValue contains the value that you are looking for so all you need to do is construct the pattern so that it matches the commas on either side. Then when you replace, you replace the pattern.

Let's say strValue contains A,BC

The patter looks like this

(,[\s]{1})(A,BC,)

The first set of parenthesis is looking for a comma followed by one space. The next lot searches for the strValue (A,BC) followed immediately by a comma.

When you are using the replace function you can use backreferences in your replace string. $1 will represent the first set of parenthesis $2 the second etc.

So you replace string looks like this '$1' which basically means replace the whole thing with what was matched in the first set of brackets ', '.. This will mean the value will be taken out literally and not part of another string because it is matching against the comma that comes after it.

[Access]

Originally Posted by Rakuli

Well I assume that strValue contains the value that you are looking for so all you need to do is construct the pattern so that it matches the commas on either side. Then when you replace, you replace the pattern.

Let's say strValue contains A,BC

The patter looks like this

(,[\s]{1})(A,BC,)

The first set of parenthesis is looking for a comma followed by one space. The next lot searches for the strValue (A,BC) followed immediately by a comma.

When you are using the replace function you can use backreferences in your replace string. $1 will represent the first set of parenthesis $2 the second etc.

So you replace string looks like this '$1' which basically means replace the whole thing with what was matched in the first set of brackets ', '.. This will mean the value will be taken out literally and not part of another string because it is matching against the comma that comes after it.

Thank you very much for explaining it. I still can not get it right, it looks i'm doing something wrong.

To simplify it, i delimit string with semi-column(; ) instead of comma(,) .
This is what i have right now:
var strPattern = new RegExp('(;[\s]{1})(' + strValueName + ')');
tempText = tempText.replace(strPattern, '$2');

and these are parameters:
strValueName = A-002
tempText = A(1-7); A-00000762; A-0001; A-001; A-0026; A-002; A-003; A-007; A-007, Tigris; A-02056; A-1 polyphenols, PhytoMedical

Is there something wrong with my RegEx?

[Rakuli]

Try escaping the semi colon with a backslash.