String manipulation
gerdami wrote on 31 Dec 2009 08:00
I would find useful to have basic string manipulation as a available in Excel:
- LEFT(text,num_chars)
- MID(text,start_num,num_chars)
- RIGHT(text,num_chars)
- FIND(find_text,within_text,start_num)
- LEN(text)
- SUBSTITUTE(text,old_text,new_text[,instance_num])
Example: SUBSTITUTE("James Kanjo"," ","%20")
ListPages/templating, I assume | By pieterh | 0 Comments | 07 Jan 2010 12:46 |
Comments: 1
page revision: 0, last edited: 31 Dec 2009 08:00
Reason/use case?
~ Leiger - Wikidot Community Admin - Volunteer
Wikidot: Official Documentation | Wikidot Discord server | NEW: Wikiroo, backup tool (in development)