Sponsored Content
Full Discussion: Reformat Data (Perl)
Top Forums Shell Programming and Scripting Reformat Data (Perl) Post 302305246 by flood on Wednesday 8th of April 2009 10:31:18 AM
Old 04-08-2009
Reformat Data (Perl)

I am new to Perl. I need to reformat a data file as the last part of a script I am working on. I am stuck on this.

Here is the current format:

CUSTOMER Filename 09/04/07-08:49
CUSTOMER Filename 09/04/07-08:52
CUSTOMER Filename 09/04/07-08:52
CUSTOMER2 Filename 09/04/07-08:49
CUSTOMER2 Filename 09/04/07-08:52
CUSTOMER2 Filename 09/04/07-08:52

I need it to look like this:

CUSTOMER
Filename 09/04/07-08:49
Filename 09/04/07-08:52
Filename 09/04/07-08:52

CUSTOMER2
Filename 09/04/07-08:49
Filename 09/04/07-08:52
Filename 09/04/07-08:52

Any ideas? I've thought about looping thru the list and storing each list item as a variable and then printing the variables, but I haven't worked out how exactly to do it.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help reformat data with awk

I am trying to write an awk program to reformat a data table and convert the date to julian time. I have all the individual steps working, but I am having some issues joing them into one program. Can anyone help me out? Here is my code so far: # This is an awk program to convert the dates from... (4 Replies)
Discussion started by: climbak
4 Replies

2. Shell Programming and Scripting

reformat data with a shell script

Can anyone help me with a shell script that can do the following: I have a data in fasta format (first line is the header, followed by a sequence of characters). >ALLLY GGCCCCTCGAGCCTCGAACCGGAACCTCCAAATCCGAGACGCTCTGCTTATGAGGACCTC GAAATATGCCGGCCAGTGAAAAAATCTTGTGGCTTTGAGGGCTTTTGGTTGGCCAGGGGC... (5 Replies)
Discussion started by: manishabh
5 Replies

3. Shell Programming and Scripting

Reformat the data of a file.

I have a file which have data like A.txt a 1Jan I am in a1. 1Jan I was born. 2Jan I am here. 3Jan I am in a3. b 1Jan I am in b1. c 2Jan I am in c2. d 2Jan I am in d2. 5jan I am in d5. date in the file might be vary evertime. (9 Replies)
Discussion started by: samkhu
9 Replies

4. Shell Programming and Scripting

Split, Search and Reformat by Data Group

Hi, I am writing just to share my appreciation for help I have received from this site in the past. In a previous post Split File by Data Group I received a lot of help with a troublesome awk script to reformat some complicated data blocks. What I learned really came in hand recently when I... (1 Reply)
Discussion started by: mkastin
1 Replies

5. Shell Programming and Scripting

Help with reformat data content

input file: hsa-miR-4726-5p Score hsa-miR-483-5p Score hsa-miR-125b-2* Score hsa-miR-4492 hsa-miR-4508 hsa-miR-4486 Score Desired output file: hsa-miR-4726-5p Score hsa-miR-483-5p Score hsa-miR-125b-2* Score hsa-miR-4492 hsa-miR-4508 hsa-miR-4486 Score ... (6 Replies)
Discussion started by: perl_beginner
6 Replies

6. Shell Programming and Scripting

Help with reformat input data

Input file: 58227131 50087390 57339526 40578034 65348841 55614853 64363217 44178559 Desired output file: 58227131 50087390 57339526 40578034 65348841 55614853 64363217 44178559 Command that I try: (4 Replies)
Discussion started by: perl_beginner
4 Replies

7. Shell Programming and Scripting

Reformat MLS Data - Use AWK?

I am helping my wife set up a real estate site and I am starting to integrate MLS listings. We are using a HostGator level 5 VPS running CentOS and have full root and SSH access to the VPS. Thus far I have automated the daily FTP download of listings from our MLS server using a little sh script.... (4 Replies)
Discussion started by: Chicago_Realtor
4 Replies

8. Shell Programming and Scripting

Data reformat and rearrangement problem asking

Input file: dependent general_process dependent general_process regulation general_process - - template component food component binding data_rearrangement binding data_rearrangement specific_activity data_rearrangement - ... (7 Replies)
Discussion started by: cpp_beginner
7 Replies

9. Shell Programming and Scripting

Help with reformat data structure

