Hi All,
Fairly new to Alteryx and need some help parsing a .txt file to separate what each speaker says into a new .txt file.
For example, I am looking to separate everything the CEO says into its own .txt file. It can be one continuous string if necessary. All of the files share the following format:
- The list of speakers is preceded by the text of the actual call conversation.
- The position of speakers are formatted as "Name - Position"
- The first speaker is always the operator
- When a new speaker speaks, the format is their full name (without position) and new line with they say.
The workflow needs to be flexible enough to work off of the position of the speaker and not their name.
I am not sure if there is a way to have Alteryx store the name of the speakers in between the "Executives" cell and the "Operator" cell. Then have Alteryx check against the list for a line that contains only the speaker name. For example, the logic would look something like: Check for Steven Humphrey - > If found, then store all lines of text following Steven Humphrey's name until another speaker is found. - > If another speaker is found, then stop at [row-1] -> continue until Steven Humphreys is found again.
| Executives |
| Steven Humphreys - CEO |
| Sandra Wallach - CFO |
| Analysts |
| Mike Latimore - Northland Capital Markets |
| Operator |
I've attached a workflow that was created using the sample.txt file but it isn't flexible enough to work with the input_sample files. There are a couple of thousand text files I need to parse and using Alteryx would make my life so much easier. I appreciate all the help! 🙂
