Hi, all. I’m running into an issue with importing space-delimited data from a flatfile, and it’s not totally clear how best to go about it.
In the flatfile, each line is formatted as follows:
abc def ghi jkl mno pqr stu natural_language_sentence(s)
All fields are space-delimited strings of varying lengths. The eighth contains sentences written in plain English, which in turn contain spaces of their own.
Because the first seven spaces are always present, I would like to replace those with tabs. It should then be easy to process the result into eight separate columns.
What I can’t figure out is where in any of the nodes I’ve looked at this can be accomplished, and while I’ve found some examples that get close to what I’m looking for, none really fit the bill. Any assistance would be appreciated.