File conversion

gehlnar · #1 (**permalink**) 04-15-2009

Hi Everyone,

Can someone plesae advise on converting the inputted file into required output? First field is L then amount will - symbol.
Sample input file

Code:

B|T|SASOFTB00016|20090330|20090330|15000|9089001
B|T|SABH00000012|20090330|20090330|7000|9089003
L|T|SABIOTN00029|20090330|20090330|250000|9089004
L|T|SABRE0000012|20090330|20090330|3000|9089005
B|T|SACRSNT00011|20090330|20090330|13000|9089006

Below is Output file and it have some hardcoded stuff at begining and in between.

Code:

851~123456~20090330~20090330~FI~15000~9089001~SASOFTB00016
851~123456~20090330~20090330~FI~7000~9089003~SABH00000012
851~123456~20090330~20090330~FI~-250000~9089004~SABIOTN00029
851~123456~20090330~20090330~FI~-3000~9089005~SABRE0000012
851~123456~20090330~20090330~FI~13000~9089006~SACRSNT00011

I have tried converting the file with awk but got below error.

Code:

awk -F "|" 'BEGIN {OFS="~"} {print $1 $2} '  inputfile
awk: syntax error near line 1
awk: bailing out near line 1

Can someone please advise?

Cheers,
gehlnar

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
File Conversion	sridhar_423	Shell Programming and Scripting	2	03-16-2009 04:47 PM
File conversion to ascii	mora	UNIX for Advanced & Expert Users	4	03-31-2008 01:29 PM
Problem with File Conversion	Balkrishna	Shell Programming and Scripting	2	09-05-2006 04:11 AM
COnversion utility xhtml file to Postscript file	dattatray.b	SUN Solaris	0	08-25-2005 07:36 AM
file conversion	hipo	UNIX for Dummies Questions & Answers	1	07-24-2001 10:24 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by