i am new to this forum, but i think it's quite the best place to post.
So, here is my pb :
I have a csv file, with comma separator and text enclosed by ".
First pb is with text in " ......... ", wich sometimes includes lines break, and commas
And to complicate a little more, there can have many text fields on one line.
Which make it difficult to pushup lines and keep the good field number.
Which also make it impossible to use /,{87}/ s/....// to filter complete lines.
i spend quite a big time trying to reformat the lines using sed , but without success.
The file comes from gmail contacts, and is 88 fields ( so 87 separators ) .
You'll find an example file in attachment
I feel quite lost on this one, so any help highly welcome,
thanks in advance
Yogeek
Hello all,
I am trying to delete all the lines in a particular file having a pattern. The problem is that it has special characters and for some reason is not doing the job.
For eg.
src_file
/home/test/filelist.txt :xxxx:ogog
/home/test/RCH/ogogogg
/home/test/RYHUJ/HHHH... (3 Replies)
Good day, everyone!
Could anybody explain me the following situation.
If I'm running similar script:
Var="anna.kurnikova"
Var2="Anna Kurn"
echo $Var | tr -t "$Var" "$Var2"
Why the output is :
anna KurniKova
instead of Anna Kurnikova?
:confused:
Thank you in advance for any... (2 Replies)
Hi there
I am trying to convert some date seperators in a large newline delimited file. each line i am interested in has a date in the format 27/05/2009 all I want is to convert the slashes to tildes(~) I have come up with the following code but it does nothing.
sed... (5 Replies)
Hi All,
I have the following data in a korn shell variable:
a="FirstValue|SecondValue|ThirdValue"
The value between "FirstValue", "SecondValue" and "ThirdValue" can change, in this case is a comma: "," and I need to print it only once. I need to know what is the separator value.
I... (3 Replies)
Hi,
I need to create an script which reads multi lines and convert it to single line or enter escape sequence at end "\".
e.g.
#!/bin/sh
echo -e "provide me query to run"
read query
create table test(
id int(11),
name char);
echo $query
But it's failing because of multi line... (8 Replies)
My txt file consists of records with 6 numbers followed by 3 characters.
Is there a simple “sed” which will insert a | separator between the 6th and 7th position ?
Many thanks (3 Replies)
Hello All,
I have a problem in counting number of process getting run with my current script name..
Here it is
ps -ef | grep $0 | grep -v grep
This display just one line with the PID, PPID and other details when i print it in the script.
But when I want to count the numbers in my... (11 Replies)
Hi All,
Could you please help to get the below output:
Input:
J1,ELLA_1,ISDR,JJK,TRS
J2,ROSTER,JACK
J3,HUP
...
...
...
Output:
J1,ELLA_1
J1,ISDR
J1,JJK
J1,TRS (3 Replies)
#!/bin/bash
X=(0 2 4 6 7 0 0 0 0)
Let me just say from the start that sed confuses the hell out of me!
In the above line of code how can I use sed to remove all of the 0's except the first one?
I have tried sed -e 's/*$//g' but it removes all of the 0's.
Thank you in advance for any and... (3 Replies)
#!/bin/bash
PH=(KD 6S TC 3D) #playerhand
TCIP=(AH) #topcard in play
A=( "${TCIP::1}" ) # A
B=( "${TCIP:1}" ) # H
C=8
for e in ${PH}; do
if ]; then
echo "$e " >> /home/cogiz/validcards.txt
else
echo... (1 Reply)
Discussion started by: cogiz
1 Replies
LEARN ABOUT HPUX
fmt
fmt(1) General Commands Manual fmt(1)NAME
fmt - format text
SYNOPSIS
width] [file...]
DESCRIPTION
The command is a simple text formatter that fills and joins lines to produce output lines of (up to) the number of characters specified in
the width option. The default width is 72. concatenates the arguments. If none are given, formats text from the standard input.
Blank lines are preserved in the output, as is the spacing between words. does not fill lines beginning with a period for compatibility
with Nor does it fill lines starting with
Indentation is preserved in the output and input lines with differing indentation are not joined (unless is used).
can also be used as an in-line text filter for the command:
reformats the text between the cursor location and the end of the paragraph.
Options
recognizes the following options:
Crown margin mode.
Preserve the indentation of the first two lines within a paragraph and align the left margin of each subsequent line with that
of the second line. This is useful for tagged paragraphs.
Split lines only.
Do not join short lines to form longer ones. This prevents sample lines of code, and other such "formatted" text, from being
unduly combined.
Fill output lines to up to
width columns.
WARNINGS
The width option is acceptable for BSD compatibility, but it may go away in future releases.
SEE ALSO nroff(1), vi(1).
fmt(1)