OraFAQ Forum: Unix » Fields separated by Pipe needs to be Reformatted

Home » Infrastructure » Unix » Fields separated by Pipe needs to be Reformatted (AIX,KSH)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Fields separated by Pipe needs to be Reformatted [message #638300]

Tue, 09 June 2015 06:09

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!

Report message to a moderator

Re: Fields separated by Pipe needs to be Reformatted [message #638304 is a reply to message #638300]

Tue, 09 June 2015 07:16

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 20 05:06:17 CDT 2025