Forum Discussion

alex_panganiban's avatar
alex_panganiban
Contributor
3 years ago

LF's in CSV to result in a Multi-Line Cell in Excel

Could use some advice here. I am trying to take a string of data (a group of key/value pairs) that is comma delimited and insert it into a single Excel cell so that it shows as multiple lines within ...
wpenfold's avatar
wpenfold
Contributor
5 years ago
Copy LinkReport

You probably need to specify passthru on most snaps

  • sriram's avatar
    sriram
    Former Employee
    9 years ago
    Copy LinkReport

    If your Oracle table has columns whose names contain a ‘$’ (or any other special character) in it, here’s how the execute query needs to look like:

    Query: select “USER$ID” from testtable1


    Note: Expression should not be enabled on the “Oracle Execute” snap