News
|
I needed a way to extract the individual words from a sentence stored in a single character field. After some failed google searches and no desire to install a Datablade or write a C UDR for something that doesn't need to have killer performance, I decided to write my own quick and dirty SPL function. my_strtok(str, delim, token_num) will take a string, break it into individual tokens based the delimiter and return the Nth token of the string. Running this: execute function my_strtok("How now brown cow", " ", 3)
Would return the third token: brown Here is the code for my_strtok(), comments welcome on anything I might have missed in the logic. And when I say it is slow, I just mean it could be done in a different way and perform more efficiently, but for what I needed it works. create function my_strtok (str lvarchar(2048), delim char(1), token_num smallint)
returning lvarchar(2048) as token;
define str_len integer;
define start_pos integer;
defi...
|
More Articles...
- Hewlett-Packard's Management Discusses Technology Briefing: Big Data ... - Seeking Alpha
- Hewlett-Packard's Management Discusses Technology Briefing: Big Data (Transcript)
- Where Are They Now?
- From the SIGs - LTXHWM and LTXEHWM
- BCX wins R419m water affairs deal - ITWeb
- Hot Topic - SELECT FOR UPDATE/WHERE CURRENT OF
- Informix News of the Weird
- 超越技术价值天融信参展RSA2013大会 - 中关村在线
- 天融信参展RSA2013 超越技术价值 - 赛迪网
- Bytec: Wir mögen es komplex - IT-Business
- Do you want to take your productivity to new levels?
- FormasaAuditor 推出差異性報表弱點管理 - IT新聞眼 (新聞發布)
- FormasaAuditor 推出差異性報表弱點管理 - 數位之牆
- La agenda de la nueva directora de Microsoft Argentina y Uruguay - El Observador
- Les nominations IT du 18 février 2013 - Journal du Net
- JDN sur iPhone - Journal du Net
- Рисунок: Валерий Эдельштайн - Эксперт Online
- Лучше быть программистом, чем инвестором - Эксперт Online
- Talend Appoints Jim Foy as Executive Chairman - EON: Enhanced Online News (press release)
- Jim Foy rejoint Talend en tant qu'Executive Chairman - Decideo