Ggtcf

What typically incentivizes a professor to change jobs to a lower ranking university?

How old can references or sources in a thesis be?

Is it tax fraud for an individual to declare non-taxable revenue as taxable income? (US tax laws)

How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?

Languages that we cannot (dis)prove to be Context-Free

What's the point of deactivating Num Lock on login screens?

How can I make my BBEG immortal short of making them a Lich or Vampire?

Is it legal for company to use my work email to pretend I still work there?

What is the word for reserving something for yourself before others do?

Why does Kotter return in Welcome Back Kotter?

Cross compiling for RPi - error while loading shared libraries

What does "Puller Prush Person" mean?

What does the "remote control" for a QF-4 look like?

Do I have a twin with permutated remainders?

dbcc cleantable batch size explanation

Why doesn't H₄O²⁺ exist?

LaTeX: Why are digits allowed in environments, but forbidden in commands?

Why can't we play rap on piano?

I'm flying to France today and my passport expires in less than 2 months

High voltage LED indicator 40-1000 VDC without additional power supply

Do infinite dimensional systems make sense?

A case of the sniffles

Watching something be written to a file live with tail

Which country benefited the most from UN Security Council vetoes?

Report Builder 3 - Extracting text before and after specific strings

Report Builder 3.0 - Dataset Credentials Do Not WorkSSRS: Dropdown is not populated in filter in Report BuilderTablix: Repeat header rows on each page not working - Report Builder 3.0Multiple select in Report Builder 3Failed to run or preview report in SSRS and SQL Server Report BuilderAdding a text box for report description before the report executesJoining two datasets to create a single tablix in report builder 3unable to publish Report parts through Report BuilderOpening Report Builder report in Visual Studio 2013SSRS/Report Builder datediff in working days

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have a sql statement that calls for a field filled with XML data and I can display that field within a matrix on my report. I'm trying to extract the characters before and after specific tags , but can't figure it out. The field name is called DataXML. The XML can have 0 embedded fields or many fields. As an example, here's how the data on the report which has a pCode in it.

|ArrayOfKeyValueOfstringstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays"||KeyValueOfstringstring||Key>pCode|/Key||Value|"license"|/Value||/KeyValueOfstringstring||/ArrayOfKeyValueOfstringstring|"

However, I'm only interested in grabbing one piece and displaying it. As an example, I just want to display P081906400099. So, the characters before this should always be: fCN1" and the following value should always be

|/Value||/KeyValueOfstringstring||/ArrayOfKeyValueOfstringstring|"

Unfortunately, something else will sometimes be after this in the XML coding so it's not consistent.

"|/Value||/KeyValueOfstringstring|
ArrayOfKeyValueOfstringstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays"||KeyValueOfstringstring||Key|type|/Key||Value|"code":"K","description":"MISC"|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|burned|/Key|Value|"code":"N","description":"NO"|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|issuer|/Key||Value|"84"|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|color|/Key||Value|["code":"SIL","description":"Aluminum/Silver"]|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|fCN1|/Key||Value|"P081906400099"|/Value||/KeyValueOfstringstring||/ArrayOfKeyValueOfstringstring|"

So, what's the best way to extract just P081906400099 in this example. I replace a lot of left and right arrows with || since my post would not appear.
TIA

ssrs-2008 reportbuilder3.0

share|improve this question

asked Mar 9 at 1:05

Joseph0169Joseph0169

13

add a comment | 

0

I have a sql statement that calls for a field filled with XML data and I can display that field within a matrix on my report. I'm trying to extract the characters before and after specific tags , but can't figure it out. The field name is called DataXML. The XML can have 0 embedded fields or many fields. As an example, here's how the data on the report which has a pCode in it.

|ArrayOfKeyValueOfstringstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays"||KeyValueOfstringstring||Key>pCode|/Key||Value|"license"|/Value||/KeyValueOfstringstring||/ArrayOfKeyValueOfstringstring|"

However, I'm only interested in grabbing one piece and displaying it. As an example, I just want to display P081906400099. So, the characters before this should always be: fCN1" and the following value should always be

|/Value||/KeyValueOfstringstring||/ArrayOfKeyValueOfstringstring|"

Unfortunately, something else will sometimes be after this in the XML coding so it's not consistent.

"|/Value||/KeyValueOfstringstring|
ArrayOfKeyValueOfstringstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays"||KeyValueOfstringstring||Key|type|/Key||Value|"code":"K","description":"MISC"|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|burned|/Key|Value|"code":"N","description":"NO"|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|issuer|/Key||Value|"84"|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|color|/Key||Value|["code":"SIL","description":"Aluminum/Silver"]|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|fCN1|/Key||Value|"P081906400099"|/Value||/KeyValueOfstringstring||/ArrayOfKeyValueOfstringstring|"

So, what's the best way to extract just P081906400099 in this example. I replace a lot of left and right arrows with || since my post would not appear.
TIA

ssrs-2008 reportbuilder3.0

share|improve this question

asked Mar 9 at 1:05

Joseph0169Joseph0169

13

add a comment | 

I have a sql statement that calls for a field filled with XML data and I can display that field within a matrix on my report. I'm trying to extract the characters before and after specific tags , but can't figure it out. The field name is called DataXML. The XML can have 0 embedded fields or many fields. As an example, here's how the data on the report which has a pCode in it.

|ArrayOfKeyValueOfstringstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays"||KeyValueOfstringstring||Key>pCode|/Key||Value|"license"|/Value||/KeyValueOfstringstring||/ArrayOfKeyValueOfstringstring|"

However, I'm only interested in grabbing one piece and displaying it. As an example, I just want to display P081906400099. So, the characters before this should always be: fCN1" and the following value should always be

|/Value||/KeyValueOfstringstring||/ArrayOfKeyValueOfstringstring|"

Unfortunately, something else will sometimes be after this in the XML coding so it's not consistent.

"|/Value||/KeyValueOfstringstring|
ArrayOfKeyValueOfstringstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays"||KeyValueOfstringstring||Key|type|/Key||Value|"code":"K","description":"MISC"|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|burned|/Key|Value|"code":"N","description":"NO"|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|issuer|/Key||Value|"84"|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|color|/Key||Value|["code":"SIL","description":"Aluminum/Silver"]|/Value||/KeyValueOfstringstring||KeyValueOfstringstring||Key|fCN1|/Key||Value|"P081906400099"|/Value||/KeyValueOfstringstring||/ArrayOfKeyValueOfstringstring|"

So, what's the best way to extract just P081906400099 in this example. I replace a lot of left and right arrows with || since my post would not appear.
TIA

ssrs-2008 reportbuilder3.0

share|improve this question

asked Mar 9 at 1:05

Joseph0169Joseph0169

13

share|improve this question

asked Mar 9 at 1:05

Joseph0169Joseph0169

13

share|improve this question

asked Mar 9 at 1:05

Joseph0169Joseph0169

13

asked Mar 9 at 1:05

Joseph0169Joseph0169

13

asked Mar 9 at 1:05

Joseph0169Joseph0169

13