Converting Text File into XML using Unix Shell Scripts


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Converting Text File into XML using Unix Shell Scripts
# 8  
Old 02-16-2005
Quote:
Originally posted by Laud12345
The file has fields with each field having a certain number of bytes
That is dependent on number of characters in field, ASCII
is an encoding where each character is represented as
exactly one byte.

It is clear from the sample data you have given there is a
set pattern from alpha characters to digits.

C has isalpha() and isdigit() and most other languages have
something similar to this.

If you use regular expressions [A-Z] or [a-z] and [0-9] will work.

Not given enough information on your sample data, you may
try splitting on whitespace or from alpha char to digit.

Last edited by photon; 02-16-2005 at 01:36 PM..
# 9  
Old 02-16-2005
Anything wrong with this code you see? I cannot get it to run: I am basically trying to run some awk code within a korn shell. I want to run the trim funciton, but I get complaint when I run the script.


#!/bin/ksh

awk '

function trim(str)
{
sub("^[ ]*", "", str);
sub("[ ]*$", "", str);
return str;
}

gref = substr($0,2,32);
gref = trim(gref);

}'
# 10  
Old 02-16-2005
Quote:
Originally Posted by Laud12345
Anything wrong with this code you see? I cannot get it to run: I am basically trying to run some awk code within a korn shell. I want to run the trim funciton, but I get complaint when I run the script.


#!/bin/ksh

awk '

function trim(str)
{
sub("^[ ]*", "", str);
sub("[ ]*$", "", str);
return str;
}

gref = substr($0,2,32);
gref = trim(gref);

}'
1. [as always] if on Solaris, use nawk instead of awk.
2. where is you input to awk?
3. what is your ACTION? - you have mis-matched '{}' for your action. I think you want something like this:

Code:
#!/bin/ksh

nawk '
function trim(str)
{
   sub("^[ ]*", "", str);
   sub("[ ]*$", "", str);
   return str;
}

{
  gref = trim(substr($0,2,32));
  print gref
}' path2YourInputFileGoesHere

# 11  
Old 02-16-2005
Thanks vgersh99.

I am using Solaris.

My input to awk is some sort of file. I think I do have the braces messed up. I did get it to work. I am very greatful.

Regards,
Laud
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Programming

How to write in other language in text/xml file by reading english text/xml file using C++?

Hello Team, I have 2 files.one contains english text and another contains Japanese. so i have to read english text and replace the text with Japanesh text in third file. Basically, I need a help to write japanese language in text/xml file.I heard wstring does this.Not sure how do i write... (2 Replies)
Discussion started by: SA_Palani
2 Replies

2. UNIX for Dummies Questions & Answers

Reading XML file and print the values in the text file using Linux shell script

hi guys, i want help... Reding XML file and print the values into the text file using linux shell script file as per below xml file <sequence> <Filename>aldorzum.doc</Filename> <DivisionCode>US</DivisionCode> <ContentType>Template</ContentType> <ProductCode>VIMZIM</ProductCode> </sequence>... (1 Reply)
Discussion started by: sravanreddy
1 Replies

3. Solaris

XML to Text file Parsing Using shell scripting

Hi, I want to parse an XML File using Shell Script preferably by using awk command, I/P file is : <gn:ExternalGsmCell id="016P3A"> <gn:attributes> <gn:mnc>410</gn:mnc> <gn:mcc>310</gn:mcc> <gn:lac>8016</gn:lac> ... (2 Replies)
Discussion started by: tech_frk
2 Replies

4. Shell Programming and Scripting

Help with converting XML to Flat file

Hi Friends, I want to convert a XML file to flat file. Sample I/p: <?xml version='1.0' encoding='UTF-8' ?> <DataFile xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' contactCount='4999' date='2012-04-14' time='22:00:14' xsi:noNamespaceSchemaLocation='gen .xsd'> <Contact... (3 Replies)
Discussion started by: karumudi7
3 Replies

5. Shell Programming and Scripting

XML to Text file Parsing Using shell scripting

Hi folks, Need some help with XML to text file parsing , the following is the content of the XML File. <xn:SubNetwork id="SNJNPRZDCR0R03"> <xn:MeContext id="PRSJU0005"> <xn:VsDataContainer id="PRSJU0005"> <xn:attributes> ... (6 Replies)
Discussion started by: tech_frk
6 Replies

6. UNIX for Dummies Questions & Answers

converting scripts from dos 2 unix format

Hi, I am new to shell scripting and exploring it , I have developed few sample shell script but I have developed them on windows xp notepad and then saving them on folder and then testing them on cywgin and running perfectly...but these scripts are in dos format and I want to convert them in unix... (1 Reply)
Discussion started by: rahul125
1 Replies

7. Shell Programming and Scripting

Shell program to check if the same text appears twice in an XML file

Hi All, I am very new to this forum and beginner to shell scripting. I need a shell script to: Search for a text in XML file à if the same text appears twice in an XML file à output file name Script should loop thru every xml file of a given folder. Please help me writing this script. ... (1 Reply)
Discussion started by: amardeep001
1 Replies

8. Windows & DOS: Issues & Discussions

Converting UNIX scripts to DOS

Is there a tool available to convert UNIX (BASH Shell) scripts to DOS scripts? I understand that DOS scripting is far inferior to unix scripting, and therfore this conversion may not be possible. Alternativley, perhaps I could convert my Unix scripts to C... then compile it for a windows... (2 Replies)
Discussion started by: Crozz
2 Replies

9. Shell Programming and Scripting

Plz Help To convert xml file to text file using bourn shell scripts

If someone out there could help me out with this problem. I would really appreciate it. I am trying to convert xml into text file(fixed length) using Unix Borne shell scripts. My xml file: <root> <header_rec recordtype="00"> <record_id>00</record_id> <country_code>AK></country_code>... (0 Replies)
Discussion started by: ram2s2001
0 Replies
Login or Register to Ask a Question