Howdy,
I am attempting to dynamically provide a list of file names in a list box inside an app. I have a couple of patterns of characters within my field names, which I would like to replace out before they are presented to the user. For instance, "___" (three underscores), I would like to show as " - " (space dash space). Also, in the same field names, it now shows "_dbf" after the cross tab tool. I would like to change those back to a normal extension of ".dbf" (dot dbf).
My question is, is there a way to do this, without using multiple dynamic rename tools? Is there a Regex_Replace function I could use? You can see in the screenshot below I tried two replace expressions separated by an OR statement and that did not work. If I have to use multiple dynamic renames, I will do that, but I feel like there is a way to simplify this. Thanks ahead of time for any help on this!
