Jul 11 2023 07:47 AM - edited Jul 11 2023 07:49 AM
Hi all, I have a use case, where there is a mapped field in word. This document is being used as a template document in another system. But I want to replace all commas in the field value with ^p or line break when I pass the field values to the template document. Would it be possible.
Thanks in advance.
Jul 11 2023 07:28 PM
@Nimmyraj How are the field values being "passed" to the template? If you are using VBA, you could use the Replace function.
ValueforTemplate = Replace(SourceValue, ",", vbCr)
Jul 11 2023 11:21 PM
@Doug_Robbins_Word_MVP Hi Doug, thanks for your reply.. we are passing it as a field value from MFiles system. This document is being used as template document in our MFiles system
Jul 11 2023 11:44 PM
@Nimmyraj If you mean M-Files as at https://www.m-files.com, I would suggest that you contact the customer support at https://www.m-files.com/about/contact/
Jul 12 2023 03:05 AM
@Doug_Robbins_Word_MVP Hi Doug, we have been checking from there too, but nothing positive yet.. so was checking if word has any option of replacing the character
Jul 12 2023 03:20 AM
@Nimmyraj Your "passing it as a field value" does not really answer the question that I asked, which was:
"How are the field values being "passed" to the template?"
In other words, what is the passing mechanism?
Jul 12 2023 04:26 AM
Jul 12 2023 04:59 AM
@Nimmyraj Unfortunately, you have still not provided any information on the mechanism by which the values from M-Files are passed to the fields in the Word Template.
If that mechanism is known, it may be possible to modify it.
Jul 14 2023 11:53 PM
@Doug_Robbins_Word_MVP thanks Doug for your help. And sorry for the delay in reply. I was trying to get more details about mechanisms, but could not find details. The usage of word documents is a feature of M-Files DMS. But for this issue, M-Files are trying to give us solution from their end.
Thanks again for your help. really appreciate.