: 4204 | 102771 | 11462
|
: 14 : 18 : 4 |
We are parsing a CSV file we obtain from customer. Now, when importing data, we do Trim / FullTrim on each parameter. Where that kicks us is as apparently customer is now building that CSV from XML and instead of spaces, there are   characters in their data. These are non-breakable spaces in Unicode. And ofc Trim / FullTrim don't cut them off.
How about making Trim / FullTrim function to trim all spaces, not just regular one? Oh, and triming tabs would be great as well.
|
1) Bruce Currier9016 (26 Nov 2009)
I wouldn't make these the default behavior's of the TRIM/FULLTRIM functions, but adding them as optional parameters would be great.
2) Vlad Sh20511 (26 Nov 2009)
@ Bruce
+1
+1
3) Peter Presnell65165 (26 Nov 2009)
I think there are two issues here. One would be removing encoded space characters. That part I agree with.
The second is whether a non-breaking space is removable. I thought the whole point of a non-breaking space was to specifically denote that it should be treated like any other non-space character but visually represent it like a space. I don't favor having trim or fulltrim remove non-breaking spaces.
The second is whether a non-breaking space is removable. I thought the whole point of a non-breaking space was to specifically denote that it should be treated like any other non-space character but visually represent it like a space. I don't favor having trim or fulltrim remove non-breaking spaces.
4) Rob Goudvis13142 (26 Nov 2009)
Yes, but with optional parameters.
5) Dirk Stelloh4955 (26 Nov 2009)
Sounds good, but has to be an option/parameter. Maybe one should be able to add a list of unwanted chars?!
6) Vladimir Kocjancic764 (27 Nov 2009)
I wouldn't put it as a default behaviour, for sure.
In many other languages, Trim function is way more useful than in LotusScript. Pity, as a small effort could go a long way.
In many other languages, Trim function is way more useful than in LotusScript. Pity, as a small effort could go a long way.
7) Nikolay Yushmanov2520 (28 Sep 2010)
@ Dirk Stelloh
There is "Replace" function with that behaviour. I think, it's enough.
There is "Replace" function with that behaviour. I think, it's enough.
Welcome to IdeaJam™
You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.
Use IdeaJam to:
- Collect ideas from employees
- Solicit feedback and suggestions from employees and customers
- Run innovation contests and competitions
- Validate concepts
- Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top
IdeaJam™ works with:
- IBM Connections
- IBM Lotus Quickr
- Blogs and Wikis
- Websphere Portal
- Microsoft Sharepoint
- and other applications.
IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.
Learn more about IdeaJam >>
IdeaJam developed by
