Hi all,
I have created a script which adding two columns and removing two columns for all files.
Filename: Cust_information_1200_201010.txt
Source Data:
"1","Cust information","123","106001","street","1-203 high street"
"1","Cust information","124","105001","street","1-203 high street"
... (0 Replies)
Here is the contents of an input file.
A,1,2,3,4
10,aaa,bbb,ccc,ddd
11,eee,fff,ggg,hhh
12,iii,jjj,lll,mmm
13,nnn,ooo,ppp
I wanted the output to be
A
10 1 aaa
10 2 bbb
10 3 ccc
10 4 ddd
11 1 eee
11 2 fff
11 3 ggg
11 4 hhh .....
and so on How to do it in ksh... (9 Replies)
Hello everyone,
I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble.
I have many files each having two columns and hundreds of rows.
first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Hi friends
please help me on below,
i have 5 files like below
file1 is
x 10
y 20
z 15
file2 is
x 100
z 245
file3 is
y 78
z 23
file4 is
x 100 (3 Replies)
hi all,
i have a file like thsi
a 1 3;4
b 2 4;7
c 4 5;6
d 4 5;8
now i want 1st, 2nd and in 3rd column i want only 1st column
the output should be like below
a 1 3
b 2 4
c 4 5
d 4 5
I need it in perl; please dont write in Shell scripting (1 Reply)
Hi,
I have a requirement.for eg: i have a text file with pipe symbol as delimiter(|) with 4 columns a,b,c,d. Here a and b are primary key columns..
i want to process that file to find the duplicates and null values are in primary key columns(a,b) . I want to write the unique records in which... (5 Replies)
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
HI All,
I'm embedding SQL query in Script which gives following output:
Assignee Group Total
ABC Group1 17
PQR Group2 5
PQR Group3 6
XYZ Group1 10
XYZ Group3 5
I have saved the above output in a file.
How do i sum up the contents of this output so as to get following output:
... (4 Replies)
Hi,
We have a requirement like, to check the datatypes of columns against database.
After loading the sample data in to one of the database, need to compare the datatypes of the columns are matching with the provided files.
Is there a way that we can achieve through shell scripting.
We... (7 Replies)
Discussion started by: Samah
7 Replies
LEARN ABOUT OSX
sdp
SDP(1) BSD General Commands Manual SDP(1)NAME
sdp -- scripting definition (sdef) processor
SYNOPSIS
sdp -f {ahst} [-o directory | file | -] [options...] [file]
DESCRIPTION
sdp transforms a scripting definition (``sdef'') file, or standard input if none is specified, into a variety of other formats for use with a
scriptable application. The options are as follows:
-f format
Specify the output format. The format may be one or more of the following. Use these when you want to create a scriptable applica-
tion:
a Rez(1) input describing an 'aete' resource.
s Cocoa Scripting ``.scriptSuite'' file.
t Cocoa Scripting ``.scriptTerminology'' file.
These formats are only necessary when creating a scriptable application that will run on Mac OS X 10.4 (Tiger) or earlier; as of 10.5
(Leopard), an application may use only an sdef.
Use these when you want to control a scriptable application:
h Scripting Bridge Objective-C header.
You do not need to create a corresponding implementation file; Scripting Bridge will create the class implementations at runtime.
-i includefile
Include the type and class definitions from the specified sdef. It may be repeated to specify multiple files. This option is obso-
lete; you should use an XInclude element in the sdef instead.
-o directory | file | -
Specify where to write the output. There are three styles:
directory Write the output to automatically named files in that directory. Depending on the input and formats, sdp may generate
several files.
file Write all the output to that file.
- Write all the output to standard output.
The default is '-o .'; i.e., generate files in the current directory. Because Cocoa Scripting requires each suite to be in a separate
file, using -o file with -f s or -f t is usually not a good idea.
Some output formats have additional options relevant only to that format. For scriptSuite and scriptTerminology files (-f s and -f t):
-V version
Specify the minimum system version to be compatible with, for example, ``-V -10.4''. The default is to assume the current system ver-
sion. Specifying anything before 10.3 will use NSString for 'file' type attributes, and will warn about non-object direct parameters.
For Scripting Bridge Objective-C header files (-f h):
--basename name, -N name
Specify the ``base'' name. This name becomes the base name of the generated header and the prefix attached to all the generated
classes. For example, saying --basename iTunes would result in a header file ``iTunes.h'' defining a iTunesApplication class.
--hidden, -A
Output definitions even for items the scripting definition marks as hidden. All such definitions will be flagged as deprecated, since
hidden items are usually hidden for a reason.
SEE ALSO sdef(5)BUGS
sdp's error reporting leaves much to be desired. It does not provide line numbers for errors, though it will describe the element. It will
not warn you of certain types of mistakes, such as using two different names with the same code (or vice versa), and will return a zero sta-
tus even for erroneous input.
Mac OS X July 12, 2007 Mac OS X