Sponsored Content
Full Discussion: File conversion
Top Forums Shell Programming and Scripting File conversion Post 302307481 by gehlnar on Wednesday 15th of April 2009 01:20:27 PM
Old 04-15-2009
File conversion

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

Last edited by Yogesh Sawant; 04-16-2009 at 04:40 AM.. Reason: added code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

file conversion

How can I suppress the 0a (line feed) in a text file (HP UX) (1 Reply)
Discussion started by: hipo
1 Replies

2. Solaris

COnversion utility xhtml file to Postscript file

Hi, Can any suggest me some utility to convert xhtml file to postscript file format? Also tell me from where to down load such utility.. With Regards, Dattatray (0 Replies)
Discussion started by: dattatray.b
0 Replies

3. Programming

C File Permission Conversion

I'm new to C, and I'm attempting to write a script similar to the stat command for practice. I only had a problem converting st_mode to an octal permission format. I remembered I had littleutils installed which contains a script called filemode, so I checked the source and it yielded something like... (4 Replies)
Discussion started by: petebear
4 Replies

4. Shell Programming and Scripting

File Conversion

Hi all, How can i convert a file from one encoding to another? Lets say I have a file which is of utf-8 encoding and I want to convert it to cp875. Can anyone tell me how can I achieve this in shell script? Thanks, Sridhar (2 Replies)
Discussion started by: sridhar_423
2 Replies

5. Shell Programming and Scripting

shell or perl script needed for ldif file to text file conversion

This is the ldf file dn: sdcsmsisdn=1000000049,sdcsDatabase=subscriberCache,dc=example,dc=com objectClass: sdcsSubscriber objectClass: top postalCode: 29600 sdcsServiceLevel: 10 sdcsCustomerType: 14 givenName: Adelia sdcsBlackListAll: FALSE sdcsOwnerType: T-Mobile sn: Actionteam... (1 Reply)
Discussion started by: LinuxFriend
1 Replies

6. Shell Programming and Scripting

Conversion of below Tabs Tex file into CSV format file : shell script needed

Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies

7. Shell Programming and Scripting

Conversion of spaces Text file into CSV format file

Input file (each line is separaed by spaces )given below: Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- -----... (18 Replies)
Discussion started by: sreenath1037
18 Replies

8. Shell Programming and Scripting

file conversion

Hi, I have an excel file in unix and I want a script which changes the excel file to .csv file i.e (comma separated value file). Would be thankful to you if some one helps me with this. Thanks in advance. (3 Replies)
Discussion started by: karthikkasarla
3 Replies

9. AIX

File enconding and conversion

Hi am not a specialist about file encoding. On an AIX 5.2.0.0, I need to check files encoding and convert somes of them to UTF-8. I've used the following command and i think it said to me that all files are encoded using ISO8859-1 %locale charmap ISO8859-1 I've also used iconv command... (2 Replies)
Discussion started by: Fundix
2 Replies

10. Linux

File conversion and removing special characters from a file in Linux

I have a .CSV file when I check for the special characters in the file using the command cat -vet filename.csv, i get very lengthy lines with "^@", "^I^@" and "^@^M" characters in between each alphabet in all of the records. Using the code below file filename.csv I get the output as I have a... (2 Replies)
Discussion started by: dhruuv369
2 Replies
DwtScrollBarSetSlider(3Dwt)											       DwtScrollBarSetSlider(3Dwt)

Name
       DwtScrollBarSetSlider - Sets or changes the current size/position parameters of the slider in the scroll bar widget.

Syntax
       void DwtScrollBarSetSlider(widget, value, shown, inc,
				  page_inc, notify)
	    Widget widget;
	    int value;
	    int shown;
	    int inc, page_inc;
	    Boolean notify;

Arguments
       widget	 Specifies the scroll bar widget ID.

       value	 Specifies the scroll bar's top thumb (slider) position between DwtNminValue and DwtNmaxValue.	The attribute name associated with
		 this argument is DwtNvalue.

       shown	 Specifies the size of the slider as a value between zero and the absolute value of DwtNmaxValue minus DwtNminValue.  The size	of
		 the  slider  varies,  depending  on how much of the slider scroll area it represents.	This argument sets the DwtNshown attribute
		 associated with DwtScrollBarCreate.

       inc	 Specifies the amount of button increment and decrement.  If this argument is nonzero, the scroll bar widget automatically adjusts
		 the  slider when an increment or decrement action occurs.  This argument sets the DwtNinc attribute associated with DwtScrollBar-
		 Create.

       page_inc  Specifies the amount of page increment and decrement.	If this argument is nonzero, the scroll bar widget  automatically  adjusts
		 the slider when an increment or decrement action occurs.  This argument sets the DwtNpageInc attribute associated with DwtScroll-
		 BarCreate.

       notify	 Specifies a boolean value that, when True, indicates a change in the scroll bar value and that the scroll  bar  widget  automati-
		 cally	activates the DwtNvalueChangedCallback with the recent change.	If False, no change in the scroll bar's value has occurred
		 and DwtNvalueChangedCallback is not activated.

Description
       The DwtScrollBarSetSlider function sets or changes the currently displayed scroll bar widget slider for the application.  The scroll region
       is overlaid with a slider bar that is adjusted in size and position using the main scroll bar or set slider function attributes.  The step-
       ping arrows and the slider are the scroll activator objects providing the user interface syntax ``feel.''

See Also
       DwtScrollBarGetSlider(3Dwt)
       Guide to the XUI Toolkit: C Language Binding
       Guide to the XUI Toolkit Intrinsics: C Language Binding

														       DwtScrollBarSetSlider(3Dwt)
All times are GMT -4. The time now is 10:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy