Skip to main content

Reply to "Data Table Practice!"

Puppy posted:
quote:
Currently I search the string for a '(' and then back up one. I did have to manually do SOME things with the names. '@' and '_' have to be removed manually, and names longer than 15 chars have to be shortened by hand, but that should not be to much of a problem to fix.



If-then-else?
If string length>15, truncate at 15
If string contain "@" or "_" characters, truncate including those characters, else truncate at "(" including that character.

"It's always better to kill hours & days figuring out how to program a task rather than taking the few moments it requires to do the task manually!" Wink I think it's Geek Law #18, or something... Wink

quote:
That is a feature comming in the next release !


"No matter how good your program works, you can always make it better, or do more!" Geek Law #89. Wink

What bugs me is that I haven't figured out how to do in Excel, what you've done in Lotus! Roll Eyes
"Applications will always work better when written in a different software." Geek Law #33

Jabbergah                                                    
×
×
×
×