Sponsored Content
Top Forums Shell Programming and Scripting Help with Data Positioning from Columns in a flat file. Post 302076611 by oott1 on Wednesday 14th of June 2006 12:44:00 PM
Old 06-14-2006
Hi...vergsh99

1) yes it all starts at the first position, BUT the data is not specific after that...tho they do follow this pattern.. city then state then zip

2) yes its that format...but they all have various positioning

3) US was just an example...it can be any state abbr....TX, CA, etc..

4) examples:

BIG COVE TANNRY PA 17212
WEST CHESTER PA 19382
PEARL RIVER NY10965
JAMAICA NY 11432


I need it look like this
Pos 159-181 Pos 182-188

BIG COVE TANNRY PA17212
WEST CHESTER PA19382
PEARL RIVER NY10965
JAMAICA NY11432
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

inserting data into a table from a flat file

Hi, I want to insert data into a table from a flat file, the file is having around 25 columns and some 10,000 records. The columns values are seperated by a space. Thanks (1 Reply)
Discussion started by: ss_ss
1 Replies

2. Shell Programming and Scripting

Load data from a flat file to oracle.

I have a flat file with records like Header 123 James Williams Finance2000 124 Pete Pete HR 1500 125 PatrickHeather Engg 3000 Footer The structure is: Eno:4 characters Name:8 characters Surname : 9 characters Dept:7 characters Sal:4characters These are sample... (1 Reply)
Discussion started by: Shivdatta
1 Replies

3. UNIX for Dummies Questions & Answers

Normalize Data and write to a flat file

All, Can anyone please help me with the below scenario. I have a Flat file of the below format. ID|Name|Level|Type|Zip|MAD|Risk|Band|Salesl|Dealer|CID|AType|CValue|LV|HV|DCode|TR|DU|NStartDate|UserRole|WFlag|EOption|PName|NActivationDate|Os|Orig|Cus|OType|ORequired|DType 03|... (10 Replies)
Discussion started by: sp999
10 Replies

4. Shell Programming and Scripting

To read a flat file containing XML data

I have a file something like this:aaaa.xml content of the file is 0,<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <storeInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <s> <BRANCH_NO>3061</BRANCH_NO> <BRANCH_NAME>GREEN EXPRESS</BRANCH_NAME> ... (4 Replies)
Discussion started by: kmanivan82
4 Replies

5. UNIX for Dummies Questions & Answers

Audit Flat File - # of Columns / Rows

We receive a file which usually has 40 to 50 million rows. I want to set up an audit process by which everytime we receive a file we audit it for # of rows and total number of columns. So if the # of rows is around 1 million on a particular day, I want to raise a flag or send an email....and if... (3 Replies)
Discussion started by: priya33184
3 Replies

6. Shell Programming and Scripting

Read flat file upto certain number of columns

Hello Guys Please help me with the below issue I want to read a flat file source upto certain number of columns Say my flat file has 30 columns but I want to read upto 25 columns only How come the above issue can be addressed? Thanks a lot!!!! (1 Reply)
Discussion started by: Pratik4891
1 Replies

7. Shell Programming and Scripting

Insert empty columns in a flat file

Hi, I have a tab delimited flat file, for example shown below Name Desg Loc a b c d e fI want to insert an empty column inbetween the column Desc and Loc, the result should be like shown below: Name LName Desg Loc a b c d e ... (6 Replies)
Discussion started by: sampoorna
6 Replies

8. Shell Programming and Scripting

Getting data from a flat file based on condition

Hi, I have a flaty file from which i am fetching few columns in tablular form as below code. Now i want to fetch the column 6 and 7 in below code only if it either of them is non zero.However below startement awk -F, '$6==0 && $7==0{exit 1}' ${IFILE} is not working..Not sure where is the... (36 Replies)
Discussion started by: Vivekit82
36 Replies

9. Shell Programming and Scripting

Oracle table extract: all columns are not converting into pipe delimited in flat file

Hi All, I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far. 1. Table.txt ==> database extract file 2. flat.txt ==> pipe delimited after some manipulation of the original db... (5 Replies)
Discussion started by: express14
5 Replies
wxChoice(3erl)						     Erlang Module Definition						    wxChoice(3erl)

NAME
wxChoice - See external documentation: wxChoice. DESCRIPTION
See external documentation: wxChoice . This class is derived (and can use functions) from: wxControlWithItems wxControl wxWindow wxEvtHandler DATA TYPES
wxChoice() : An object reference, The representation is internal and can be changed without notice. It can't be used for comparsion stored on disc or distributed for use on other nodes. EXPORTS
new() -> wxChoice() See external documentation . new(Parent::wxWindow() (see module wxWindow), Id::integer()) -> wxChoice() Equivalent to new(Parent, Id, []) . new(Parent::wxWindow() (see module wxWindow), Id::integer(), Options::[Option]) -> wxChoice() Types Option = {pos, {X::integer(), Y::integer()}} | {size, {W::integer(), H::integer()}} | {choices, [[string()]]} | {style, inte- ger()} | {validator, wx() (see module wx)} See external documentation . create(This::wxChoice(), Parent::wxWindow() (see module wxWindow), Id::integer(), Pos::{X::integer(), Y::integer()}, Size::{W::integer(), H::integer()}, Choices::[[string()]]) -> bool() Equivalent to create(This, Parent, Id, Pos, Size, Choices, []) . create(This::wxChoice(), Parent::wxWindow() (see module wxWindow), Id::integer(), Pos::{X::integer(), Y::integer()}, Size::{W::integer(), H::integer()}, Choices::[[string()]], Options::[Option]) -> bool() Types Option = {style, integer()} | {validator, wx() (see module wx)} See external documentation . delete(This::wxChoice(), N::integer()) -> ok See external documentation . getColumns(This::wxChoice()) -> integer() See external documentation . setColumns(This::wxChoice()) -> ok Equivalent to setColumns(This, []) . setColumns(This::wxChoice(), Options::[Option]) -> ok Types Option = {n, integer()} See external documentation . destroy(This::wxChoice()) -> ok Destroys this object, do not use object again AUTHORS
<> wxErlang 0.98.9 wxChoice(3erl)
All times are GMT -4. The time now is 01:11 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy