Regex extracting and parsing Date

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

@RajivKumar12

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

Thanks

what do you mean?

because the date changes on the nextline already

@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

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

@ksrinu070184 , Have you got the idea now Sir ?

@RajivKumar12

Check as below

PreviousRowValue.zip (3.7 KB)

Mark as solution if this helps

Thanks

1 Like

Thank you very much Sir , such a big help.

1 Like

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.