Help with approach to create output text files

[wendy.goodier]

Thank you in advance for the advice. Keeping it simple to begin with.

I have a spreadsheet with two columns, column 1 is going to be the name of the text file and column 2 is some information. I have anything from 1 line per file to nearly 200 per file, but to keep it simple here is a set.

File Title
100 Mrs
100 Mrs
101 Dr
101 Mr
102 Miss
102 Ms
103 Lord
104 Sir

Up to now I have not had these multiple lines and have used

Please Login or Register  to view this content.

All attempts I have made with loops, don't step through the lines, but seem to just take the last one.

What I am looking for is file 100 to have
<tag>Mrs</tag>
<tag>Mrs</tag>

and file 101 to have
<tag>Dr</tag>
<tag>Mr</tag>

Some advice on this would be welcome as I can't find an example to base this on.

[jindon]

try

Please Login or Register  to view this content.

[wendy.goodier]

Thank you, using the data I showed it falls over at this line which is of course the core of your solution, so I wonder what I have missed

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

Welcome to the forum.

Did you notice that I added code tags to your opening post? Please would you wrap your code in code tags in your latest post?

Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Thanks.

[jindon]

Your profile shows 365, so it should work.

[wendy.goodier]

Thank you so much, now I need to work out which part does which, can you share any insight into why it works, its lots of new functions for me,

[jindon]

1) Get list of unique file names from col.A

Please Login or Register  to view this content.

2) Loop through 1) and populate string to output.
You can insert formula in e.g. D1 to see what the code does.

="<tag>"&TEXTJOIN("</tag>"&CHAR(10)&"<tag>",,FILTER(B2:B9,A2:A9=100))&"</tag>"

D1 need to be wraptext to see line break.

Please Login or Register  to view this content.

3) Output for each unique txt file

Please Login or Register  to view this content.

HTH

[wendy.goodier]

Thank you it does help, as you can imagine I started with it being simple, but actually I have more than one column, maybe I should have explained.

File Title Surname Address
1 Mr Apple London
1 Mrs Orange Oxford
2 Ms Banana Cambridge

wanting in file 1

Please Login or Register  to view this content.

and standard header and footer tags around each one to eventually create a piece if valid xml.

I think relying on a Ctl to wrap text means I can't do this.

[jindon]

Now better upload a workbook and text file showing how you want.

[wendy.goodier]

Thank you, here are the files.
The txt shows the xml format with an example of one record per xml (#2) and an example with more than one record per xml (#1).
The excel contains the records.
Example excel.xlsx
filename1.txt
filename2.txt

[jindon]

try

Please Login or Register  to view this content.

[Haluk]

Another alternative is;

Please Login or Register  to view this content.

Sample Excel file and a screenshot of the first XML file attached below.

[wendy.goodier]

Thank you to everyone that helped, appreciate the useful solutions.