DSXchange

Hi,

What is the meaning of below warning

APT_CombinedOperatorController,0: Invalid character conversion found converting to ISO-8859-1, substituting.

Thanks

It is working.

Thanks

If the record has 00000000 value in that field that I am supposed to conver to date then I have given the fallwoing function. If IsNull(DSLink9.A) Then 0 Else (StringToDate(DSLink9.A,"%yyyy%mm%dd")) but it is giving fallowing error while compiling. Invalid conversion requested while conver...

In one way it's working.

I mean if the record has 20060303 that function is working
If the value is in 00000000 then it is giving **** value

StringToDate(DSLink9.A,"%yyyy-%mm-%dd")

Hi, I am reading from a file and writing to another file. One of the fields need a string to date conversion I used the function String To Date conversion in the Transformer. When I use it it's giving out put ***** manner. What is the reason for it? Input data is 20061203 format output I need to get...

Ok, source field data is in 20050503 (sting) format I want to convert it to timestamp.
Bisically I am getting ****** type of data in the output file for each and every record.

There are no nulls as you said.[/quote]

You will get these kind of results if your source string field is converted properly into the timestamp format before conversion or there migght be nulls in your source string column. If there are nulls then check for nulls and then convert it into timestamp. Ok, source field data is in 20050503 (s...

Hi- I have one funny thing going on with my job. One of the fields in my job needs string to timestamp conversion for that I used the fallowing function. StringToTimestamp((DSLink5.SrcFileDt): "00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss") This is working good. But when I use the same f...

Hi-


What exactly this warning means

APT_CombinedOperatorController(0),0: Invalid character conversion found converting to ISO-8859-1, substituting.


Thanks.

Nevermind.

It is working I used the fallowing
StringToTimestamp(Trim(DSLink77.B):" 00:00:00","%yyyy%mm%dd %hh:%nn:%ss")

That is working good.

Anyhow thankyou somuch for your help

Thanks.

APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%yyyy%mm%dd%" for conversion "timestamp=timestamp_from_ustring[%yyyy-%mm-%dd %hh:%nn:%ss](ustring)": APT_Conversion_String_TimeStamp: Invalid Format [%yyyy%mm%dd%] used for s...

When I use this function the data(only two records) is going upto transformer and after that nothing is going to output file.

Lookup key values is 1970-01-01 00:00:00

DSLINK88 is connected to lookup stage. Ok I tried to write the output data to a file. by applying string to timestamp conversion function in the transformer for a field with char datatype to timestamp datatype but when I see the data of the field that I want to see as timestamp it was ****** in the ...