|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to make delimited record ????
Post 302594295 by knight_eon on Tuesday 31st of January 2012 03:07:05 AM
01-31-2012
Well that is going to be difficult 
... What is the source of your data? Is it again generated by another script?
Difficult with such data file is that the content are free flowing. For such, there will always be a chance of data inconsistencies in the output even if we manage to write some script to parse this data file.
If you have the script which gives you this data file as input, then I will suggest making amends in that script itself... atleast make some provision that the data you receive are properly enclosed in single/double quotes.
... What is the source of your data? Is it again generated by another script? Difficult with such data file is that the content are free flowing. For such, there will always be a chance of data inconsistencies in the output even if we manage to write some script to parse this data file.
If you have the script which gives you this data file as input, then I will suggest making amends in that script itself... atleast make some provision that the data you receive are properly enclosed in single/double quotes.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file which contains 1 million records of the following format. Each field is delimited by a pipe tilda pipe "|~|" show below. I would like to print only one column ie the CARDDESC value.
for example here it says CARDDESC=A8T1.
so anything after CARDDESC= and before |~|CARDTYPE is what... (11 Replies)
Discussion started by: knijjar
11 Replies
2. Shell Programming and Scripting
Hi All,
The following is the scenario
id name
--------------
1 William;Johnson
2 Azim;Abdul
3 Grasim
.
.
etc....
I need the following output
id name
--------------
1 William
1 Johnson
2 Azim (2 Replies)
Discussion started by: kottursamy
2 Replies
3. Red Hat
I am trying to count the number of columns in a delimited flat file. The record is tab delimited. When I use the command wc -w, I am getting unexpected results when the record contains a NULL value. I believe it is because there is a "word" missing.
The below example will return 4 words... (2 Replies)
Discussion started by: nmalencia
2 Replies
4. Shell Programming and Scripting
Very, very new to unix scripting and have a unique situation. I have a file of records that contain 3 records types:
(H)eader Records
(D)etail Records
(T)railer Records
The Detail records are 82 bytes in length which is perfect. The Header and Trailer records sometimes are 82 bytes in... (3 Replies)
Discussion started by: jclanc8
3 Replies
5. Shell Programming and Scripting
Hi Everyone,
Using shell script i am getting final file as attached below. In this 4th column value should be unique using any sequence.
for instance I've 1_13020_SSGM which is appearing 6 times in file and i should change it like 1_13020_SSGM_1,1_13020_SSGM_2,....1_13020_SSGM_6.
Can someone... (4 Replies)
Discussion started by: gehlnar
4 Replies
6. Shell Programming and Scripting
Hi All,
I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Discussion started by: CarpKing
4 Replies
7. Shell Programming and Scripting
Hi How to make tab delimited file to space delimited?
in put file:
ABC kgy
jkh ghj
ash kjl
o/p file:
ABC kgy
jkh ghj
ash kjl
Use code tags, thanks. (1 Reply)
Discussion started by: jagdishrout
1 Replies
8. Shell Programming and Scripting
Hi Forum.
I'm struggling to find a solution for the following issue.
I have multiple files a1.txt, a2.txt, a3.txt, etc. and I would like to insert a tab-delimited header record at the beginning of each of the files.
This is my code so far but it's not working as expected.
for i in... (2 Replies)
Discussion started by: pchang
2 Replies
9. Shell Programming and Scripting
Hi,
I have the following output from an Oracle SQL statement and I want to remove duplicated column values.
I know it is possible using Oracle analytical/statistical functions but unfortunately I don't know how to use any of those.
So now, I've gone to PLAN B using awk/sed maybe or any... (5 Replies)
Discussion started by: newbie_01
5 Replies
10. Shell Programming and Scripting
Hi,
I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file.
Example of the SQL will be
For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING.
I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies
LEARN ABOUT SUSE
date::manip::changes6
Date::Manip::Changes6(3) User Contributed Perl Documentation Date::Manip::Changes6(3) NAME
Date::Manip::Changes6 - backward incompatible changes in Date::Manip 6.xx SYNOPSIS
This describes all backwards incompatible changes made to the Date::Manip module starting at version 6.00. DESCRIPTION
For the most part, Date::Manip has remained backward compatible at every release, but occasionally, a change is made which is backward incompatible. These are documented here. Major changes are marked with asterisks. 6.05 %z format In Date::Manip 5.xx, the %z format in UnixDate printed the offset in the form -0500. In 6.00, I changed that to -05:00:00, but this broke RFC 822 compliance. I've changed %z back to -0500, and introduced a new format (%N) which returns -05:00:00. Incidentally, this is the LAST unused letter, so I am now going to have to either stop adding formats, or add some extended format syntax. Not sure yet which, but this may involve a backwards incompatible change in the future. BUGS AND QUESTIONS
Please refer to the Date::Manip::Problems documentation for information on submitting bug reports or questions to the author. SEE ALSO
Date::Manip - main module documentation LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself. AUTHOR
Sullivan Beck (sbeck@cpan.org) perl v5.12.1 2010-01-12 Date::Manip::Changes6(3)