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 ...
kzhou's avatar
kzhou
Former Employee
8 years ago
Copy LinkReport

Hi,
Based on your scenario, when first run the consumer snap, you may use a new group ID in the Consumer, and set ‘auto offset reset’ to earliest. This would let the Consumer to read from earliest at the first running (when initialize the new group). For ‘seek type’, you may set it to End, so that it would continue reading when resume. Hope it helps 🙂

GBekkanti's avatar
GBekkanti
New Contributor III
7 years ago
Copy LinkReport

Hi @kzhou,

Very thanks for your above statements. Those will be work irrespective of partition number right?

Please confirm the same. Thanks in advance!

  • 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