LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  Column with single quote character

    Employee
    Posted 04-23-2013 08:18

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rpcwong

    I have a file that contains a field with a single quote character in its name.
    For example, 'Rick's problem'
    The file was imported into lavastorm without issue, but the single quote in the name is causing issues for me when I try to use the data in this field.

    Probably a quick fix, but how should I handle this field? (I don't mind renaming it or truncating the filename).


  • 2.  RE: Column with single quote character

    Employee
    Posted 04-23-2013 10:02

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    In a filter, you can just put this:

    emit *
    rename "Rick's Problem" as "Ricks Problem"

    and that should fix it.

    Cheers
    Rich