on 09-22-2008 12:46 PM
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.
Use the ReplaceString Function as a part of the standard functions from SAP under text functions.
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For time format change we don't have standard function need to develop UDF, it can sort out easily.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.