Informatica Expression for INITCAP Question

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Informatica Expression for INITCAP Question
# 1  
Old 03-11-2014
Informatica Expression for INITCAP Question

Hi Team
I am using below expression function in INFORMATICA 9.5 to make initial letters as CAPS .

Code:
[INITCAP(IIF(ISNULL(ITEMS),'NA',ITEMS))]

Output :
Before After
APPLICATIONS --> Applications
SP TERMS --> Sp Terms

I want output to be as SP Terms
Please let me know what expression will satisfy my needs .Thanks

Last edited by Don Cragun; 03-11-2014 at 05:41 AM.. Reason: Fix CODE tags.
# 2  
Old 03-11-2014
Code:
Upper(REG_EXTRACT(ITEMS,' ',1)) || ' ' || INITCAP(REG_EXTRACT(ITEMS,' ',1))

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Regular expression question

Hi guys, I need a help with a query. Basically i want to know the difference between (0+01)* and ((0+01)*)* . It seems whatever string can be generated by the first RE can also be generated by second and they should essentially be same. Am i missing something? (1 Reply)
Discussion started by: srkmish
1 Replies

2. Shell Programming and Scripting

Cron Expression Question

Hi Experts, How do comeup with 1 cron expression for the same job which runs at say 1.21PM and 4.36PM daily, i know the daily and hourly part not able to get it with times other than hours (ie 1,2 etc). thanks so much. (2 Replies)
Discussion started by: sri.goverdhan
2 Replies

3. UNIX for Dummies Questions & Answers

Regular Expression Question

Hello, I'm trying to rename a bunch of files that were named incorrectly. I know a little about regular expressions but I'm not very good at them. Here is the image of the file names: http://i47.tinypic.com/np2gxi.jpg I'm trying to change the 20111116 at the beginning to 20101116 for all... (2 Replies)
Discussion started by: nastyn8
2 Replies

4. UNIX for Dummies Questions & Answers

a question about a regular expression

I like to loop a list of files which named file1, file2, file3, file4, etc if I like to loop them all over for f in file1, file2, file3, file4 do echo "processing" $f done how to use a regular expression to loop file$i instead? Thank you. (4 Replies)
Discussion started by: ksgreen
4 Replies

5. UNIX for Dummies Questions & Answers

Question on Regular Expression

Folks; Could some one tell me what these 2 regular expressions mean: */(*)/* (\d\d\d\d/\d\d/\d\d/*?) (14 Replies)
Discussion started by: Katkota
14 Replies

6. UNIX for Dummies Questions & Answers

Regular Expression question

Folks; I have 3 questions & any help with them would be really appreciated: If i have a list of directories, for example: /fs/pas/2007/4/6/2634210/admdat/examin /fs/pas/2007/4/6/2634210/admdat2/stat /fs/pas/2007/4/6/2634210/admdat3/data /fs/pas/2007/4/6/2634210/im_2/0b.dcm Now; my... (6 Replies)
Discussion started by: Katkota
6 Replies

7. UNIX for Dummies Questions & Answers

question (regular expression related)

anyone knows what does this regular expression match for? \(3,\).*\1.*\1 (1 Reply)
Discussion started by: metalwarrior
1 Replies

8. Shell Programming and Scripting

Regular expression question

hi i need to wipe out something from giving path i have some thing like that : pwd | sed 's/.*foo//' it is working fine when I have path like : /blah/balh1/foo/moo so it erasing me all that comes before the foo including the foo but I have problem when I have dir by the name of... (7 Replies)
Discussion started by: umen
7 Replies

9. UNIX for Dummies Questions & Answers

Regular Expression Question

Hi - I am trying to ignore the following items from a list. lp0 lp11 lp12 lp14 The following code works fine, but I was wondering if there was a tidier way to write the lp regular expression? egrep -v "lp" Thanks in advance. (3 Replies)
Discussion started by: Krispy
3 Replies

10. Shell Programming and Scripting

question about regular expression

why does * highlight everything in it... shouldn't it only highlight capital letters? (0 Replies)
Discussion started by: brentdeback
0 Replies
Login or Register to Ask a Question