Flatfile Datasource - Conversion Routine for TIMS-field?

[Former Member]

The situation:

A timestamp has to be loaded via flatfile.

External format: hh:mm:ss (8 digit); BW internal format of TIMS: 6 digit.

Documentation and different tries don't lead to a useful standard conversion routine (e.g. comparable to RSDAT for loading date fields). Is there actually no standard conversion routine?

Any hint would be welcome!

Regards

Elisabeth

[Former Member · Accepted solution]

Hi Elisabeth,

it sounds too easy to use a function, just use a routine:

If INPUT is a string length 8, the following would do the job in a routine:

Just replace the coding

RESULT = .

with

concatenate INPUT(2) INPUT+3(2) INPUT+6(2) into RESULT.

Kind regards,

Jürgen

Edited by: Jürgen Kirsch on Sep 9, 2008 9:50 AM

[Former Member]

A very late thanks for the suggestion - now it works.