How can I remove last * from each "organisations": value from the string without using JSON.parse() and remove last , from [] using javascript?

[asifakhtar]

Please not the values inside the string are all dynamic.

let abc = '[{"userid":"88623619","organisations":"Imperial College London*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Milton Keynes Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Dr Ahmed Ahmed","oversightGroupType":"Steering Committee"},{"userid":"88624025","organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust*","oversightGroupRole":"Public Member","oversightGroupMemberName":"Professor b b","oversightGroupType":"Advisory Group"},{"userid":"88623985","organisations":"Aberdeen And District Fibromyalgia Support Group*Additive Design Ltd*Altnagelvin Area Hospital*Ataxia UK*Tameside Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Chief TestTestRr TestTestRr","oversightGroupType":"Data Monitoring Committee"},]';

//the Desried Result is

//abc = '[{"userid":"88623619","organisations":"Imperial College London*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Milton Keynes Hospital NHS Foundation Trust","oversightGroupRole":"Chair","oversightGroupMemberName":"Dr Ahmed Ahmed","oversightGroupType":"Steering Committee"},{"userid":"88624025","organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust","oversightGroupRole":"Public Member","oversightGroupMemberName":"Professor b b","oversightGroupType":"Advisory Group"},{"userid":"88623985","organisations":"Aberdeen And District Fibromyalgia Support Group*Additive Design Ltd*Altnagelvin Area Hospital*Ataxia UK*Tameside Hospital NHS Foundation Trust","oversightGroupRole":"Chair","oversightGroupMemberName":"Chief TestTestRr TestTestRr","oversightGroupType":"Data Monitoring Committee"},]';
My Code which is not working:
let abc = '[{"userid":"88623619","organisations":"Imperial College London*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Milton Keynes Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Dr Ahmed Ahmed","oversightGroupType":"Steering Committee"},{"userid":"88624025","organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust*","oversightGroupRole":"Public Member","oversightGroupMemberName":"Professor b b","oversightGroupType":"Advisory Group"},{"userid":"88623985","organisations":"Aberdeen And District Fibromyalgia Support Group*Additive Design Ltd*Altnagelvin Area Hospital*Ataxia UK*Tameside Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Chief TestTestRr TestTestRr","oversightGroupType":"Data Monitoring Committee"},]';

    abc = abc.replace(/,(?=[^,]*$)/, '');

    let startIndex = 0;
    while ((startIndex = abc.indexOf('"organisations":', startIndex)) !== -1) { 
        let endIndex = abc.indexOf('*', startIndex + '"organisations":'.length);
        if (endIndex !== -1) {     
            abc = abc.slice(0, endIndex) + abc.slice(endIndex + 1);
        }
        startIndex += '"organisations":'.length;
    }

    console.log(abc);

 

[VBService]

Did you consider to use RegExp (Regular expressions)

const abc = '[{"userid":"88623619","organisations":"Imperial College London*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Milton Keynes Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Dr Ahmed Ahmed","oversightGroupType":"Steering Committee"},{"userid":"88624025","organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust*","oversightGroupRole":"Public Member","oversightGroupMemberName":"Professor b b","oversightGroupType":"Advisory Group"},{"userid":"88623985","organisations":"Aberdeen And District Fibromyalgia Support Group*Additive Design Ltd*Altnagelvin Area Hospital*Ataxia UK*Tameside Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Chief TestTestRr TestTestRr","oversightGroupType":"Data Monitoring Committee"}]';

