79517565

Date: 2025-03-18 13:23:36
Score: 1.5
Natty:
Report link

If the text contains a symbol that is delimiter, there is no way for machine or person to distinguish (Except for Analysts). Only way is request the source team to enclose complete text with " if it contains |.

In our case, source team does not have a way to enclose text " selectively. Hence we has requested to enclose each field with ", irrespective of if it contains | or not :-) . And it would work.

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: chaitanya ch