[Dev]XSL XML JSON

MSSQL Output in XML using For XML « Naveen’s Weblog

2014년 07월 04일 golgol 0

MSSQL Output in XML using For XML « Naveen’s Weblog. http://technet.microsoft.com/en-us/library/ms345137(SQL.90).aspx#forxml2k5_topic8


<span style="color: #0000ff; font-size: small;">select</span><span style="font-size: small;"> FirstName</span><span style="color: #808080; font-size: small;">,</span><span style="font-size: small;">LastName </span><span style="color: #0000ff; font-size: small;">from</span><span style="font-size: small;"> Employee </span><span style="color: #0000ff; font-size: small;">for <span style="color: #0000ff; font-size: small;">xml <span style="color: #0000ff; font-size: small;">AUTO </span></span></span><span style="color: #808080; font-size: small;">, </span><span style="color: #0000ff; font-size: small;">elements</span>

1

2

3

select FirstName,LastName from Employee for xml AUTO , elements

[xsl] XsltSettings.EnableScript

2014년 07월 03일 golgol 0

스크립트를 실행하려면 XsltSettings.EnableScript 속성을 사용하십시오


using System.Xml;
using System.Xml.Xsl;
using System.Xml.XPath;
using System.IO;
//

//
XmlDocument xml = new XmlDocument();
Xml.PreserveWhitespace = false;
XslCompiledTransform xslt = new XslCompiledTransform();
StringWriter stringWriter = new StringWriter();

xml.PreserveWhitespace = false;
xml.LoadXml(sParsing); //XML
xslt.Load(Server.MapPath("ET_KR.xslt"), XsltSettings.TrustedXslt, new XmlUrlResolver()); //WEB
 
 //XmlReaderSettings settings = new XmlReaderSettings();
 //XmlReader reader = XmlReader.Create(@"D:\Test\ET_KR.xslt", settings);
 //xslt.Load(reader, XsltSettings.TrustedXslt, new XmlUrlResolver()); //Application

xslt.Transform(xml, null, stringWriter);

//return stringWriter.ToString();

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

using System.Xml;

using System.Xml.Xsl;

using System.Xml.XPath;

using System.IO;

//

XmlDocument xml = new XmlDocument();

Xml.PreserveWhitespace = false;

XslCompiledTransform xslt = new XslCompiledTransform();

StringWriter stringWriter = new StringWriter();

xml.PreserveWhitespace = false;

xml.LoadXml(sParsing); //XML

xslt.Load(Server.MapPath("ET_KR.xslt"), XsltSettings.TrustedXslt, new XmlUrlResolver()); //WEB

//XmlReaderSettings settings = new XmlReaderSettings();

//XmlReader reader = XmlReader.Create(@"D:\Test\ET_KR.xslt", settings);

//xslt.Load(reader, XsltSettings.TrustedXslt, new XmlUrlResolver()); //Application

xslt.Transform(xml, null, stringWriter);

//return stringWriter.ToString();

[XSL] replace template

2014년 06월 18일 golgol 0


<xsl:function name="functx:replace-multi" as="xs:string?"
              xmlns:functx="http://www.functx.com">
  <xsl:param name="arg" as="xs:string?"/>
  <xsl:param name="changeFrom" as="xs:string*"/>
  <xsl:param name="changeTo" as="xs:string*"/>

  <xsl:sequence select="
   if (count($changeFrom) > 0)
   then functx:replace-multi(
          replace($arg, $changeFrom[1],
                     functx:if-absent($changeTo[1],'')),
          $changeFrom[position() > 1],
          $changeTo[position() > 1])
   else $arg
 "/>

</xsl:function>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

<xsl:function name="functx:replace-multi" as="xs:string?"

xmlns:functx="http://www.functx.com">

<xsl:param name="arg" as="xs:string?"/>

<xsl:param name="changeFrom" as="xs:string*"/>

