Thread: [Servingxml-help] Using TAB as delimiter in flat file

Brought to you by: danielaparker

servingxml-help

[Servingxml-help] Using TAB as delimiter in flat file

From: Harry H. h. <Har...@Do...> - 2006-10-19 14:19:00

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Tahoma">Hi,<br>
<br>
I'm new to servingxml and i hope that somebody knows a solution.<br>
<br>
My flat file has a &lt;TAB&gt;&nbsp; as field delimiter&nbsp; (hex'09'). I cannot
find how to tell servingxml that it should use that value for dilimiter.<br>
<br>
My goal&nbsp; is to go fromflat-delimited to xml<br>
<br>
Kind Regards,<br>
Harry<br>
</font></font>
</body>
</html>

Re: [Servingxml-help] Using TAB as delimiter in flat file

From: Daniel P. <dan...@sy...> - 2006-10-20 03:43:35

Hello Harry,

Try using=20

        <sx:fieldDelimiter value=3D"\t"/>

inside your sx:flatRecordType declaration.

Best regards,
Daniel
  ----- Original Message -----=20
  From: Harry Honing; home=20
  To: ser...@li...=20
  Sent: Thursday, October 19, 2006 10:18 AM
  Subject: [Servingxml-help] Using TAB as delimiter in flat file


  Hi,

  I'm new to servingxml and i hope that somebody knows a solution.

  My flat file has a <TAB>  as field delimiter  (hex'09'). I cannot find =
how to tell servingxml that it should use that value for dilimiter.

  My goal  is to go fromflat-delimited to xml

  Kind Regards,
  Harry



-------------------------------------------------------------------------=
-----


  =
-------------------------------------------------------------------------=

  Using Tomcat but need to do more? Need to support web services, =
security?
  Get stuff done quickly with pre-integrated technology to make your job =
easier
  Download IBM WebSphere Application Server v.1.0.1 based on Apache =
Geronimo
  =
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642


-------------------------------------------------------------------------=
-----


  _______________________________________________
  Servingxml-help mailing list
  Ser...@li...
  https://lists.sourceforge.net/lists/listinfo/servingxml-help

Re: [Servingxml-help] Using TAB as delimiter in flat file

From: Harry H. h. <Har...@Do...> - 2006-10-20 07:03:15

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Tahoma">Hello Daniel,<br>
<br>
Thnak you for responding. <br>
I tried it out but this did not work out.<br>
<br>
I know the tab is in the flat file X'09'. Do you know if there is a
possibility to set hex-values for the delimiter.<br>
Or using the ascii escape value in some way. <br>
<br>
Is there in the books a place where to find these kind of codes (like
your suggestion for \t) <br>
<br>
Kind regards,<br>
<br>
Harry<br>
</font></font><br>
Daniel Parker schreef:
<blockquote cite="mid003e01c6f3f9$e85db760$8119fea9@ginger" type="cite">
  <title></title>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <meta content="MSHTML 6.00.2900.2963" name="GENERATOR">
  <style></style>
  <div><font face="Arial" size="2">Hello Harry,</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">Try using </font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sx:fieldDelimiter
value="\t"/&gt;<br>
  </font></div>
  <div><font face="Arial" size="2">inside your sx:flatRecordType
declaration.</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">Best regards,</font></div>
  <div><font face="Arial" size="2">Daniel</font></div>
  <blockquote
 style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;">
    <div
 style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">-----
Original Message ----- </div>
    <div
 style="background: rgb(228, 228, 228) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>From:</b>
    <a title="Har...@Do..."
 href="mailto:Har...@Do...">Harry Honing; home</a> </div>
    <div
 style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>To:</b>
    <a title="ser...@li..."
 href="mailto:ser...@li...">ser...@li...</a>
    </div>
    <div
 style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Sent:</b>
Thursday, October 19, 2006 10:18 AM</div>
    <div
 style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Subject:</b>
[Servingxml-help] Using TAB as delimiter in flat file</div>
    <div><br>
    </div>
    <font size="-1"><font face="Tahoma">Hi,<br>
    <br>