// Find and replace the last '*' in each "organisations" value
let modifiedString = abc.replace(/(\*[^*]*)\*"/g, '$1"');
console.log(modifiedString);

1. (\[^]*): This is a capturing group that consists of:
   • \: Matches a literal ''.
   • [^*]: Matches any sequence of characters ( excluded) - this is a negated character class denoted by [^*].
     This combination captures everything up to the last '' in the "organisations" value. The * in the character class [^*] ensures that we can match any character except ''.
2. \": This part matches the last '' in the "organisations" value followed by a double quote ".

The g flag at the end of the regular expression (/(\[^])\"/g) enables the global flag, which allows the regular expression to match all occurrences in the input string, not just the first one.

In the replacement string '$1"', $1 refers to the content captured by the first capturing group (\[^]). So, it effectively replaces the last '' in each "organisations" value with an empty string and adds a double quote (").

Putting it all together, this regular expression is designed to identify and replace the last *" in each "organisations" value in the input string, achieving the desired result of removing the trailing '' from each "organisations" value.

 

[asifakhtar]

Did you consider to use RegExp (Regular expressions)

const abc = '[{"userid":"88623619","organisations":"Imperial College London*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Milton Keynes Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Dr Ahmed Ahmed","oversightGroupType":"Steering Committee"},{"userid":"88624025","organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust*","oversightGroupRole":"Public Member","oversightGroupMemberName":"Professor b b","oversightGroupType":"Advisory Group"},{"userid":"88623985","organisations":"Aberdeen And District Fibromyalgia Support Group*Additive Design Ltd*Altnagelvin Area Hospital*Ataxia UK*Tameside Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Chief TestTestRr TestTestRr","oversightGroupType":"Data Monitoring Committee"}]';

// Find and replace the last '*' in each "organisations" value
let modifiedString = abc.replace(/(\*[^*]*)\*"/g, '$1"');
console.log(modifiedString);

1. (\[^]*): This is a capturing group that consists of:
   • \: Matches a literal ''.
   • [^*]: Matches any sequence of characters ( excluded) - this is a negated character class denoted by [^*].
     This combination captures everything up to the last '' in the "organisations" value. The * in the character class [^*] ensures that we can match any character except ''.
2. \": This part matches the last '' in the "organisations" value followed by a double quote ".

The g flag at the end of the regular expression (/(\[^])\"/g) enables the global flag, which allows the regular expression to match all occurrences in the input string, not just the first one.

In the replacement string '$1"', $1 refers to the content captured by the first capturing group (\[^]). So, it effectively replaces the last '' in each "organisations" value with an empty string and adds a double quote (").

Putting it all together, this regular expression is designed to identify and replace the last '' in each "organisations" value in the input string, achieving the desired result of removing the trailing '' from each "organisations" value.

Thank you for your response. Your provided solution inadvertently removes asterisks from other properties, which is not the desired behaviour. For instance, if the "userid" property contains asterisks, they are also removed.

e.g
"userid":"88623619*123*" then it removes * from there as well.

 

[VBService]

But you provided sample of data as in this image ...

userid did not looks like

next time you ask a question you need to be more precise

Now you know how to work with RegExp, try changing the expression to omit numbers like the values in userid.

 

[asifakhtar]

But you provided sample of data as in this image ...
View attachment 2782
userid did not looks like
View attachment 2783
next time you ask a question you need to be more precise

Now you know how to work with RegExp, try changing the expression to omit numbers like the values in userid.

I did mention in my initial message that all values within the string are dynamic(Please not the values inside the string are all dynamic.) However, thank you for your assistance nonetheless.

 

[VBService]

Check this one ...

const abc = '[{"userid":"88623619*111*","organisations":"Imperial College London*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Milton Keynes Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Dr Ahmed Ahmed","oversightGroupType":"Steering Committee*"},{"userid":"88624025*222*","organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust*","oversightGroupRole":"Public Member","oversightGroupMemberName":"Professor b b","oversightGroupType":"Advisory Group*"},{"userid":"88623985*4442*","organisations":"Aberdeen And District Fibromyalgia Support Group*Additive Design Ltd*Altnagelvin Area Hospital*Ataxia UK*Tameside Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Chief TestTestRr TestTestRr","oversightGroupType":"Data Monitoring Committee*"}]';

let modifiedString = abc.replace(/\*"/g, "\"");
console.log(modifiedString);

e.g
"userid":"88623619*111*" => "userid":"88623619*111"
"oversightGroupType":"Steering Committee*" => "oversightGroupType":"Steering Committee"
"organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust*" =>
"organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust"

 

[asifakhtar]

Check this one ...

const abc = '[{"userid":"88623619*111*","organisations":"Imperial College London*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Imperial College Healthcare NHS Trust*Milton Keynes Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Dr Ahmed Ahmed","oversightGroupType":"Steering Committee*"},{"userid":"88624025*222*","organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust*","oversightGroupRole":"Public Member","oversightGroupMemberName":"Professor b b","oversightGroupType":"Advisory Group*"},{"userid":"88623985*4442*","organisations":"Aberdeen And District Fibromyalgia Support Group*Additive Design Ltd*Altnagelvin Area Hospital*Ataxia UK*Tameside Hospital NHS Foundation Trust*","oversightGroupRole":"Chair","oversightGroupMemberName":"Chief TestTestRr TestTestRr","oversightGroupType":"Data Monitoring Committee*"}]';

let modifiedString = abc.replace(/\*"/g, "\"");
console.log(modifiedString);

e.g
"userid":"88623619*111*" => "userid":"88623619*111"
"oversightGroupType":"Steering Committee*" => "oversightGroupType":"Steering Committee"
"organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust*" =>
"organisations":"Bangor University*Barnet, Enfield and Haringey Mental Health NHS Trust*Cambridge University Hospitals NHS Foundation Trust"

TXS a lot. Appreciated.