Hello, I receive multiple .txt files everyday, The import code is working fine. I have been looking for examples to see how I can do the below though I am not sure if it can be done, Any guidance is much appreciated.
The First row in every file is the date as below:
HEADER;2021051701
ABC;Origin1; destination1;;;29870
DEF;Origin2; destination2;;;29870
Is there a way where I can take the date from the first row and add it to the data as below?
ABC;Origin1; destination1;;;29870;20210517
DEF;Origin2; destination2;;;29870;20210517
The First row in every file is the date as below:
HEADER;2021051701
ABC;Origin1; destination1;;;29870
DEF;Origin2; destination2;;;29870
Is there a way where I can take the date from the first row and add it to the data as below?
ABC;Origin1; destination1;;;29870;20210517
DEF;Origin2; destination2;;;29870;20210517