Tuesday, December 30, 2008

More options in Native Format Builder

INTRODUCTION:
This wizard helps you in creating XSDs for your sample files. This is used to create a native schema file from formats such as:- comma-separated value (CSV), fixed-length file, data type description (DTD), and Cobol Copybook.

SCENARIO:
Suppose you need to create a schema file for a pipe-delimeter or $ delimeter sample file. If you closely look into the options provided under Step 5 of 7 (If you select Delimited Radio button in Step1 of 7) in Native Format Builder, you will see only 5 options available i.e. Single Space, Comma, Semicolon, White space (any number of tab, space) and Tab.
Then how to create a pipe-delimeter or $ delimeter schema file??

SOLUTION:
Goto options provided under Step 5 of 7 (If you select Delimited Radio button in Step1 of 7) in Native Format Builder.
In the Fields ->Delimited by drop down option, double click. A pointer will appear. Now instead of using drop down option manually type the |(pipe).

Then finish off the wizard. Your work is done..So simple.
The pipe delimited file schema file is ready to use.

Keep learning and stay connected to SOA.

WISHING ALL THE BLOG READERS A VERY HAPPY NEW YEAR 2009.

5 comments:

Ranjit Singh said...

I have to add the tild(~) instead of comma(,).I am not able to see any pointer.Also when I am changing ~ from , sign its convert my mapping of elements from C1....C15 to single elements C1.

Please help me it very urgent for me. Thanks for your support.

sowmya narala said...
This comment has been removed by the author.
sowmya n said...

Thank you that was helpful

Unknown said...

Excellent , Thank you.

Dhanya Sree said...

Thank you, this was helpful.