Hello,
I have a text file that has sample data as follows:
@@DOCUMENT
@@ACS FILE
@@DOC 02
6/15/04~1~12434~124322~err
@END
@@DOCUMENT
@@ACS FILE
@@DOC 02
6/15/04~1~12934~1235322~err
@END
@@DOCUMENT
@@ACS FILE
@@DOC 02
6/15/04~1~12234~163522~err
@END
As you can see most of the data that starts with @@ is repeated.
Only unique data is one that starts with the date.
How do I go about extracting the info after the second ~. This would be information such as 2434, 12934, etc. The data from @@DOCUMENT to @END is considered a record.
Depending on that value, I need to create another file and put that record ( From @@DOCUMENT to @END) or bypass that record.
Any help would be appreciated.
Thanks
I have a text file that has sample data as follows:
@@DOCUMENT
@@ACS FILE
@@DOC 02
6/15/04~1~12434~124322~err
@END
@@DOCUMENT
@@ACS FILE
@@DOC 02
6/15/04~1~12934~1235322~err
@END
@@DOCUMENT
@@ACS FILE
@@DOC 02
6/15/04~1~12234~163522~err
@END
As you can see most of the data that starts with @@ is repeated.
Only unique data is one that starts with the date.
How do I go about extracting the info after the second ~. This would be information such as 2434, 12934, etc. The data from @@DOCUMENT to @END is considered a record.
Depending on that value, I need to create another file and put that record ( From @@DOCUMENT to @END) or bypass that record.
Any help would be appreciated.
Thanks