Creating Sentence Outputs with Example

[mkuczyns112]

Hello All,

Thanks in advance for the support. I am looking into creating a text output file. I have 3 inputs item, sentence, figure. The point is to create an output file from the positioning of the item in a sentence and inputing a figure where applicable after the sentence.

Imagine Column A as the item, Column B as which sentence the item goes into and Column C as the figure. The figure will follow the next x.

ITEM SENTENCE FIGURE
dog 1 ""
cat 1 ""
gate 1x a
horse 2 ""
moose 2 ""
cow 2 ""
cave 2x b

Note: the designator of x signifies the item to be at the end of the sentence. The figure (can be changed) is setup to write a code to imply a figure is needed at this point.

The structure of the sentence should be the following:

1. Remove dog, cat from gate.
ADD FIGURE
2. Remove horse, moose, cow from cave.
ADD FIGURE

Note: Always start the sentence off with "Remove" and the "x designator" should have the word "from" prior to it's use. The order of which the items appear is irrelevant.

Would like file saved as h:\test.txt

I understand that this can be complex. If so, a discussion on how to create the structure would be appreciated as well. I hope I covered all variables, if there are any questions let me know.

 

[mkuczyns112]

Very neat.