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
Old 01-31-2012
Well that is going to be difficult Smilie... 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

help with awk delimited by |~| in a record

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

Split a record ( in a row) and make it as new row

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

Counting columns in a delimited record with NULLs

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

Make variable length record a fixed length

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

Managing sequence to make unique record

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

Need a script to convert comma delimited files to semi colon delimited

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

How to make tab delimited file to space delimited?

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

Insert a header record (tab delimited) in multiple files

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

How to delete 'duplicated' column values and make a delimited file too?

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

Help/Advise please for converting space delimited string variable to comma delimited with quote

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
ost::Date(3)						     Library Functions Manual						      ost::Date(3)

NAME
ost::Date - The Date class uses a julian date representation of the current year, month, and day. SYNOPSIS
#include <numbers.h> Inherited by ost::DateNumber, and ost::Datetime. Public Member Functions Date (time_t tm) Date (tm *dt) Date (char *str, size_t size=0) Date (int year, unsigned month, unsigned day) Date () virtual ~Date () int getYear (void) const unsigned getMonth (void) const unsigned getDay (void) const unsigned getDayOfWeek (void) const char * getDate (char *buffer) const time_t getDate (void) const time_t getDate (tm *buf) const long getValue (void) const void setDate (const char *str, size_t size=0) bool isValid (void) const operator long () const String operator() () const Date & operator++ () Date & operator-- () Date & operator+= (const long val) Date & operator-= (const long val) int operator== (const Date &date) int operator!= (const Date &date) int operator< (const Date &date) int operator<= (const Date &date) int operator> (const Date &date) int operator>= (const Date &date) bool operator! () const Protected Member Functions void toJulian (long year, long month, long day) void fromJulian (char *buf) const virtual void update (void) A method to use to 'post' any changed values when shadowing a mixed object class. Protected Attributes long julian Friends Date operator+ (const Date &date, const long val) Date operator- (const Date &date, const long val) Date operator+ (const long val, const Date &date) Date operator- (const long val, const Date &date) Detailed Description The Date class uses a julian date representation of the current year, month, and day. This is then manipulated in several forms and may be exported as needed. Author: David Sugar dyfet@ostel.com julian number based date class. Constructor &; Destructor Documentation ost::Date::Date (time_ttm) ost::Date::Date (tm *dt) ost::Date::Date (char *str, size_tsize = 0) ost::Date::Date (intyear, unsignedmonth, unsignedday) ost::Date::Date () virtual ost::Date::~Date () [virtual] Member Function Documentation void ost::Date::fromJulian (char *buf) const [protected] char* ost::Date::getDate (char *buffer) const time_t ost::Date::getDate (void) const time_t ost::Date::getDate (tm *buf) const unsigned ost::Date::getDay (void) const unsigned ost::Date::getDayOfWeek (void) const unsigned ost::Date::getMonth (void) const long ost::Date::getValue (void) const int ost::Date::getYear (void) const bool ost::Date::isValid (void) const Reimplemented in ost::Datetime. ost::Date::operator long () const [inline] bool ost::Date::operator! (void) const [inline] Reimplemented in ost::Datetime. int ost::Date::operator!= (const Date &date) String ost::Date::operator() () const Date& ost::Date::operator++ () Date& ost::Date::operator+= (const longval) Date& ost::Date::operator-- () Date& ost::Date::operator-= (const longval) int ost::Date::operator< (const Date &date) int ost::Date::operator<= (const Date &date) int ost::Date::operator== (const Date &date) int ost::Date::operator> (const Date &date) int ost::Date::operator>= (const Date &date) void ost::Date::setDate (const char *str, size_tsize = 0) void ost::Date::toJulian (longyear, longmonth, longday) [protected] virtual void ost::Date::update (void) [protected], [virtual] A method to use to 'post' any changed values when shadowing a mixed object class. This is used by DateNumber. Reimplemented in ost::DateNumber. Friends And Related Function Documentation Date operator+ (const Date &date, const longval) [friend] Date operator+ (const longval, const Date &date) [friend] Date operator- (const Date &date, const longval) [friend] Date operator- (const longval, const Date &date) [friend] Member Data Documentation long ost::Date::julian [protected] Author Generated automatically by Doxygen for GNU CommonC++ from the source code. GNU CommonC++ Sat Jun 23 2012 ost::Date(3)
All times are GMT -4. The time now is 09:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy