Question Re: extracting date and time fields from csv file in Technology Q&A

extracting date and time fields from csv file

Former Member — Wed, 14 Dec 2011 17:12:50 GMT

I have date and time fields in the following format in a csv file

Date 11.12.2011

Time 00:00:02

What info objects should I extract these to at the moment I have choosen 0CALDAY (length 😎 and 0TIME (length 6) and am not getting the correct value

Thanks

Former Member — Wed, 14 Dec 2011 17:26:11 GMT

Hi,

While loading data from Flat file to BI, the Date format should be like this -

Eg:

Current format in CSV file (i guess)

Date 11.12.2011 (DD:MM:YYYY)

Time 00:00:02 (HH:MM:SS)

Change format in CSV file like

Date 20111211 (YYYYMMDD)

Time 000002 (HHMMSS)

Thanks,

Peddi

Former Member — Wed, 14 Dec 2011 20:44:32 GMT

hi,

check the following things 0calday is in format YYYYMMDD, in infoobject conversion routine should be PERI6,

also check the infoobject sequences and header columns used in csv file and 'ignore number of rows' in info package

regards,

laksh

Former Member — Wed, 14 Dec 2011 22:43:45 GMT

Changed the format from internal to external for the two fields

former_member182343 — Thu, 15 Dec 2011 07:16:31 GMT

Change your date and time format to YYYYMMDD and HHMMSS.

It doesn't allow the format you specified in th CSV file, SAP has a standard format and you are supposed to follow it.