Data Warehousing and Data integration

Checking text file content

More
2 years 7 months ago #23069 by Sean
Hi.

I'm exploring a straightforward method to verify the presence of a specific string within a text file.
As part of the order processing workflow design, it's essential to confirm the existence of the customer's name within the invoice file.

Please point me in the right direction

Sean

Please Log in or Create an account to join the conversation.

More
2 years 7 months ago #23070 by Peter.Jonson
Hi Sean.

Although it is technically possible to do what you want using transformation it is not straightforward.
The best option is to extend the functionality for the File check package action.

www.etl-tools.com/wiki/advanced-etl-proc...s/check-file-action/

We will let you know once it is ready
 

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
2 years 7 months ago #23071 by Peter.Jonson
Hi Sean.

Your suggestion was implemented in the latest release.

Peter


Peter Jonson
ETL Developer
The following user(s) said Thank You: Sean

Please Log in or Create an account to join the conversation.

More
2 years 7 months ago #23076 by Sean
Replied by Sean on topic Checking text file content
That works very well, thank you.

Now I need to replace a string with a text file.
  
Please help me

Please Log in or Create an account to join the conversation.

More
2 years 7 months ago #23077 by admin
Replied by admin on topic Checking text file content
1 Right now you can use the example 003 approach



2 We will extend "File operation package action" in the next release

  

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #23078 by admin
Replied by admin on topic Checking text file content
FYI: Replace string option was added to the latest release.


Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save