I'm new to servingxml and i hope that somebody knows a solution.<br>
    <br>
My flat file has a &lt;TAB&gt;&nbsp; as field delimiter&nbsp; (hex'09'). I cannot
find how to tell servingxml that it should use that value for dilimiter.<br>
    <br>
My goal&nbsp; is to go fromflat-delimited to xml<br>
    <br>
Kind Regards,<br>
Harry<br>
    </font></font>
    <p> </p>
    <hr>
-------------------------------------------------------------------------<br>
Using Tomcat but need to do more? Need to support web services,
security?<br>
Get stuff done quickly with pre-integrated technology to make your job
easier<br>
Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo<br>
<a class="moz-txt-link-freetext" href="http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642">http://sel.as-us.falkag.net/sel?cmd=lnk&amp;kid=120709&amp;bid=263057&amp;dat=121642</a>
    <p> </p>
    <hr> _______________________________________________<br>
Servingxml-help mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:Ser...@li...">Ser...@li...</a><br>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/servingxml-help">https://lists.sourceforge.net/lists/listinfo/servingxml-help</a><br>
  </blockquote>
</blockquote>
</body>
</html>

Re: [Servingxml-help] Using TAB as delimiter in flat file

From: Daniel P. <dan...@sy...> - 2006-10-22 22:35:49

Hello Harry,

I tested an example with horizontal tab delimiter (x09), using the =
resources script below, with ServingXML version 0.5.5

<sx:resources xmlns:sx=3D"http://www.servingxml.com/core">

  <sx:service id=3D"employees">
    <sx:serialize>
      <sx:transform>
        <sx:content ref=3D"employee-data"/>
      </sx:transform>
    </sx:serialize>
  </sx:service>

  <sx:recordContent id=3D"employee-data" name=3D"employees">
    <sx:flatFileReader>
      <sx:urlSource url=3D"data/tab_delimited_data.txt"/>
      <sx:flatFile ref=3D"employee-file"/>
    </sx:flatFileReader>
  </sx:recordContent>

  <sx:flatFile id=3D"employee-file">
    <sx:flatFileBody>
      <sx:flatRecordType name=3D"employee">
        <sx:fieldDelimiter value=3D"\t"/>
        <sx:delimitedField name=3D"social-security-number"/>
        <sx:delimitedField name=3D"employee-name"/>
        <sx:delimitedField name=3D"salary"/>
      </sx:flatRecordType>
    </sx:flatFileBody>
  </sx:flatFile>

</sx:resources>

It worked as expected, so I can't help without more information.  If you =
can prepare a short failing example, and send it to me as a zipped =
attachment to the inquiries email on the home page, I'll investigate =
further.

Regards,
Daniel Parker
  ----- Original Message -----=20
  From: Harry Honing; home=20
  To: Daniel Parker=20
  Cc: ser...@li...=20
  Sent: Friday, October 20, 2006 3:02 AM
  Subject: Re: [Servingxml-help] Using TAB as delimiter in flat file


  Hello Daniel,

  Thnak you for responding.=20
  I tried it out but this did not work out.

  I know the tab is in the flat file X'09'. Do you know if there is a =
possibility to set hex-values for the delimiter.
  Or using the ascii escape value in some way.=20

  Is there in the books a place where to find these kind of codes (like =
your suggestion for \t)=20

  Kind regards,

  Harry

  Daniel Parker schreef:=20
    Hello Harry,

    Try using=20

            <sx:fieldDelimiter value=3D"\t"/>

    inside your sx:flatRecordType declaration.

    Best regards,
    Daniel
      ----- Original Message -----=20
      From: Harry Honing; home=20
      To: ser...@li...=20
      Sent: Thursday, October 19, 2006 10:18 AM
      Subject: [Servingxml-help] Using TAB as delimiter in flat file


      Hi,

      I'm new to servingxml and i hope that somebody knows a solution.

      My flat file has a <TAB>  as field delimiter  (hex'09'). I cannot =
find how to tell servingxml that it should use that value for dilimiter.

      My goal  is to go fromflat-delimited to xml

      Kind Regards,
      Harry



