Search found 3 matches

Go to advanced search

by suneel kumar
Sun Mar 19, 2006 10:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: I want Date Format
Replies: 2
Views: 1016

I want Date Format

Hi All,

i want dateformat.

Example:

Input(200603) here year month


output(20060301) Here year month day

here every time day start on 01 by default in output.

Thanks in advance,

suneel
by suneel kumar
Thu Mar 16, 2006 11:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to elimanitate space
Replies: 7
Views: 2234

Thanks Balaji

rasi wrote:Suneel

As Balaji mentioned you can use Ereplace function to replace space.

Syntax:
Ereplace(InputValue,' ','')

Example
Ereplace('suneel reddi',' ','')

Result : suneelreddi


Regards
by suneel kumar
Thu Mar 16, 2006 10:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to elimanitate space
Replies: 7
Views: 2234

how to elimanitate space

Hi,

in the source date like "suneel reddi" but i want output like "suneelreddi"

pls give me sucessions.

thanks in advance

suneel

Go to advanced search