1 Reply Latest reply on Jan 25, 2016 12:05 PM by user157587

    Multiple Delimiter Flat File - Data Explorer - Developer/Analyst

    New Member

      Can we give multiple delimiter say for example '||' double pipe in Data Explorer(Developer) and mention it as and condition as we define in informatica PC source definition? 

        • 1. Re: Multiple Delimiter Flat File - Data Explorer - Developer/Analyst
          user157587 Active Member

          The functionality doesn't exist currently in Developer. 

           

          However, what does exist is the ability to treat two consecutive delimiters as a single delimiter.  If you used || as your delimiter, it would parse this as a single delimiter.  Still, be aware that if you used | in your text (single pipe) it would also be interpreted as a delimiter.  If you do not find a workaround to this, can you please open a support case?  We can devote more time to this and open an enhancement request as needed.

           

          Thanks,
          Bart

           

           

           

          email:  support@informatica.com or phone: 1-877-INFA-HELP