Hi,
I have a column like QDL Marine and Static Diesel Engines (In).
Now I need to make it like QDL Marine and Static Diesel Engines (In).The length of this value differs from record to record.
I tried with convert but then it become QDL Marie ad Static Diesel Egies.
Please suggest.
Thanks,
Arnie
right truncate in transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 101
- Joined: Mon Aug 13, 2007 2:32 am
The trims may not be strictly needed but make this more fool-proof:
Pop quiz: what exactly is this doing?
Code: Select all
Field(Trim(YourField)," ",1,DCount(Trim(YourField)," ")-1)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
So, Arnie... not going to take the pop quiz?
I generally don't like to give pure code solutions for things like this as I'm afraid there's no learning going on, one can simply plug it in and move on without have to actually understand how it works. I feel like I'm handing out fish rather than a fishing pole. Oh, well, hope you take the time to break it down and understand the bits so you can leverage the techniques elsewhere should the need arise.
I generally don't like to give pure code solutions for things like this as I'm afraid there's no learning going on, one can simply plug it in and move on without have to actually understand how it works. I feel like I'm handing out fish rather than a fishing pole. Oh, well, hope you take the time to break it down and understand the bits so you can leverage the techniques elsewhere should the need arise.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers