Regex extracting and parsing Date

[RajivKumar12 (Rajiv Kumar)]

Any idea with this issue guys ? Thank you
Current progress.
Main.xaml (11.3 KB) project.json (998 Bytes)

Data

 "Filtered Data: −−DATE−−       ECOA   KOB     MEMBER−NO
06/12/20       B      QM      02004946        TEST DATA MORTGAGE                                               TRU
04/22/20       B      BC      2844550        COMPANY XCYS                                                        XPN
                      BC      03575459        CAPITAL ONE                                                       TRU
                      BB      484BB05812      CAPITALTWO                                                        EFX
04/16/20       B      FR      3996926         CRET                                                           XPN
                              181ZB14416      CREDOS                                                           EFX
                      FM      01207005         BANK  R     

If date is empty check for the parent for example the parent date of BANK R , CREDOS IS 04/16/20

Example output

06/12/20  TEST DATA MORTGAG
04/22/20 COMPANY XCYS
04/22/20  CAPITAL ONE
04/22/20  CAPITALTWO
04/16/20  CRET
04/16/20 CREDOS
04/16/20  BANK  R

[Srini84 (Srinivas)]

@RajivKumar12

How you determine the date 04/22/20 not 06/12/20?

Thanks

[RajivKumar12 (Rajiv Kumar)]

what do you mean?

[RajivKumar12 (Rajiv Kumar)]

@RajivKumar12

06/12/20 B QM 02004946 TEST DATA MORTGAGE

because the date changes on the nextline already

[Srini84 (Srinivas)]

@RajivKumar12

How we know that that’s a parent record?

If there is a null in date then we need to copy the above row date which is not null

Is that correct?

Thanks

[RajivKumar12 (Rajiv Kumar)]

yes , that is correct , you can check the pattern on the output , sorry for using the work parent

[RajivKumar12 (Rajiv Kumar)]

@Srini84 , Have you got the idea now Sir ?

[Srini84 (Srinivas)]

@RajivKumar12

Check as below

PreviousRowValue.zip (3.7 KB)

Mark as solution if this helps

Thanks

[RajivKumar12 (Rajiv Kumar)]

Thank you very much Sir , such a big help.

[RajivKumar12 (Rajiv Kumar)]

If you have questions about node js and angular or javascript dont hesitate to contact me , best regards