Home » Infrastructure » Unix » Fields separated by Pipe needs to be Reformatted (AIX,KSH)
Fields separated by Pipe needs to be Reformatted [message #638300] Tue, 09 June 2015 06:09 Go to next message
Asfakul
Messages: 43
Registered: July 2014
Member
Hi All,

Hope all is well. I have a little problem to share.

I have a file which contains lines formatetd like JOHN|DOE|2015-06-06
MAD|MAX|2014-01-01

I want to reformat these lines like JOHN,DOE,06/06/2015
MAD,MAX,01/01/2014

I can do this using multiple steps , is it possbile to do in one go? Like using regular expression

Thanks for help!

Re: Fields separated by Pipe needs to be Reformatted [message #638304 is a reply to message #638300] Tue, 09 June 2015 07:16 Go to previous message
Michel Cadot
Messages: 65256
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This question bears no real connection with Oracle database.
Please find a more appropriate forum.
The topic is locked. /forum/fa/448/0/
If I'm wrong, please, PM me (or report this message to a moderator, explain why you think it should be unlocked and it might be done).

Hint: use "tr".

[Updated on: Tue, 09 June 2015 07:17]

Report message to a moderator

Previous Topic: /u01 file system size filling up
Next Topic: asvc_t, wsvc_t values from iostat command output
Goto Forum:
  


Current Time: Sun Dec 17 18:46:02 CST 2017

Total time taken to generate the page: 0.07922 seconds