-------------------------------------------------------------------------=
-
      =
-------------------------------------------------------------------------=

      Using Tomcat but need to do more? Need to support web services, =
security?
      Get stuff done quickly with pre-integrated technology to make your =
job easier
      Download IBM WebSphere Application Server v.1.0.1 based on Apache =
Geronimo
      =
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642=20


-------------------------------------------------------------------------=
-
      _______________________________________________
      Servingxml-help mailing list
      Ser...@li...
      https://lists.sourceforge.net/lists/listinfo/servingxml-help



-------------------------------------------------------------------------=
-----


  =
-------------------------------------------------------------------------=

  Using Tomcat but need to do more? Need to support web services, =
security?
  Get stuff done quickly with pre-integrated technology to make your job =
easier
  Download IBM WebSphere Application Server v.1.0.1 based on Apache =
Geronimo
  =
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642


-------------------------------------------------------------------------=
-----


  _______________________________________________
  Servingxml-help mailing list
  Ser...@li...
  https://lists.sourceforge.net/lists/listinfo/servingxml-help

Re: [Servingxml-help] Using TAB as delimiter in flat file

From: Daniel P. <dan...@sy...> - 2006-10-22 23:18:17

Yes.  I tested my example sent earlier with
     =20
<sx:fieldDelimiter value=3D"&#x09;"/>

and that worked as well.

Danie Parker


  ----- Original Message -----=20
  From: Harry Honing; home=20
  To: Daniel Parker=20
  Cc: ser...@li...=20
  Sent: Friday, October 20, 2006 3:02 AM
  Subject: Re: [Servingxml-help] Using TAB as delimiter in flat file


  Do you know if there is a possibility to set hex-values for the =
delimiter.

Re: [Servingxml-help] Using TAB as delimiter in flat file

From: Daniel P. <dan...@sy...> - 2006-10-20 12:34:34

Harry,

Thanks for the feedback.

The special encodings - \t, \r, and \n - are noted in the =
sx:fieldDelimiter element reference entry.  I'll investigate and respond =
by Monday, with a fix if required.

Daniel
  ----- Original Message -----=20
  From: Harry Honing; home=20
  To: Daniel Parker=20
  Cc: ser...@li...=20
  Sent: Friday, October 20, 2006 3:02 AM
  Subject: Re: [Servingxml-help] Using TAB as delimiter in flat file


  Hello Daniel,

  Thnak you for responding.=20
  I tried it out but this did not work out.

  I know the tab is in the flat file X'09'. Do you know if there is a =
possibility to set hex-values for the delimiter.
  Or using the ascii escape value in some way.=20

  Is there in the books a place where to find these kind of codes (like =
your suggestion for \t)=20

  Kind regards,

  Harry

  Daniel Parker schreef:=20
    Hello Harry,

    Try using=20

            <sx:fieldDelimiter value=3D"\t"/>

    inside your sx:flatRecordType declaration.

    Best regards,
    Daniel
      ----- Original Message -----=20
      From: Harry Honing; home=20
      To: ser...@li...=20
      Sent: Thursday, October 19, 2006 10:18 AM
      Subject: [Servingxml-help] Using TAB as delimiter in flat file


      Hi,

      I'm new to servingxml and i hope that somebody knows a solution.

      My flat file has a <TAB>  as field delimiter  (hex'09'). I cannot =
find how to tell servingxml that it should use that value for dilimiter.

      My goal  is to go fromflat-delimited to xml

      Kind Regards,
      Harry



-------------------------------------------------------------------------=
-
      =
-------------------------------------------------------------------------=

      Using Tomcat but need to do more? Need to support web services, =
security?
      Get stuff done quickly with pre-integrated technology to make your =
job easier
      Download IBM WebSphere Application Server v.1.0.1 based on Apache =
Geronimo
      =
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642=20


-------------------------------------------------------------------------=
-
      _______________________________________________
      Servingxml-help mailing list
      Ser...@li...
      https://lists.sourceforge.net/lists/listinfo/servingxml-help