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
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
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
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
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
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
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
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
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
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
LEARN ABOUT LINUX
wxchoice
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)