SSDN - Subsitute of transverse

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

shivan mahajan

Subject: Subsitute of transverse
Author: shivan mahajan
Date: 18 Oct 2005 04:18 PM

hi,
Is there anything else i can use instead of transverse. Because the command fails when i try to replace this character"" . But if i try to find this character. It finds it. So i am thinking of using something else to find this character. As i think transverse is unable to find this character.
Suggestions will be helpful
thanks
shivan

Ivan Pedruzzi

Subject: Subsitute of transverse
Author: Ivan Pedruzzi
Date: 18 Oct 2005 04:51 PM

Shivan,

Unless you post an example of your XML input file as *attachment* and show to us the expected result, we will not be able to help you.

Regards
Ivan Pedruzzi
Stylus Studio Team

shivan mahajan

Subject: Subsitute of transverse
Author: shivan mahajan
Date: 18 Oct 2005 04:59 PM

The xml looks like this:
<?xml version="1.0" encoding="iso-8859-1"?>
<leb_connect>
<Budget clientBudgetID="Sindelar v. Eckerd 12/31/05" privateFlag="1" budgetPeriod="" fiscalYear="0" startDate="2005-09-01" endDate="2005-12-31" category="" comments="">
<Matter mtrNumber="OSOS302ES" mtrName="JOANNE SINDELAR VS. ECKERD - 638-023814-0001" mtrState="ACCEPTED" mtrStartDate="2005-03-22" mtrComment=""><MatterClass desc="638"/> </Matter>
<Author>
<ClientAuthor createdTimestamp="2005-10-14T07:57:09">
<User employeeID="DEFAULT" firstName="Legal eXchange" middleName="" lastName="System" userName="" activeDate="2005-08-19"/>
</ClientAuthor>
</Author>
</Budget>

the xslt which i wrote is like this:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:fn="http://www.w3.org/2005/02/xpath-functions" xmlns:xdt="http://www.w3.org/2005/02/xpath-datatypes">
<xsl:template match="/">

<Budget_History_struct>
<xsl:for-each select="leb_connect/Budget">

<Budget_history>

<xsl:variable name="mtrNumber" select="Matter/@mtrNumber"/>
<xsl:variable name="editTimestamp" select="EditHistoryList/EditHistory/@editTimestamp"/>
<xsl:variable name="editDescription" select="EditHistoryList/EditHistory/@editDescription"/>
<xsl:for-each select="EditHistoryList/EditHistory/User">
<xsl:element name="User">

<xsl:variable name="employeeID" select="@employeeID"/>
<xsl:variable name="firstName" select="@firstName"/>
<xsl:variable name="middleName" select="@middleName"/>
<xsl:variable name="lastName" select="@lastName"/>
<xsl:variable name="userName" select="@userName"/>
<xsl:variable name="activeDate" select="@activeDate"/>
<xsl:attribute name="clientBudgetID"><xsl:value-of select="translate(string str:decode($clientBudgetID), 'left', ' ')"/></xsl:attribute>
<xsl:attribute name="mtrNumber"><xsl:value-of select="$mtrNumber"/></xsl:attribute>
<xsl:attribute name="editTimestamp"><xsl:value-of select="$editTimestamp"/></xsl:attribute>
<xsl:attribute name="editDescription"><xsl:value-of select="$editDescription"/></xsl:attribute>
<xsl:attribute name="employeeID"><xsl:value-of select="$employeeID"/></xsl:attribute>
<xsl:attribute name="firstName"><xsl:value-of select="$firstName"/></xsl:attribute>
<xsl:attribute name="middleName"><xsl:value-of select="$middleName"/></xsl:attribute>
<xsl:attribute name="lastName"><xsl:value-of select="$lastName"/></xsl:attribute>
<xsl:attribute name="userName"><xsl:value-of select="$userName"/></xsl:attribute>
<xsl:attribute name="activeDate"><xsl:value-of select="$activeDate"/></xsl:attribute>

