DataView component in SPD attaches needless strings to field values.

Hello.

In SharePoint Designer I use some lists as sources and then link them together with an operation GetListItems (I fetch items from multiple lists on different site collections for rollup/aggregation):

Now something is fine as I managed to get the result:

But the strings that are attached to field result (6;#, 2;#) is... disturbing. How can I get rid from those attached strings? They are not attached to all fields, but to some (important ones):

From stackoverflow

• Ahh, well usally that happens - you keep searching for answer, then seek for help and find it yourself.

  I used substring xsl function, to strip away those first characters. Messy, if i want to add links to that table, but works.

  

  By the way, the main question how to rollup content from multiple site collections has been journey to me for several days already. If anyone is in the same situation, I recommend (well because I found myself an answer there) these:

  • How-To Rollup two lists in two site collections on a page
  • Or a better way to use for a single site collection: SharePoint Customisation Tricks: Use The SPDataSource, Luke! (Good links inside that article).
  • Something I didn't touch, because I didn't need such an advanced method, but maybe someone does: Populating data sources in code