Input file: bv|111259484|pir||T49736_real_data bv|159484|pir||T9736_data_figure bv|113584|prf|T4736|truth bv|113584|pir||T4736_truth Desired output: bv|111259484|pir|T49736|real_data bv|159484|pir|T9736|data_figure bv|113584|prf|T4736|truth bv|113584|pir|T4736|truth Once the... (8 Replies)
Discussion started by: perl_beginner
8 Replies

10. Shell Programming and Scripting

Help with reformat data set

Input file 4CL1 O24145 CoA1 4CL1 P31684 CoA1 4CL1 Q54P77 CoA_1 73 O36421 Unknown 4CL3 Q9S777 coumarate 4CL3 Q54P79 coumarate 4CL3 QP7932 coumarate Desired output result 4CL1 O24145#P31684 CoA1 4CL1 Q54P77 CoA_1 73 O36421 Unknown 4CL3 Q9S777#Q54P79#QP7932 coumarate I... (5 Replies)
Discussion started by: perl_beginner
5 Replies
filename(3erl)						     Erlang Module Definition						    filename(3erl)

NAME
filename - Filename Manipulation Functions DESCRIPTION
The module filename provides a number of useful functions for analyzing and manipulating file names. These functions are designed so that the Erlang code can work on many different platforms with different formats for file names. With file name is meant all strings that can be used to denote a file. They can be short relative names like foo.erl , very long absolute name which include a drive designator and direc- tory names like D:usr/localinerl/lib oolsfoo.erl , or any variations in between. In Windows, all functions return file names with forward slashes only, even if the arguments contain back slashes. Use join/1 to normalize a file name by removing redundant directory separators. The module supports raw file names in the way that if a binary is present, or the file name cannot be interpreted according to the return value of file:native_name_encoding/0 , a raw file name will also be returned. For example filename:join/1 provided with a path component being a binary (and also not being possible to interpret under the current native file name encoding) will result in a raw file name being returned (the join operation will have been performed of course). For more information about raw file names, see the file module. DATA TYPES
name() = string() | atom() | DeepList | RawFilename DeepList = [char() | atom() | DeepList] RawFilename = binary() If VM is in unicode filename mode, string() and char() are allowed to be > 255. RawFilename is a filename not subject to Unicode translation, meaning that it can contain characters not conforming to the Unicode encoding expected from the filesystem (i.e. non-UTF-8 characters although the VM is started in Unicode filename mode). EXPORTS
absname(Filename) -> string() Types Filename = name() Converts a relative Filename and returns an absolute name. No attempt is made to create the shortest absolute name, because this can give incorrect results on file systems which allow links. Unix examples: 1> pwd(). "/usr/local" 2> filename:absname("foo"). "/usr/local/foo" 3> filename:absname("../x"). "/usr/local/../x" 4> filename:absname("/"). "/" Windows examples: 1> pwd(). "D:/usr/local" 2> filename:absname("foo"). "D:/usr/local/foo" 3> filename:absname("../x"). "D:/usr/local/../x" 4> filename:absname("/"). "D:/" absname(Filename, Dir) -> string() Types Filename = name() Dir = string() This function works like absname/1 , except that the directory to which the file name should be made relative is given explicitly in the Dir argument. absname_join(Dir, Filename) -> string() Types Dir = string() Filename = name() Joins an absolute directory with a relative filename. Similar to join/2 , but on platforms with tight restrictions on raw filename length and no support for symbolic links (read: VxWorks), leading parent directory components in Filename are matched against trail- ing directory components in Dir so they can be removed from the result - minimizing its length. basename(Filename) -> string() Types Filename = name() Returns the last component of Filename , or Filename itself if it does not contain any directory separators. 5> filename:basename("foo"). "foo" 6> filename:basename("/usr/foo"). "foo" 7> filename:basename("/"). [] basename(Filename, Ext) -> string() Types Filename = Ext = name() Returns the last component of Filename with the extension Ext stripped. This function should be used to remove a specific extension which might, or might not, be there. Use rootname(basename(Filename)) to remove an extension that exists, but you are not sure which one it is. 8> filename:basename("~/src/kalle.erl", ".erl"). "kalle" 9> filename:basename("~/src/kalle.beam", ".erl"). "kalle.beam" 10> filename:basename("~/src/kalle.old.erl", ".erl"). "kalle.old" 11> filename:rootname(filename:basename("~/src/kalle.erl")). "kalle" 12> filename:rootname(filename:basename("~/src/kalle.beam")). "kalle" dirname(Filename) -> string() Types Filename = name() Returns the directory part of Filename . 13> filename:dirname("/usr/src/kalle.erl"). "/usr/src" 14> filename:dirname("kalle.erl"). "." 5> filename:dirname("\usr\src/kalle.erl"). % Windows "/usr/src" extension(Filename) -> string() Types Filename = name() Returns the file extension of Filename , including the period. Returns an empty string if there is no extension. 15> filename:extension("foo.erl"). ".erl" 16> filename:extension("beam.src/kalle"). [] flatten(Filename) -> string() Types Filename = name() Converts a possibly deep list filename consisting of characters and atoms into the corresponding flat string filename. join(Components) -> string() Types Components = [string()] Joins a list of file name Components with directory separators. If one of the elements of Components includes an absolute path, for example "/xxx" , the preceding elements, if any, are removed from the result. The result is "normalized": * Redundant directory separators are removed. * In Windows, all directory separators are forward slashes and the drive letter is in lower case. 17> filename:join(["/usr", "local", "bin"]). "/usr/local/bin" 18> filename:join(["a/b///c/"]). "a/b/c" 6> filename:join(["B:a\b///c/"]). % Windows "b:a/b/c" join(Name1, Name2) -> string() Types Name1 = Name2 = string() Joins two file name components with directory separators. Equivalent to join([Name1, Name2]) . nativename(Path) -> string() Types Path = string() Converts Path to a form accepted by the command shell and native applications on the current platform. On Windows, forward slashes is converted to backward slashes. On all platforms, the name is normalized as done by join/1 . 19> filename:nativename("/usr/local/bin/"). % Unix "/usr/local/bin" 7> filename:nativename("/usr/local/bin/"). % Windows "\usr\local\bin" pathtype(Path) -> absolute | relative | volumerelative Returns the type of path, one of absolute , relative , or volumerelative . absolute : The path name refers to a specific file on a specific volume. Unix example: /usr/local/bin Windows example: D:/usr/local/bin relative : The path name is relative to the current working directory on the current volume. Example: foo/bar, ../src volumerelative : The path name is relative to the current working directory on a specified volume, or it is a specific file on the current work- ing volume. Windows example: D:bar.erl, /bar/foo.erl rootname(Filename) -> string() rootname(Filename, Ext) -> string() Types Filename = Ext = name() Remove a filename extension. rootname/2 works as rootname/1 , except that the extension is removed only if it is Ext . 20> filename:rootname("/beam.src/kalle"). /beam.src/kalle" 21> filename:rootname("/beam.src/foo.erl"). "/beam.src/foo" 22> filename:rootname("/beam.src/foo.erl", ".erl"). "/beam.src/foo" 23> filename:rootname("/beam.src/foo.beam", ".erl"). "/beam.src/foo.beam" split(Filename) -> Components Types Filename = name() Components = [string()] Returns a list whose elements are the path components of Filename . 24> filename:split("/usr/local/bin"). ["/","usr","local","bin"] 25> filename:split("foo/bar"). ["foo","bar"] 26> filename:split("a:\msdev\include"). ["a:/","msdev","include"] find_src(Beam) -> {SourceFile, Options} | {error,{ErrorReason,Module}} find_src(Beam, Rules) -> {SourceFile, Options} | {error,{ErrorReason,Module}} Types Beam = Module | Filename Module = atom() Filename = string() | atom() SourceFile = string() Options = [Opt] Opt = {i, string()} | {outdir, string()} | {d, atom()} ErrorReason = non_existing | preloaded | interpreted Finds the source filename and compiler options for a module. The result can be fed to compile:file/2 in order to compile the file again. The Beam argument, which can be a string or an atom, specifies either the module name or the path to the source code, with or with- out the ".erl" extension. In either case, the module must be known by the code server, i.e. code:which(Module) must succeed. Rules describes how the source directory can be found, when the object code directory is known. It is a list of tuples {BinSuffix, SourceSuffix} and is interpreted as follows: If the end of the directory name where the object is located matches BinSuffix , then the source code directory has the same name, but with BinSuffix replaced by SourceSuffix . Rules defaults to: [{"", ""}, {"ebin", "src"}, {"ebin", "esrc"}] If the source file is found in the resulting directory, then the function returns that location together with Options . Otherwise, the next rule is tried, and so on. The function returns {SourceFile, Options} if it succeeds. SourceFile is the absolute path to the source file without the ".erl" extension. Options include the options which are necessary to recompile the file with compile:file/2 , but excludes options such as report or verbose which do not change the way code is generated. The paths in the {outdir, Path} and {i, Path} options are guaran- teed to be absolute. Ericsson AB stdlib 1.17.3 filename(3erl)
All times are GMT -4. The time now is 12:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy