Search Results

can I combine everything as ?? sed 's/|/","/g; s/^/"/; s/$/"/; 's/"="/="/g; s/""~/"/g' A4.txt > A5.csv

I have a csv file which is produced out of a SED command sed 's/|/","/g; s/^/"/; s/$/"/' A4.txt > A5.csv and I need either an addition to the SED command or a separate command to convert the...

thanks blastit but unfortunately my requiremenst dont allow me to do a xml and thhe conversion..I ahve figured out how to prevent the dropping of leading zeroes but I need a SED code that would work...

the sed code seems to be working fine but its throwing me off when the data contains double quotes within them .I have attached picture of what I am talking about.sed 's/|/","/g; s/^/"/; s/$/"/'...

the sed code works fine but the only issue I am faced with now is when the pipes are being converted to commas i.e when my file is made csv and when opened using Microsoft excel I am losing the...

2 things Don

1)I still dint get the AWk working both for (q and nq).I also tried the awk -F'[|]' -v OFS='","' 'NF{$1 = $1; $0 = "\"" $0 "\""}1' A4.txt > A5q.csv.dont know if its somethng to do...

I have attched the input A4.txt .

When I run the big awk commnd the one which takes care of quotes my output is A5.txt-which is attached but when I run the other awk my output is same as A4.txt

neither of these above AWK codes are giving me desired output as I could still see PIPES as field delims but not commas...

however the awk code which takes care of quotes and comas is just putting...

Hey Don

Much thanks for looking into this.I am using AIX 7.2.I dont think length of line is a problem and is very well within limits.I tried the AWk you suggested and I got an error.

A.txt is...

another thing I forgot to mention is I dont know pre hand how many fields exist in the file meaning A2.txt can have 0-n number of fields ..The file A2.txt might have any number of variable fields.

Hello ppl

I have a requirement to split (cut in unix) a file (A.txt) which is a pipe delimited file into A1.txt and A2.txt

Now I have to join (paste in unix) this A2.txt with external file...

that worked great.thanks a lot

I have actually tried that but this time..It does not throw any error but takes ever to run and eventually I have to cancel the execution

---------- Post updated at 02:34 PM ---------- Previous...

this thread is a continuation from previous thread
https://www.unix.com/shell-programming-and-scripting/223901-split-big-file-into-multiple-files-based-first-four-characters.html

..I am using awk...

I need this done on a daily basis like an automated things so hence I cant format it manually..

second thing is I am looking for a shell script/perl script which will take the csv on unix and give...

even if its not for the dates..I just want to format the text and numbers.

Hello friends

I want to convert an csv file on unix (which is generated by a ETL application) to a formatted excel sheet like .I have roughly like 28 columns


1)All numbers need to be stored...

great and thanks corona ! that worked awesome ..

Thanks guys for quick turnaround !!

---------- Post updated at 01:39 PM ---------- Previous update was at 09:44 AM ----------

I was using this awk command on the input file ($1) which is...

I have a requirement to split a huge file to smaller text files based on first four characters which look like
ABCD
1234
DFGH
RREX
:
:
:
:
:
0000

Each of these records are OF EQUAL ...

well this is what I have .I did a tty and

/dev/pts/1


but in general how do we set that option

guys

can any one help me how to set top arrow to get the history of last used commands.I am using ksh

I am poor at scripting.Can any one help me write a script which parametrizes the script here .

#!/bin/bash

`rm file1.txt`
lineCount=0
newRec=1...