trim spaces in unix for variable


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting trim spaces in unix for variable
# 1  
Old 02-09-2012
trim spaces in unix for variable

HI Guys

I have written a script using awk to split a file based on some identifier and renaming the file based on two values from specific length. ts a fixed width file.

When I am trying to fetch the values
Code:
a = substr($0,11,10)
b = substr($0,21,5);

i am getting spaces in a and b values .
I have to form a file like a_b.txt but the file is forming as "a _ b .txt"

Please help guys.

Last edited by Franklin52; 02-09-2012 at 05:29 AM.. Reason: Please use code tags for code and data samples, thank you
# 2  
Old 02-09-2012
To remove all the spaces in $a and $b
Code:
 
a=${a// /}
b=${b// /}

# 3  
Old 02-09-2012
Hi when i tried using the way you provided
Code:
a = substr($0,11,10)
a1= ${a// /}

i got this error
Code:
The error context is
               a= >>> ${ <<<
awk: 0602-502 The statement cannot be correctly parsed.


Last edited by Franklin52; 02-09-2012 at 05:29 AM.. Reason: Please use code tags for code and data samples, thank you
# 4  
Old 02-09-2012
To trim the spaces in your awk program from the a variable:

left spaces:
Code:
gsub(/^[ \t]+/, "", a)

right spaces:
Code:
gsub(/[ \t]+$/, "", a)

# 5  
Old 02-09-2012
is it inside the awk ?

if it is inside the awk, use the franklin suggestion.
# 6  
Old 02-09-2012
my data is coming as
Code:
INDIAINDIABACD      11    
INDIAINDIABACD      12


and i split the data into multiple files based in INDIAINDIA and file name will be BACD_11.txt and BACD_12.txt but in this case it is forming as
Code:
"BACD      12   .txt" and "BACD      11   .txt"

a = substr($0,11,10)
a2=gsub(/[ \t]+$/, "", a)
b = substr($0,21,5)
b2=gsub(/[ \t]+$/, "", b)
fn = a2 "_Src" b2 ".txt"

using gusb i am not able to trim also it is returning blank to a2 and b2 respectively.

This whole code is inside awk

---------- Post updated at 07:01 AM ---------- Previous update was at 05:19 AM ----------

Thanks guys I got that solved.

Last edited by Franklin52; 02-09-2012 at 08:03 AM.. Reason: Code tags
# 7  
Old 02-09-2012
Try losing the $ signs in the gsub statements.
You cannot assign gsub to a variable, it only returns the exit status
What is a sample input line?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Trim trailing spaces from file

I have a file like this. hari,corporationbank,2234356,syndicate ravi,indian bank,4567900000000,indianbank,accese raju,statebank of hyderabad,565866666666666,pause Here each record has different record length and there are blank spaces... (8 Replies)
Discussion started by: kshari8888
8 Replies

2. Shell Programming and Scripting

How to get a numeric value from Oracle to UNIX variable without spaces?

Hi, I am using the below code to get a numeric value from oracle to unix variable: BD_RC_CNT=`sqlplus -s ${WMD_DM_CONNECT} <<EOF set heading off set pagesize 0 Select count(*) from wmd_bad_data where proc_id = ${PROC_ID} and file_id = ${FILE_ID} and file_dt =... (7 Replies)
Discussion started by: Arun Mishra
7 Replies

3. Shell Programming and Scripting

Trim spaces

All, i am comparing the output of one command to a numberic if ] but my problem is the output of follwoing is but but has some leading columns. I don't have any problme in LINUX and HP-UX. But only in AIX i am getting the leading spaces. I have developed my script on LINUX but when... (4 Replies)
Discussion started by: rcc50886
4 Replies

4. Shell Programming and Scripting

trim spaces and replacing value

Hi, I have a file origFile.txt with values: origFile.txt .00~ 145416.02~ xyz~ ram kishor ~? ~ ~783.9 .35~ 765.76~ anh reid~ kelly woodburg ~nancy ~ ~? Now each row in the file has value for 7 columns with "~" as delimiter. The requirement was i)I need to erase the blank spaces between... (2 Replies)
Discussion started by: badrimohanty
2 Replies

5. Shell Programming and Scripting

trim spaces in a file

Hi, I'm new to shell programming. Need some help in the following requirement: I have a file origFile.txt with values: origFile.txt .00~ 145416.02~ xyz~ ram kishor .35~ 765.76~ anh reid~ kishna kerry Now each row in the file has value for 4 columns with "~" as... (7 Replies)
Discussion started by: badrimohanty
7 Replies

6. UNIX for Advanced & Expert Users

TRIM spaces in shell

am get a value like ' 15' in a variable what is the easiest method i can follow to strip 15 out (3 Replies)
Discussion started by: anumkoshy
3 Replies

7. Shell Programming and Scripting

To Trim spaces at the end of line

Hi Friends, Can any one help with this issue: How to trim spaces for each line at the end, Like I have a file in this format. EMP1 SMITH 46373 5 STREET HOWARD 74636 EMP2 JONES 5454 { these are spaces ........} EMP3 SMITH 46373 5 STREET HOWARD 74636 EMP4 JON 2554 { these are... (1 Reply)
Discussion started by: sbasetty
1 Replies

8. Shell Programming and Scripting

delete spaces in the variable in unix script?

Hi All, I need your help.I want to know how to delete the spaces in a variable in unix scripting.Please give solution to this probelm... thanks ! :confused: (14 Replies)
Discussion started by: MARY76
14 Replies

9. Shell Programming and Scripting

Trim trailing spaces from each line in a file

Hello folks, Is there a simple way to trim trailing spaces from each line a file. Please let me know. Regards, Tipsy. (5 Replies)
Discussion started by: tipsy
5 Replies

10. Shell Programming and Scripting

Trim white spaces using awk

Hi, I have a CSV file with footer information as below. The third value is the number of records in the file. Sometimes it contains both leading and trailing white spaces which i want to trim using awk. C,FOOTER , 00000642 C,FOOTER , 00000707 C, FOOTER,... (2 Replies)
Discussion started by: mona
2 Replies
Login or Register to Ask a Question