How to remove Colon (:)

[Former Member]

Hi,

Source Field : TIME

which is in the format 12:42:57

Target Field : LOGTIM

which i need to remove the colon ":" and the output should be here like 124257.

Please help me on this...

Thanks & Regards,

Y.Raj.

[bhavesh_kantilal · Accepted solution]

Use the ReplaceString Function as a part of the standard functions from SAP under text functions.

Regards

Bhavesh

[Former Member]

Hi,

u can use Replace String functions:

First input = your string (eg: HH:MM:SS)

Second Input = ":"

Third Input = ""

Output of ReplaceString function = HHMMSS

Thanks,

Madhav

Note: Points If Useful

[Former Member]

u can do it simply by using DateTrans function

TIME----> DateTrans--->LOGTIM

double click on DateTrans and use the fllowing

Format of source structure(HH:mm:ss)

Format of target structure(HHmmss)

Edited by: biplab das on Sep 22, 2008 6:22 PM

[former_member192295]

Hi,

For time format change we don't have standard function need to develop UDF, it can sort out easily.

[former_member189441]

Hi ,

Use substring function and concat all 3 substrings.

TIME(12:42:57)-->Substring(0,2) --- 1

TIME(12:42:57)-->Substring(3,2) -

---

2

TIME(12:42:57)-->Substring(6,2) -

---

3

concat function(1,2) --->newstring

concat function(newstring, 3)

[Former Member]

Hi,

Have a Look at this Screenshot.

You have to use Replace String option which is available in Text Standard Function & Just Use Blank in the Third Argument

http://img176.imageshack.us/my.php?image=replacestringoo4.jpg

Regards

Seshagiri