Hello,
I want to trim the leading and trailing occurance of *.
Input field = ***abc***. output should be abc
If i use TRIM(***abc****,'*','B') but i am getting the output as
abc***. In the help section i found that B will remove all the leading and trailing characters.
Just Trim(***abc****,'*') gave me abc*
Thanks
TRIM function
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
Re: TRIM function
Trim (Col,'*','A')
Ereplace also help you.
Refer the help.
DS User
Ereplace also help you.
Refer the help.
DS User
Re: TRIM function
In my 8.0.1 FP1a installation I get 'abc' for TRIM(DUMMY,'*','B') where DUMMY has the value '***abc****'. The TRIM-function you quoted is invalid (missing quotes).just4u_sharath wrote:If i use TRIM(***abc****,'*','B') but i am getting the output as
abc***.
What version are You running?
Edit: TRIM(DUMMY,'*') returns the same.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
-
- Premium Member
- Posts: 62
- Joined: Tue Dec 07, 2004 7:41 am
- Location: Brasil
- Contact:
Re: TRIM function
Do you want remove only leading and trailing characters? not all characters?
E.g.:
The result for "***ab*c***" and "***abc*****" will be different?
If you dont have success with "trim", try use "convert" function.
Convert("*","",DUMMY)
Best regards!
E.g.:
The result for "***ab*c***" and "***abc*****" will be different?
If you dont have success with "trim", try use "convert" function.
Convert("*","",DUMMY)
Best regards!