|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Remove the leading and trailing date from a CSV file
Post 303000452 by rbatte1 on Wednesday 12th of July 2017 12:22:40 PM
07-12-2017
Moderator
Hello shivamayam,
Could I, first of all, encourage you to press the
Thanks button for rdrtx1's very useful post.
Getting to your issue, what have you got to work it in to? There must be something else that you are running that you want to use it with. What have you tried so far?
It would be good to know your OS version and your preferred tools (e.g. ksh, bash, perl etc.) so we can help you fit it in a way that you can support in future.
Kind regards,
Robin
Could I, first of all, encourage you to press the
Thanks button for rdrtx1's very useful post.Getting to your issue, what have you got to work it in to? There must be something else that you are running that you want to use it with. What have you tried so far?
It would be good to know your OS version and your preferred tools (e.g. ksh, bash, perl etc.) so we can help you fit it in a way that you can support in future.
Kind regards,
Robin
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
how to i remove leading and trailing spaces from a line? the spaces can be behind or in front of any field or line
example of a line in the input data:
Amy Reds , 100 , /bin/sh
how to i get it to be: Amy Read,100,/bin/sh
i saw something on this on the Man pages for AWK... (7 Replies)
Discussion started by: sleepster
7 Replies
2. UNIX for Dummies Questions & Answers
I am having xml document as below.
<transactionid>
00
</transactionid>
<tracknumber>
0
</tracknumber>
<key>
N/A
</key>
But the data contains leading and trailing spaces between the tags. Please let me know how can i remove these leading and trailing spaces between the tags.... (2 Replies)
Discussion started by: jhmr7
2 Replies
3. Shell Programming and Scripting
Dear All,
can you please advice how do i remove trailing and leading spaces from a pipe-delimited file using "tr" command
the below cmd, i tried removed all spaces
tr -d ' '<s1.txt>s2.txt1
Many thx
Suresh (5 Replies)
Discussion started by: sureshg_sampat
5 Replies
4. Shell Programming and Scripting
Hi All,
I have a file with the following contents with multiple lines
172445957| 000005911|8| 400 Peninsula Ave.#1551 | And,K |935172445957|000005911
607573888 |000098536 | 2|Ane, B |J |Ane |1868 |19861206|20090106|20071001
I want to trim the "leading and trailing spaces only" from... (2 Replies)
Discussion started by: kumar04
2 Replies
5. Shell Programming and Scripting
I'm currently writing my sql results to a file and they have trailing spaces after each field. I want to get rid of these spaces and I'm using this code:
TVXTEMP=$(echo $TVXTEMP|sed -e 's/\ //g')
It doesn't work though. I'm not familiar with sedscript, and the other codes I've found online... (6 Replies)
Discussion started by: avillanueva
6 Replies
6. Shell Programming and Scripting
Hi All,
I am having a file which contains negative numbers, wht i am doing is re-formattting the file(moving few columns and add few hard codings between), while reformatting i would want the negative numbers to have the sign as trailing rather than leading.
Existing
-2400.00
34
0.00... (11 Replies)
Discussion started by: selvankj
11 Replies
7. Shell Programming and Scripting
Does anyone know of a way with C Shell that will work on both Linux and Sun to clear all leading and trailing blanks from a previously specified string? I am using the following code to replace blanks with underscores:
set Company = `echo $Company | sed 's/ /_/g
but I don't want any... (1 Reply)
Discussion started by: phudgens
1 Replies
8. Shell Programming and Scripting
Hi All,
I am using a informatica job to create a csv file and a unix script the mail the generated file.Everything is working fine but I am not seeing leading zeros in the csv file sent in the mail.These zeros were present when the .csv file was generated by informatica procees.
Is there any... (11 Replies)
Discussion started by: karthik adiga
11 Replies
9. Shell Programming and Scripting
Hi,
I am trying to remove leading and trailing spaces from a file using awk but somehow I have not been able to do it.
Here is the data that I want to trim.
07/12/2017 15:55:00 |entinfdev |AD ping Time ms | .474| 1.41| .581|green |flat... (9 Replies)
Discussion started by: svajhala
9 Replies
10. Shell Programming and Scripting
Hi
I have variable named tablename. The value to tablename variable has leading and trailing white spaces. How to remove the leading and training white spaces and write the value of the tablename without space to a file using shell script. ( for e.g. tablename= yyy )
INPUT
... (10 Replies)
Discussion started by: pottic
10 Replies
LEARN ABOUT OPENDARWIN
set_color
set_color(1) fish set_color(1) NAME
set_color - set_color - set the terminal color set_color - set the terminal color Synopsis set_color [-v --version] [-h --help] [-b --background COLOR] [COLOR] Description Change the foreground and/or background color of the terminal. COLOR is one of black, red, green, brown, yellow, blue, magenta, purple, cyan, white and normal. o -b, --background Set the background color o -c, --print-colors Prints a list of all valid color names o -h, --help Display help message and exit o -o, --bold Set bold or extra bright mode o -u, --underline Set underlined mode o -v, --version Display version and exit Calling set_color normal will set the terminal color to whatever is the default color of the terminal. Some terminals use the --bold escape sequence to switch to a brighter color set. On such terminals, set_color white will result in a grey font color, while set_color --bold white will result in a white font color. Not all terminal emulators support all these features. This is not a bug in set_color but a missing feature in the terminal emulator. set_color uses the terminfo database to look up how to change terminal colors on whatever terminal is in use. Some systems have old and incomplete terminfo databases, and may lack color information for terminals that support it. Download and install the latest version of ncurses and recompile fish against it in order to fix this issue. Version 1.23.1 Sun Jan 8 2012 set_color(1)