Forum Stats

  • 3,769,230 Users
  • 2,252,933 Discussions
  • 7,874,951 Comments

Discussions

ODI Field Seperator Symbol

3919064
3919064 Member Posts: 2
edited Mar 11, 2020 8:11PM in Data Integrator

Hi

Just want to check whether I can use "|" symbol for field separator since it is the symbol that is used in the delimited file?

Because when I set "|" (pipe) as the symbol, it gives error and log file always shows comma instead of the pipe bar symbol

Tagged:
XavierGrosfils

Best Answer

  • 3919064
    3919064 Member Posts: 2
    edited Mar 11, 2020 8:11PM Accepted Answer

    I have done what you have suggested.

    After several tests, I found the answer. In additional to what you have suggested, I have to switch the format from CSV to Delimited in the physical mapping.

    XavierGrosfils

Answers