Current position:  Home > Default > To convert the values in the column from upper case to Camel Case.

To convert the values in the column from upper case to Camel Case.

Time:October 11
Advertisement
Hi All,
I have requirement to convert the column values(Data in the Columns) from upper case to camel case in pivot table view.
For Eg:
I have
Table Name:Billing_Transaction
under Billing_Transaction table i Have column Comment_Text
Data in Comment_Text Column is
INSERT,
EXPORT,
AMEND
How i will change these values in to Insert,Export,Amend.(Camel Case condition)
I want only the first letter of a word to be in caps and others to be in smaller case.
Thanks,
Chitra Subramani.
Advertisement
Hi Aravind,
Thanks for immediate response.your query is helpful.But i need to satisfy another condition in my requirement by using same formula.
"REPLACE(UPPER(SUBSTRING(BILLING_TRANSACTION.BILLING_TRANSACTION_DESC FROM 1 FOR 1)) || lower(substring(BILLING_TRANSACTION.BILLING_TRANSACTION_DESC FROM 2)), '_', ' ')"
above query satisfying Camil case and replacing '_' with ' '(space)......but inthis query i want add another condition to satisfy camil case for word which comes after '_'
for example:
DECLINE_IMPORT
above query satisfying 2 conditions to convert above data into
"Decline import"
But in my requirement for word 'import' also it should come in camil case condition like
"Decline Import"
Thanks & Regards,
Chitra
Edited by: user6371773 on Apr 25, 2011 6:29 AM

Pages automatically converts to upper case

-0001-11-30

Hi everybody. I'm doing a trainig manual in JavaScript and done a table with reserved keywords. But Pages 09 converts two words - true and false, into upper case. Is there any way to avoid this conversion? All suggestions are wellcomed.Never got this

Converting each row in a column to an XML

2015-10-11

Hi everyone, Using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit I have a table where there is a comments column which is VARCHAR2. That column contains string data in the form of XML tags. Like for eg. *<tag_name attr_name="10

I need to convert PDF to Excel, however, columns and tabs make many merged cells and many blank columns. In addition to not separate the columns correctly, I see many not separate lines together in the same cell. I'm even thinking that Adobe Acrobat Pro D

2015-10-11

I need to convert PDF to Excel, however, columns and tabs make many merged cells and many blank columns. In addition to not separate the columns correctly, I see many not separate lines together in the same cell. I'm even thinking that Adobe Acrobat

How to convert data from rows into columns

-0001-11-30

Hi, I have a sql table and the data looks like this GLYEAR GLMN01 GLMN02 GLMN03 GLMN04 2007 -109712.40 6909.15 4758.72 56.88 2007 -13411.32 19132.9 -5585.07 4362.64 Where GLyear reprsents Year and GLMN01 is February, GLMN02 is March and so on, Now i

Convert one row to multiple column dynamic in smartform

-0001-11-30

i want to convert on row to multiple column in smartform.As number of column is not per define..Please suggest the way out in smartformI saw a post and working perfect. The link is given below. http://scn.sap.com/community/abap/blog/2013/10/06/the-ca

Is there a way to convert 8 Rows by 2 Columns to 2 Rows by 8 Columns?

-0001-11-30

I have tried but came to an stop... How do I convert 8 Rows by 2 Columns to 2 Rows by 8 Columns? as shown in the vi attached Thank you very much... Solved! Go to Solution. Attachments: Eight Rows Two Col convert to two Rows Eight Col.vi ‏8 KBJohnMc19

Converting mixed case table name to upper case

2015-10-11

I am migrating data from Access to Oracle and new tables and columns being created are in mixed case is there a way to convert all tablename or column name automatically. Also does the migration workbench handle the memo fields currently defined in m

How can I define that the value of a column should always be in UPPER case

-0001-11-30

Hi, I want to make sure that the value in a column is always in UPPER case. Can we give this condition while creating or altering a table. A trigger can do it easily, but I was wondering if we could define a column to have values with upper case all

How can I change a column to lower case?

2015-10-11

I selected an entire column and discovered that it's already set at Format > Font > Capitalization > None If I change "None" to "All Caps," it capitalizes everything. But when I change it back to "None," letters that

JDBC send data to oracle, oracle only accept column name in Upper case

2015-10-11

Hi experts, I am doing a scenario File --> XI --> JDBC,  JDBC send data to a Oracle 10g database, I have configured JDBC receiver to use XML-SQL format. in oracle database ,  table "EMPLOYEE" has a column "NAME", but when I send

Problem in converting into upper case urgent

2015-10-11

hi, i  working on module pool program. in the initial screen there is two fields one is number one is name. if i enter the name in the name field it is automatically converting into upper case, but in this case my select query is not working,how to s

Update column data to Upper Case in parent and child table

2015-10-11

Hi , I am facing issue while updating column value to upper case in parent table and child table. How can i do that ? when updating parent row: ORA-02292: integrity constraint (XXXXXXXXXXXXXX_FK) violated - child record found When updatng correspondi

Converting lower case to upper case data of flat file

2015-10-11

Hi All, I have a requirement purche order creation by using bapi function module.My requirement is  when I am uploading the flat file and if flat file  contains the data in lower case then before passing it to the function module i want to convert it

Sort column by without case sensitive  using Comparator interface

2015-10-11

Hello, When i sorted my values of a column in a table it was showing all sorted upper case letters at top rows and all sorted lower case letters on bottom. So i would like to sort values without case sensitive order. Like. A, a, B, b, C, c.... I am u

How to convert a string from upper case to lower case in FOX formula

-0001-11-30

Hi Experts, How to convert a string from upper case to lower case in FOX formula? Thanks, Cheers!!! PANKAJThe last result.append( c ) should be: result.append( Character.toLowerCase(c) );Read other 3 answers

How to convert a string from lower case to upper case withour using transla

-0001-11-30

Hi all, how to convert a string from lower case to upper case withour using translate, Thanks in Advance, ReddyRefer to this related thread Re: hi guys this very urgent please helpRead other 6 answers

How to convert lower case to upper case?

-0001-11-30

Hi, How to convert lower case letter to upper case and vice versa?TRANSLATE Variants: 1. TRANSLATE c TO UPPER CASE. 2. TRANSLATE c TO LOWER CASE. 3. TRANSLATE c USING r. See String processing Variant 1 TRANSLATE c TO UPPER CASE. Variant 2 TRANSLATE c

Converting all to upper case

-0001-11-30

Hi, Am loading from a flat file. I need to convert all the data into upper case before loading. Can some one help me out with this. Where and how? Thanks.you'll have to do that for each single object; depending on how many fields you have you may cha

Value converting to upper case

-0001-11-30

Hi, There is a table control, but when i am taking a value from the table in PAI of my screen, the value gets converted to upper case, can any one suggest me what would be happening. Is there any way to control this? Thanks in Advance, kushagra sharm