Single quote in a string

This topic contains 2 replies, has 3 voices, and was last updated by Profile photo of Jarkko Vepsäläinen Jarkko Vepsäläinen 7 months, 2 weeks ago.

  • Author
    Posts
  • #59825
    Profile photo of Mohan D
    Mohan D
    Participant

    Hi Everyone

    I am dealing with displayName attribute in AD. I am dumping these names into an Oracle table. Some names have a single quote in them. For example – Jerry O'Brian

    In my script I am using single quotes around the variable. Like this – '$displayName'
    The script throws an exception when it finds that name. So I get all names into the table except this.

    I tried using double quotes, two single quotes, tried different escape characters. Nothing worked. Any ideas?

    I am hoping someone can help.

    Thanks
    Mohan

  • #59827
    Profile photo of Matt McNabb
    Matt McNabb
    Participant

    What command are you running that returns the error? What is the content of the error message? There's no particular issue with having a single quote in a string variable, but maybe the particular command you're running is balking at it, and you might need to do some error handling. Or maybe the database field has a problem with it?

  • #59830

    Hi

    Single quotas outside variable will convert the variable name into a String and not how double quotas shows you what's inside the variable.

    Example:
    $variable = 'text'
    "$varible" returns: text
    '$variable' returns: $variable

    Jake

You must be logged in to reply to this topic.