How to differentiate date and date range values

Hi Experts,

I have flat files like below formats.

Krishna06062017
Murali06042017-06132017

like this I have multiple files and dates are interchangeable.

I want to load date format file(Krishna06062017) from source flat file
and load date range format file(Murali06042017-06132017). to another source file

how to differentiate date and date range formats when we use flat file as source.

Thanks and Regards,
Venki


ursfriend77 (BOB member since 2011-03-02)