Reading String within the single quotes

10-11  Source: Network gathering  Views:0 

Advertisement
Hi All,
Can you please let me know, how to read a String within the sinle quote in line.
I have to read a report into internal table and again from that I need to read a string within the single quote. Please help me in this.
Thanks in Advance,
Raghu
I have the following code:
REPORT  test.
DATA:  v_test(05) TYPE c.
v_test = ‘TTT’.
I am getting this errror:
Field “TTT” is unknown.  It is neither kin on e of the specified tables nor defined by a “DATA” statement.
For some reason, my single quote is not being recognized from my keyboard.  I noticed that my emotion icons are not being displayed either (example:  I type and i do NOT get the smiley face on my end).
Is there a button that I pressed that caused that?
Related articles
  • Reading String within the single quotes 10-11

    Hi All, Can you please let me know, how to read a String within the sinle quote in line. I have to read a report into internal table and again from that I need to read a string within the single quote. Please help me in this. Thanks in Advance, Raghu

  • String value changes single quote ' to double quote " 10-11

    I am creating a list with different bill codes within single quotes as follows <cfset corlist = " '1100 ','1200 ','1300 ','1700 ','1800 ','1950 ','7001 ' "> when I do an output for <cfoutput>AND idbillcode IN ( #corlist #)</cfoutp

  • SSRS Report Returning Double Quote string from a Single Quote String 10-11

    Hi, I'm getting weird thing in resultset from SSRS report when executed. When I pass parameter to a report, which passes String that has single quote value to a split function , it returns rows with double quote.  For example  following string: 'N ga

  • Trouble with inserting a string containing a single quote 10-11

    Using php with Oracle If I do the following two lines before sending my $Query string through the parse function $name = "Dominick's"; $Query = "INSERT INTO customers (name) values ('$name')"; it gives me the following error: Warning:

  • Passing String Which Has Single Quote Row/Value to a Function Returns Double Quoate 10-11

    Hi, I'm getting weird thing in resultset. When I pass String which has single quote value in it to a split function , it returns rows with double quote.  For example  following string: 'N gage, Wash 'n Curl,Murray's, Don't-B-Bald Returns: ''N gage, W

  • How to insert a string containing a single quote to the msql database? help 10-11

    how can i insert a string which contains a single quote in to database... anyone help Message was edited by: sijo_jamesAbsolutely, Positively use a PreparedStatement. Do not use sqlEscape() function unless you have some overriding need (and I don't k

  • How to search the location of the single quote using instr func in a string 10-11

    I have a string '345634','234'(all 4 single quotes are part of the string) and I want to find the location of the 3rd single quote using the instr function , could sum1 quickly please help me out. Regards Rahul Edited by: Rahul Kalra on Aug 26, 2010

  • String with embedded single quote 10-11

    Hi, all. We're trying to pass a string from one procedure to another, which will then do an EXECUTE IMMEDIATE on it. However, there are single quotes withing the string, and they're driving us nuts! This is what the concatenated string should look li

  • How to escape the single quote from email value? 10-11

    Hi, Is there any way to escape the special character single quote from the email value.        String ownerQry = "Select Id, email from User where email in('0000'";         for(int i=0; i<accountData.length; i++)             ownerQry += "

  • String comparison having single quote 10-11

    hi i m comparing a string which already have a single quote like this var_name=khurram' shehzad select * from table where name=' var_name '; plz help me how to do it bcoz its creating probelm thanks and regards,Hi, I hope the below example will help

  • How to read data with different XML schemas within the single connection? 11-30

    I have Oracle 11g database I access it through jdbc:oracle:thin, version 11.2.0.3, same as xdb. I have several tables, each has one XMLType column, all schema-based. There are three different XML schemata registered in the DB I may need to read the X

  • Reading email within the borders? 11-30

    Love my new Droid Maxx  BUtT  my email go OFF the sides  I have to scroll from side to side to read....Is there a setting to keep email in Left and Right borders? Thanks DaveAlanIf you rotate your phone to the landscape orientation, it will allow you

  • Copying a table with the right-click menu in schema browser fails to copy comments when string has single quote(s) (ascii chr(39)) 10-11

    Hi, I'm running 32-bit version of SQL Developer v. 3.2.20.09 build 09.87, and I used the built in context menu (right-clicking from the schema browser) today to copy a table.  However, none of the comments copied.  When I dug into the PL/SQL that the

  • SQL: Need help putting single quote around string 10-11

    I want to put single quotes around string in my output. I am running the following command as a test: select ' ' hello ' ' from dual; My expectation is to get 'hello' (Single quote around hello) However I am getting the following error: ERROR at line

  • How to use a single quote string in where condition 10-11

    Hi, I have one problem in building a query. SELECT agx_drug_indication.record_id, agx_drug_indication.fk_ad_rec_id, agx_drug_indication.drugindicationmeddraver, agx_drug.record_id, agx_drug.fk_apat_rec_id, REPLACE (agx_drug.medicinalproduct, '''', ''

  • How to replace double quotes with a single quote in a string ? 10-11

    Hi All: Can some one tell me how to replace double Quote (") in a string with a single quote (') ? I tried to use REPLACE function, but I couldn;t get it worked. My example is SELECT REPLACE('STN. "A"', '"', ''') FROM Dual --This one t

  • JSF inputText takes apostrophe (single quote) as end of string 10-11

    Hi, I run into a problem with JSF when apostrophe(single quote) is in input text: <h:inputText id="input1" styleClass="field" size="20" maxlength="20" value="#{bean.property1}" /> When user inputs st

  • Embedded Single Quote in SQL Column truncates Java String 10-11

    I have a jsp web page that queries a database to see what day a user is registered for and then produces an URL for the user to click on. My problem is that the URL being processed stops when an embedded single quote is encountered. Here is the datab

  • How to escape a single quotes from a string of dynamic sql clause? 10-11

    if a single quotes exist in a dynamic sql clause for a string, like v_string :='select tname from tab where tabtype='table'', there tabtype='table' will conflict with the single quote ahead. could somebody tell me how to escape this single quotes? th

  • Is it possible to use single quotes in a String 10-11

    Can we use single quotes and comma in side a string variable... Eg: String s=" a ' , ' b "; why am i asking was...... when this variable is sent to database, the table automatically recognizes the beginning single quotes and end single quotes to