Skip to Content
0
Feb 21, 2014 at 10:21 AM

How to read Flat File and send to mulitple fields

15 Views

Hi All,

I am trying to read a flat file which is seperated by "|" in to once Recoed set and then split it to different fields.

Can you help me by giving UDF to read this strucure.

Below are the deatils.

Source File:

1173|2524457A|07/27/2013|USD|UNILEVER HPC EXECUTIVE MATTERS Unilever/HPC Executive Matters|500.00|2611=1000010045|=12107001|=|500.00|

1173|1038246A|08/08/2013|USD|IOS Litigation|1000.00|2611=1000010045|=12107001|=|500.00|2611=1000010200|=12107002|=|250.00|2611=1000010100|=12107006|=|250.00|

Attachments

1.png (24.7 kB)