Forum Discussion

rashmi's avatar
rashmi
New Contributor III
3 years ago

Dynamically parse the excel without having sheet index or sheet name

Hi, Anyone aware of how do we parse the excel with multisheet without even knowing sheet index / sheet name with having certain number of records in each sheet. I am having requirement to remove ...
cjhoward18's avatar
cjhoward18
Employee
4 years ago
Copy LinkReport

Using a mapper and assuming your input text is at the key $text you can use the following expression to achieve your goal:

$text.split("").reverse().reduce((accum, cur) => (accum.length - accum.split("+").length +1) % 3 == 0 ? accum + "+" + cur: accum + cur).split("").reverse().join("")