Remove leading dot in the decimal value of fixed length

[spendem]

Hi All,

I want to remove the leading "." i.e dot in the decimal value.

Example: Input is date(10) = 2005-05-18 after coverting the date to decimal
Output is Decimal(8) = 20050518.

My requirement is to get Decimal(8) = 20050518 i.e I want to skip the . (dot) value.

I tried using trim function and even tried reading the output in Char and Varchar data type but didn't work out.

Can anyone please help me out on how to achieve this in Enterprise Edition.


Many Thanks,
Spendem

[mandyli]

Hi Spendem

try following one

[b]Trim("20050518.", ".", "A")[/b]


I hope it will give correct result..


Thanks
Man

[ray.wurlod]

The dot may not actually be there. It may be an artifact of the data browser. Does the dot get through to your target? If so, convert its data type to int64 or uint64 and the dot will vanish.

[spendem]

Hi,

Thanks for the answers,
Mandiyil what is ? I tried using it I am getting a validation error.

Ray,
If I m using BigInt or Integer(64) The preecing zeros seems to dissapear for Numeric field.

Is there any other round?

Many Thanks,
Sandeep

[mandyli]

Hi


i am sorry pls try following one. try Ray suggested way also.

Trim("20050518.", ".", "A")


Man

[mspanda]

Hi
i hope the following line helps you to get your required output

Ereplace("2005-05-18 ","-","")

Thanks
-Mspanda

Hi All,

I want to remove the leading "." i.e dot in the decimal value.

Example: Input is date(10) = 2005-05-18 after coverting the date to decimal
Output is Decimal(8) = 20050518.

My requirement is to get Decimal(8) = 20050518 i.e I want to skip the . (dot) value.

I tried using trim function and even tried reading the output in Char and Varchar data type but didn't work out.

Can anyone please help me out on how to achieve this in Enterprise Edition.


Many Thanks,
Spendem

[ray.wurlod]

If I m using BigInt or Integer(64) The preecing zeros seems to dissapear for Numeric field.

Leading zeroes are not relevant for integer data types. Your original question made no mention of any need to preserve leading zeroes. You can add leading zeroes later, but I can not think of any way to preserve non-significant leading zeroes AND losing the dot.