String operation in csh shell


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting String operation in csh shell
# 1  
Old 02-09-2017
String operation in csh shell

Hi, to everybody

i have a string which Looks like this
Code:
 FT47;3;1;1;;;1;09.02.2017 21:21:19;2;2

and i would like to change to value on one Position only
e.g. the values on Position 6 should change to 1 nevertheyless which values was there before

AIX 4.3.2.0 and csh

i try alread awk but without success and with sed it also does not works ,
i do not have the r Option with mz sed command

thanks in advance

Last edited by Scrutinizer; 02-09-2017 at 04:44 PM.. Reason: code tags
# 2  
Old 02-09-2017
If I understand you:
Code:
awk '{ $6=1 } 1' FS=";" OFS=";" inputfile > outputfile

This User Gave Thanks to Corona688 For This Post:
# 3  
Old 02-09-2017
Quote:
Originally Posted by Corona688
If I understand you:
Code:
awk '{ $6=1 } 1' FS=";" OFS=";" inputfile > outputfile

I bet it's the second field (position 6 currently with the value of 3)
This User Gave Thanks to vgersh99 For This Post:
# 4  
Old 02-09-2017
sed version:
Code:
sed 's/[^;]*;/1;/6' file


Last edited by Scrutinizer; 02-09-2017 at 05:04 PM..
This User Gave Thanks to Scrutinizer For This Post:
# 5  
Old 02-10-2017
The substitution needs the field to end with the semicolon delimiter.
Not true for the last field.
A simple relief is
Code:
sed '
s/$/;/
s/[^;]*;/1;/6
s/;$//
' file

awk is the better tool to work with csv-style fields.
This User Gave Thanks to MadeInGermany For This Post:
# 6  
Old 02-10-2017
Thanks to everybody for your fast Response on my question ,
the solution from Corona688 work perfect only i have to Change field from 6 to 2 as vgersh99 mention and than it work wonderful as request

Wish all of you great Weekend Smilie
This User Gave Thanks to Nadielosabra For This Post:
# 7  
Old 02-22-2017
Hi

i had a question for the solution Corona668 has posted, BTW it works perfect. what is the reason / function of the red "1" in the code

Code:
 awk '{ $2=5 } 1' FS=";" OFS=";" inputfile > outputfile

Thanks for your help



Moderator's Comments:
Mod Comment Start using code tags, thanks.

Last edited by zaxxon; 02-22-2017 at 08:09 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

String operation in csh AIX 4.3.2.0

Hi to everybody i stuck on a simple thing i had a string and i want cut it , i try already few thing with the cut command but does not the way it should. The script is in csh and running on AIX 4.3.2.0 here are few samples how the string can look like FT71;1;1;1;;;1;31.01.2017... (9 Replies)
Discussion started by: Nadielosabra
9 Replies

2. Shell Programming and Scripting

Pass C shell array to another C shell script(csh) and shell(sh)

Dear Friends, Please help me on this my script name is send.csh In this i have written the statement like this set args = ( city state country price ) I want to pass this array to another c shell called receiver.csh. and i want to use it in this c shell or how to pass to... (2 Replies)
Discussion started by: SA_Palani
2 Replies

3. Shell Programming and Scripting

Complex string operation (awk, sed, other?)

I have a file that contains RewriteRules for 200 countries (2 examples for 1 country below): RewriteRule ^/at(/|/index.html|)$ http://%{HTTP_HOST}/locate/index.html?locale=de_AT #& RewriteRule ^/at_english(/|/index.html|)$ http://%{HTTP_HOST}/locate/index.html?locale=en_AT I have... (5 Replies)
Discussion started by: usshadowop
5 Replies

4. Shell Programming and Scripting

String processing in CSH

Please delete it (0 Replies)
Discussion started by: animesharma
0 Replies

5. Shell Programming and Scripting

String Operation

/home8/mc09ats/UnixCw/file4 this is the path...i have 2 variables filename and filepath...i want filename=file4 filepath=/home8/mc09ats/UnixCw i.e. i think i have to find last occurence of "/" in string and the string after "/" want to take in some variable and string before last "/"... (4 Replies)
Discussion started by: AbhijitIT
4 Replies

6. Shell Programming and Scripting

Help - Search for string, then do string operation on line

Hi, I wish to find all lines that contain a specific search word, and then do few string operations on that line. The idea is to "fix" the file which has been moved from windows to unix. Using unix - Sun Solaris Test input ("t2.sas") statement1 statement2 libname yahoo ... (6 Replies)
Discussion started by: deepaksinbox
6 Replies

7. UNIX for Dummies Questions & Answers

string operation

I am trying to ask for full name in a script, Then echo back to the user with the surname only, omitting the first name. Thanks (2 Replies)
Discussion started by: orjnet
2 Replies

8. Shell Programming and Scripting

string operation

i am new user of unix.i have a question.My script is- export STR_ALFA=`head -2 "${FILE_PATH}"|tail -1|cut -d"," -f1` "${TEST_HOME}"/function/chk_alfa.ksh STR_ALFA now i want to check STR_ALFA: 1)whether is alphabetic 2)whether is numeric 3)whether is alphanumeric... (1 Reply)
Discussion started by: arghya_owen
1 Replies

9. Shell Programming and Scripting

string operation

i am new user of unix.i have a question.My script is- export STR_ALFA=`head -2 "${FILE_PATH}"|tail -1|cut -d"," -f1` "${TEST_HOME}"/function/chk_alfa.ksh STR_ALFA now i want to check STR_ALFA: 1)whether is alphabetic 2)whether is numeric 3)whether is alphanumeric... (1 Reply)
Discussion started by: arghya_owen
1 Replies

10. Shell Programming and Scripting

string operation

Hi all, Here is my situation. I have a text file TXT_FILE like this: john 123456 jack 94589 kelvin 94595 mary 88585 I want to read the first word in each line ( the name ) and assign to a string variable ( EX_LIST ) in my script so that I can use later as this commandfor i in... (6 Replies)
Discussion started by: fongthai
6 Replies
Login or Register to Ask a Question