DSXchange

Tlam

Found the solution. Using NLS GB2313 to extract the data from the source.

Tlam

Hi, I have setup the connection to a sql server database but somehow I am not able to view and extract the Chinese characters properly. The database collation on sql server is set to Chinese_PRC_CI_AS , but when I see the properties of the connection to server it self it states SQL_Latin1_General_CP...

Tlam

hi Friends, we have solved the polish character problem in data stage to a maximum extent. now we are facing problem only whlie reading data from either odbc driver or oci driver. is there any nls setings i have to set at server end so that the data will be read by drivers properly. we are using So...

Tlam

I have checked the log. No warning at all. I tried to debug it. Somehow it process the empty field. But thanks all. I have used the following method.

I use field to extract the date and then Iconv/Oconv and concatenated with '00:00:00'

Tlam

Yes, you are right, my mistake. I will try to split it.

Tlam

Hi,

I have the same date format mm/dd/yyyy h:mi. I have used following on the stage variable.

Oconv(Iconv(Date, "D/MDY[2,2,4] MT"), "D/MDY[2,2,4] MTS").

When I run the job, the job runs successful, but the data is not shown in the table. Please advice.

Thanks

Tlam

Thanks all for your help. I found it as well, i forgot how to search and suddenly realize

Tlam

Hi, Please advice on following situation. I have a value coming from the source which normally should look like this '20080701' or '20071105' but sometimes they delivered this '20080000'. I want to build a check in the stage variables to exclude these incorrect values. Please advice me how to check ...

Tlam

chulett wrote:There are probably other ways, but I'd bring it in as a string, remove all the 'punctionation' and then divide by 100:
Code: Select all
Convert(",.","",LinkName.FieldName) / 100[/c ...[/quote]

Chulett, thanks for the advice, it worked.

Tlam

chulett wrote:There are probably other ways, but I'd bring it in as a string, remove all the 'punctionation' and then divide by 100:
Code: Select all
Convert(",.","",LinkName.FieldName) / 100[/c ...[/quote]

I will try if this helps. Thanks for the advice.

Tlam

I tried with Iconv and Oconv Mask Decimal function, with no luck.

some amount will be converted like this

1.250,09 -> 125009.00
1039.01 - > 1.04

Tlam

Hi,

Hope some can help me with below conversion. I have tried to search for a soultion but I couldn't find it.

This amount will come from the source 1.250,60 and I need to transform it to 1250.60

Please advice me how or where to look for this to help me further.

Thanks

Tlam

Tlam

Thanks guys for the advice :D

Tlam

Hi, I need some advice on following data extract. In the source there is a field with following data format A12-ABCDEFG123456 ^ 12345678 Now I want only the part ABCDEFG123456 I have tried Field(Mystring, "-", 1) which will give me result = A12 if I use Field(Mystring, "-", 2) it...

Tlam

Does this directory exist /home/staff/tlam/KimD/Jobs? It is trying to create /20070829 below this. The user running the job needs to be able to this directory. Hi Kim, Thanks for replying, for your information, I have filled in following information. Filepath: /home/staff/tlam/ Logopath: /home/staf...

DSXchange

Search found 16 matches

NLS settings to view/extract chinese characters

compare of 2 values

Decimal Conversion

Data extract from source