Forum Discussion

vaidyarm's avatar
vaidyarm
Contributor
4 years ago
Solved

How to split date into multiple rows from one row based on specific condition

Hi I need to form multiple records from one row based on date criteria, and the criteria are that when start date and end date have a difference of more than 1 year, it should have multiple rows f...
  • koryknick's avatar
    koryknick
    2 years ago

    I didn't notice before, but you don't want to have anything in the Multipart sub-type property.  Clear that $ from the expression and uncheck the expression enabler.

     

siwadon's avatar
siwadon
Employee
4 years ago
Copy LinkReport

$notes.replace(/.*(#IF:.{9}).*/, (...args) => args[1])

It replaces the matched string with the first capture group (#IF: and the following 9 characters).

This will not work correctly when the input contains multiple matches. If that’s the case, please let me know. You might need to use .match() instead.