I got the following string: NPA-Woodburn,OR,Woodburn,OR,97071,Bensenville,IL,60106,150.00,0.00,cash/certified funds,,enclosed,operable,,,,,
I need to loop through some rows and sum the 9th text after ",", but I just can't get to it. I've seen many combinations of solutions, but none gets me there.
Thank you.
You can split the string by that character, remove all items in the array before the 9th item (with slice), then join the array back by the character.
const character = ",";
const str = "NPA-Woodburn,OR,Woodburn,OR,97071,Bensenville,IL,60106,150.00,0.00,cash/certified funds,,enclosed,operable,,,,,";
const res = str.split(character).slice(9).join(',')
console.log(res)To isolate the 8th occurence, you can make the range in the slice call more specific:
const character = ",";
const str = "NPA-Woodburn,OR,Woodburn,OR,97071,Bensenville,IL,60106,150.00,0.00,cash/certified funds,,enclosed,operable,,,,,";
const res = str.split(character).slice(8,9)[0]
console.log(res)