There is also the sed / regex route:
==> Note that the file is still in DOS format, which means there is a CR character before the LF character at the end.
So first you would need to convert it to UNIX format:
By using a single dot at the end to match the CR character, it can be made to work with a DOS format file:
or
But the proper way is to convert first.
Last edited by Scrutinizer; 08-27-2014 at 03:19 AM..
This User Gave Thanks to Scrutinizer For This Post:
Hi ,
I have a file :
CSCH74000.00
CSCH74000.00
CSCH74100.00
CSCH74000.00
CSCH74100.00
CSCH74000.00
CSCH74000.00
CSCH74100.00
CSCH74100.00
CSCH74100.00
I have to put a delimiter( say comma) in between after 6th character:
CSCH74,000.00
CSCH74,000.00
CSCH74,100.00 (2 Replies)
I am trying to parse a Fixed width file with data as below. I am trying to assign column values from each record to variables. When I parse the data, the spaces in all coumns are dropped. I would like to retain the spaces as part of the dat stored in the variables. Any help is appreciated.
I... (4 Replies)
Hi,
I have a fixed width file with some records as given below:
" 1000Nalsdjflj243324jljlj"
"-0300Njfowjljl309933fsf"
" 0010Njsfsjklj342344fsl"
I want to sum-up first field values(i.e from 2nd character to 6th character)of each record.
so for the above file i want to add (1000 - 300+... (2 Replies)
Hi All,
I have created a script which generates FIXED-WIDTH file by executing Oracle query.
SELECT RPAD(NVL(col1,CHR(9)),20)||NVL(col2,CHR(9))||NVL(col3,CHR(9) FROM XYZ
It generates the data file with proper alignment. But if same file i transfer to windows server or Mainframe... (5 Replies)
I am trying to determine what would be a fast and simple way to manipulate data that comes in a fixed width format. This data has 6 segments within a record. Each record needs to written out with a header and the 6 segments. Based on the value in column #6 the fields will be defined accordingly.... (4 Replies)
Hi Guys
I am checking the treads to get the answer but i am not able to get the answer for my question.
I have two files. First file is a pattern file and the second file is the file i want to search in it. Output will be the lines from file2.
File1:
P2797f12af 44751228... (10 Replies)
I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers.
awk '{print length;exit}' <File_name>
The above code gives me length 50.
wc -L <File_name>
The above code gives me length 53.
Please clarify on... (2 Replies)
I have a fixed with file with header & trailer length having the same length of the detail record file.
The details record length of this file is 24, for Header and Trailer the records will be padded with spaces to match the record length of the file
Currently I am adding 3 spaces in header... (14 Replies)
Discussion started by: ginrkf
14 Replies
LEARN ABOUT DEBIAN
jifty::manual::tutorialrest
Jifty::Manual::TutorialRest(3pm) User Contributed Perl Documentation Jifty::Manual::TutorialRest(3pm)NAME
Jifty::Manual::TutorialRest - Web Services
DESCRIPTION
This builds on Jifty::Manual::Tutorial, so make sure you have a running jifty that roughly resembles the step-by-step from there.
SETUP
You must add this to your site_config.yml
framework:
Plugins:
- REST: {}
See Jifty::Plugin::REST.
The commands assume that you have LWP installed with the GET alias. If not, you'll need to use the longhand lwp-request -m GET, or curl,
or your browser.
help
Make sure it is working:
$ GET http://localhost:8888/=/help
Accessing resources:
...
You should see some text describing the services, not html (that's longhand for 404.) Check the config and restart the server.
GET
Just list the models.
$ GET http://localhost:8888/=/model.yml
---
- MyWeblog.Model.Post
List the Post schema.
$ GET http://localhost:8888/=/model/Post.yml
---
body:
label: Content
name: body
readable: 1
sort_order: 1
type: text
writable: 1
id:
mandatory: 1
name: id
readable: 1
type: serial
writable: 0
title:
default: Untitled post
label: Title
name: title
readable: 1
sort_order: 0
type: text
writable: 1
You did make some posts, right?
$ GET http://localhost:8888/=/model/Post/id.yml
---
- 1
- 2
Dump the data:
$ GET http://localhost:8888/=/model/Post/id/1.yml
---
body: 'This is my post, the content of which is this, which is mine.'
id: 1
title: my first post
$ GET http://localhost:8888/=/model/Post/id/2.yml
---
body: "Content of another post. Got to go, the cat's on fire."
id: 2
title: post deux
POST
TODO not working
Actually, it looks like it is not supposed to work this way. Why not?
$ echo '---
body: "A post via web services"
id: 3
title: "posting from the command-line"
' | lwp-request -m POST http://localhost:8888/=/model/Post.yml
POST http://localhost:8888/=/model/Post/id/3.yml --> 404 Not Found
PUT
TODO not working
$ echo '---
title: "posting from the cli"
' | lwp-request -m PUT http://localhost:8888/=/model/Post/3.yml
500 Can't read entity body: Connection reset by peer
DELETE
$ lwp-request -m DELETE http://localhost:8888/=/model/Post/id/3.yml
---
content: {}
error: ~
field_errors: {}
field_warnings: {}
message: Deleted
success: 1
perl v5.14.2 2010-09-25 Jifty::Manual::TutorialRest(3pm)