Hi all,
I have a view showing titles of real documents which our office maintains. Unfortunately during cataloging some of the titles have been entered more than once, but possibly with a slight change of punctuation or case. I want to be able to categorise the titles so I can see which ones are duplicated but it is not quite as simple as that. I want the categorised column of the view to contain the title in all lowercase (easy) but also without any non-alpha-numeric characters other than spaces.
Can anyone think of an easy way to do this in a view column formula? I don't want to have to explicitly replace every possible character with an empty string because there are too many. And I am not allowed to add another field to the documents to calculate the value I want using Lotus Script or Java.
Thanks in advance. I am looking forward to some interesting ideas.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I was afraid that was the answer I might receive. I have to compile the list on Monday and wanted to spend as little time on it as possible. Since I can't change the data on the production system, mostly because I have been directed not to do so by management, I may have to export the view to CSV and run a shell script on it to compile the list. Still haven't figured out the best way to do that either, but here is not the place to ask such questions.
I will leave the question open for a few days to see if anyone comes up with anything new.
Thanks for the suggestions so far.
There's also the @For in the Formula language. It's a horrible construction that had better not be used in a view. But if all else fails...
I'm much in favour of the Implode/Explode method, for you can create the string manually. Actually, you might need an additional @Trim in it, but that won't spoil the fun. If you know the ASCII-codes of the characters you need to replace, you could use a combination of the following
nonchar:= "!\"#$%&'()*+,-./" + ":;<=>?@" + "[\\]^_`" + "{|}~";
ctrlchar:= @Char(0) + @Char(1) + ... + @Char(32) + @Char(127);
@Implode(@Trim(@Explode(yo
@SoundEx no good??
sjef_bosman, you put me onto a good idea so you can have the points. I used your method of imploding and exploding to get the string of characters I didn't want and then a similar method to remove them. What I ended up with was this:
lowerString := @Implode(@LowerCase(inputS
charsToRemove := @Implode(@Explode(lowerStr
finalString := @Implode(@Explode(lowerStr
@Explode(finalString; "~")
Business Accounts
Answer for Membership
by: sjef_bosmanPosted on 2005-09-16 at 03:05:48ID: 14896710
There is
@ReplaceSubstring(yourstri
or
@Implode(@Explode(yourstri
There's another feature of Notes that might be helpful: @Soundex