<xsl:param name="changeTo" as="xs:string*"/>

<xsl:sequence select="

if (count($changeFrom) > 0)

then functx:replace-multi(

replace($arg, $changeFrom[1],

functx:if-absent($changeTo[1],'')),

$changeFrom[position() > 1],

$changeTo[position() > 1])

else $arg

"/>

</xsl:function>


<xsl:variable name="fr" select="('[a-c]', 'def', '\d+')"/>
<xsl:variable name="to" select="('x', 'y', '0')"/>
XPath Example	Results
functx:replace-multi('abcdef123',$fr,$to)
xxxy0

1

2

3

4

5

6

7

<xsl:variable name="fr" select="('[a-c]', 'def', '\d+')"/>

<xsl:variable name="to" select="('x', 'y', '0')"/>

XPath Example Results

functx:replace-multi('abcdef123',$fr,$to)

xxxy0

참조 : http://www.xsltfunctions.com/xsl/functx_replace-multi.html 더 간단한 방법


var data = "abc/def/gh";
var result = data.replace(/\//gi, '');
console.log('결과', result); // abcdefgh

1

2

3

4

5

var data = "abc/def/gh";

var result = data.replace(/\//gi, '');

console.log('결과', result); // abcdefgh

참조 : http://www.codejs.co.kr/%EC%9E%90%EB%B0%94%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EC%97%90%EC%84%9C-replace%EB%A5%BC-replaceall-%EC%B2%98%EB%9F%BC-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0/


<xsl:value-of select=”translate(., ‘D’, ‘$’)”/>

1

2

3

<xsl:value-of select=”translate(., ‘D’, ‘$’)”/>

XSLT xsl:copy-of Element

2013년 01월 15일 golgol 0

Namespace nodes, child nodes, and attributes of the current node are automatically copied as well!


<xsl:copy-of select="expression"/>
 
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 
<xsl:variable name="header">
<tr>
<th>Element</th>
<th>Description</th>
</tr>
</xsl:variable>
 
<xsl:template match="/">
<html>
<body>
<table>
<xsl:copy-of select="$header" />
<xsl:for-each select="reference/record">
<tr>
<xsl:if test="category='XML'">
<td><xsl:value-of select="element"/></td>
<td><xsl:value-of select="description"/></td>
</xsl:if>
</tr>
</xsl:for-each>
</table>
<br />
<table>
<xsl:copy-of select="$header" />
<xsl:for-each select="table/record">
<tr>
<xsl:if test="category='XSL'">
<td><xsl:value-of select="element"/></td>
<td><xsl:value-of select="description"/></td>
</xsl:if>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

<xsl:copy-of select="expression"/>

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:variable name="header">

<tr>

<th>Element</th>

<th>Description</th>

</tr>

</xsl:variable>

<xsl:template match="/">

<html>

<body>

<table>

<xsl:copy-of select="$header" />

<xsl:for-each select="reference/record">

<tr>

<xsl:if test="category='XML'">

</xsl:if>

</tr>

</xsl:for-each>

</table>

<table>

<xsl:copy-of select="$header" />

<xsl:for-each select="table/record">

<tr>

<xsl:if test="category='XSL'">

</xsl:if>

</tr>

</xsl:for-each>

</table>

</body>

</html>

</xsl:template>

MSSQL Output in XML using For XML « Naveen’s Weblog

[xsl] XsltSettings.EnableScript

[XSL] replace template

[OralceJava커뮤니티 XML강좌]XML

얕고 좁은 지식들 :: 08.XML Schema

XINS를 통해 REST, SOAP, XML-RPC, JSON, JSON-RPC 인터페이스 개발 – Mimul’s Developer World

Mr. Data Converter [excel/csv => json]

Kimstars Second Blog __ JSON 개요 및 예제

xslt 1.0 How to replace the space with some string from all the text values in xml? – Stack Overflow

XSLT xsl:copy-of Element