R
ronpassaro
Hi all,
Here's a simplified example of what I would like to accomplish.
1. I have a .txt file containing the following xml code:
<TYPE>[FILETYPE]</TYPE>
<ID>[IDNUMBER]</ID>
<OWNER>
<OWNER-FN>[FIRSTNAME]</OWNER-FN>
<OWNER-LN>[LASTNAME]</OWNER-LN>
<OWNER-ZIP>[ZIPCODE]</OWNER-ZIP>
</OWNER>
2. I would like to replace the variables ([FILETYPE], [IDNUMBER],
[FIRSTNAME], [LASTNAME], [ZIPCODE]) with the corresponding data from
an Access table of mine.
3. I would like to save the newly updated content to a new folder with
a new name and extension as follows:
a. create a folder under a specified directory and name it the same as
the "[IDNUMBER]" variable, which is unique. SO if the [IDNUMBER] field
= "123456", the folder would be named "123456".
b. Inside that folder I would like to name the updated content (the
text file merged with the table data) after the "[IDNUMBER]" variable,
and have the extension be ".tre" (made up extension). So if the
[IDNUMBER] field = "123456", the resulting file would be "123456.tre",
saved withing the "123456" folder created in step 3a.
I apologize if this request was posted in the wrong location, but I
thought a query might be involved here as most merge instructions I've
seen involve queries.
Your help in this matter is greatly appreciated!
Here's a simplified example of what I would like to accomplish.
1. I have a .txt file containing the following xml code:
<TYPE>[FILETYPE]</TYPE>
<ID>[IDNUMBER]</ID>
<OWNER>
<OWNER-FN>[FIRSTNAME]</OWNER-FN>
<OWNER-LN>[LASTNAME]</OWNER-LN>
<OWNER-ZIP>[ZIPCODE]</OWNER-ZIP>
</OWNER>
2. I would like to replace the variables ([FILETYPE], [IDNUMBER],
[FIRSTNAME], [LASTNAME], [ZIPCODE]) with the corresponding data from
an Access table of mine.
3. I would like to save the newly updated content to a new folder with
a new name and extension as follows:
a. create a folder under a specified directory and name it the same as
the "[IDNUMBER]" variable, which is unique. SO if the [IDNUMBER] field
= "123456", the folder would be named "123456".
b. Inside that folder I would like to name the updated content (the
text file merged with the table data) after the "[IDNUMBER]" variable,
and have the extension be ".tre" (made up extension). So if the
[IDNUMBER] field = "123456", the resulting file would be "123456.tre",
saved withing the "123456" folder created in step 3a.
I apologize if this request was posted in the wrong location, but I
thought a query might be involved here as most merge instructions I've
seen involve queries.
Your help in this matter is greatly appreciated!