</xsl:element>
</xsl:for-each>
</Budget_history>
</xsl:for-each>
</Budget_History_struct>
</xsl:template>
</xsl:stylesheet>

shivan mahajan

Subject: Subsitute of transverse
Author: shivan mahajan
Date: 18 Oct 2005 05:00 PM

Enclude with in is the attachment.

All your help is really appreciated.

thanks
shivan

xmlfile.xml
xml file

PROB.xslt
Xslt file

Minollo I.

Subject: Subsitute of transverse
Author: Minollo I.
Date: 18 Oct 2005 05:29 PM

Shivan,
your XML document is not well-formed; if you try to check it in Stylus Studio, you will get:

Checking xmlfile.xml...
http://www.stylusstudio.com/SSDN/upload/xmlfile.xml:3,39: FATAL ERROR: Invalid character in attribute value clientBudgetID (Unicode: 0x15)

Not being a well formed XML document, it can't be processed by XSLT; you will need to fix it before that can happen.

Hope this helps,
Minollo

shivan mahajan

Subject: Subsitute of transverse
Author: shivan mahajan
Date: 18 Oct 2005 05:34 PM

I am getting this invalid character in the xml daily feed. This process is in production and is automatic. But when ever there is a strange character. It fails. So i am looking to find a way to replace this strange character by a space. I know xml cannot understand that. But if i do find and replace in the xml spy. It does understand. So i am just trying to find a way. Because i cannot manually do this everytime.
suggestions will be helpful.
thanks
shivan

Minollo I.

Subject: Subsitute of transverse
Author: Minollo I.
Date: 18 Oct 2005 05:52 PM

Also the Stylus Studio XML Editor allows you to manually replace the wrong character (Ctrl+h, click "Regular Expression", look for \x15 and replace it with the character string you prefer).

As long as automated processes go for replacing the 0x15 character, almost anything would do, from Perl to Java, from C++ to Prolog...

Minollo

shivan mahajan

Subject: Subsitute of transverse
Author: shivan mahajan
Date: 19 Oct 2005 08:59 AM

how can i replace this character using java. If you have some
code that will be really helpful.
thanks
shivan

shivan mahajan

Subject: Subsitute of transverse
Author: shivan mahajan
Date: 19 Oct 2005 10:30 AM

I am using this java code:
package com.aig.bottomline;
import java.io.BufferedReader;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.StringReader;
import java.io.StringWriter;
import java.io.FileOutputStream;
import java.util.HashMap;

import javax.xml.transform.Source;
import javax.xml.transform.Templates;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerException;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.stream.StreamResult;
import javax.xml.transform.stream.StreamSource;
import org.xml.sax.SAXException;
import sun.security.util.Debug;

public class TestTransformer {

private String INPUT_FILE = "";
private String OUTPUT_FILE = "";
private String TRANSLATING_FILE = "";

public TestTransformer(String pInputFile, String pOutputFile, String pTransFile)
{
this.INPUT_FILE = pInputFile;
this.OUTPUT_FILE = pOutputFile;
this.TRANSLATING_FILE = pTransFile;
}

/**
* The primary method in this class. Takes an XML string,
* and an output writer and converts the XML to sequenced XML.
*/

public void transform(){
try {
TransformerFactory tFactory = TransformerFactory.newInstance();
Source xslSource = new StreamSource(this.TRANSLATING_FILE);
Transformer transformer = tFactory.newTransformer( xslSource );
transformer.transform(new StreamSource(this.INPUT_FILE),new StreamResult(new FileOutputStream(this.OUTPUT_FILE )));
}catch( Exception ex ){
ex.printStackTrace();
}
}

public static void main(String[] args) {
try{
if (args.length != 3){
System.out.println("Please provide the file names for input file, output file and translation file");
}else{

String pInputFile=args[0];
String pOutputFile=args[1];
String pTransFile=args[2];

TestTransformer transTest = new TestTransformer(pInputFile, pOutputFile, pTransFile);
transTest.transform();

}
}catch(Exception e){
e.printStackTrace();
}
}
}

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.