I’m facing an issue. In this repository below, I have a .csv file for each .txt and .pdf file. I’m extracting data from those .txt and manipulating them. How could I insert this taken data to the respective csv? Notice they have the same name “1_1_1.txt” and “1_1_1.csv”.
Is the data in the text files formatted the same way as CSV? In other words, are you essentially copying the files with a different extension? If so, you can use the Copy File activity, and savethe files with .csv at the end instead of .txt. Both formats are still text files in the end; it’s just that the extension is different.
The .txt file comes with an OCR text made by another system. I used Regex Matches to extract specific datas from this .txt. Once extracted, I want to insert this in the respective .csv file, like:
1_1_1.txt → Extracted Data → 1_1_1.csv
1_1_2.txt → Extracted Data → 1_1_2.csv
In the A1 cell of each .csv I already have datas that came from the other sistem (Kodak) and the A1 cell of each .csv file is coming like this:
Data1|Data2|Data3 so on…
I want to append the extracted data (variables) to this A1 cell in each csv file