Skip to Content

How to add text qualifiers ".." in csv export in hybris Marketing

Dear Community,

how can we add text qualifiers like " in our csv export in hybris Marketing on prem? We did not found any settings in SPRO


thx, best regards
Peter

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 27 at 01:46 PM

    Hi Peter,

    Can you give a sample of what data you expect in the CSV and in what format?

    Thanks

    Vineet

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Peter,

      I am not sure if this can be done as standard, we do have options to use field separators in export definition which can be used if you have multiple values in the same column but your requirement seems to be more of concatenating the columns with special characters.

      I see two options to do it.

      Option 1:

      Create a custom view which has all these fields and then create a concatenated column in HANA which view which is nothing but concatenation of all these fields including the qualifiers you need. You can then expose this calculated column for export and you should see the data in the file in the format you require.Or else rather than concatenating you can create calculated columns for all your fields which you need and each calculated column should be nothing but actual field wrapped in qualifiers.

      F_NAME = Peter

      CALC_F_NAME = "F_NAME" => "Peter"

      or

      F_NAME | L_NAME | ADDR1 | ADDR2 | CLAC_CUST_FILED

      Peter | Meier | London | UK | "F_NAME"+"L_NAME"+"ADDR1"+"ADDR2"

      Option 2:

      Create Columns for special characters itself and then use them as fields in your export definition rather than qualifiers so your columns should look like

      SP_CHAR1 F_NAME SP_CHAR2 L_NAME SP_CHAR3 ADDRESS and so on.

      I would prefer option 1 until anyone else can suggest a better way of doing this ;)

      Also, you may want to revisit the business requirement as to why this is required in this format.

      Thanks

      Vineet

  • Mar 29 at 07:54 PM

    Hi Peter,

    Can you also name the tile you want to export CSV from?

    Thanks & Regards,

    - Arnaud

    Add comment
    10|10000 characters needed characters exceeded