About Sume77

Sume77 · ‎09-24-2017

Thanks @tsharma.. This works.. Thank you 🙂

Sume77 · ‎09-21-2017

@tsharma Thanks for your prompt reply..i'll try this approach but by-tagFile we tagged file name with all the column name, here what i want is to create a new column like date and store the file name in it.. Thank you.

Sume77 · ‎09-20-2017

I have a file with name YYYYMMDD_claims_portal.csv, i need only YYYYMMDD part and store this value in new column(say,date). Earlier we have 3 column like Claim,User,ID. now i need to add one more column date having value as YYYYMMDD as per file. Please help, its bit urgent. Thanks in advance for any help you guys can provide.

Online	Offline
Last Visited	‎09-20-2017 10:09 PM

Member Since	‎09-20-2017 07:42 AM
Last Visited	‎09-20-2017 10:09 PM
Posts	4

Cloudera Community

Cloudera Community

Re: Extract timestamp from filename and add it in ...

Re: Extract timestamp from filename and add it in ...

Extract timestamp from filename and add it in new ...