Hello All,
I need to convert a csv file to pipeline delimiter file in UNIX. The data in file itself contains comma with double qouted qualifier apart from the comma separator. Let me know how to do it.
In shell script i have two variables with value
Code:
debit_sal="DOG,HIU,JIU,GYT,PPI,KIU,HUY........."
debit_req='HIU, JIU, HUY, GTR, KOI, ............"
i stored this two in two array
arr=$(echo $debit_sal| tr "," "\n");
arr1=$(echo $debit_req| tr ", " "\n"); #(note second arry has comma with space)
set -A dfArr $arr
set -A drArr
Hello All,
Got an issue on sending an email with comma seperated values.
Say my file is abc.txt which is
Code:
cat abc.txt
123,456,the american express,America,Day
I will send in a Spread sheet which come in 5 columns.
Hi all,
I have declared an array in unix as below.
Code:
#!/bin/ksh
arr=()
for i in {0..4}
do
arr[i]=$i;
done
.
i want to insert these array variables into the oracle table.can you guys please help me in doing this.
I am new to ksh scripting, specially array.
I am in the process of creating a BASH shell scripts for a project at work.
Hi!
Let's say I would like to convert "1", "2", "3" to "a", "b", "c" respectively.
I have a comma (,) delimited file.
Code:
106232145,"medicare","medicare,medicaid",789
I would like to count the number of fields in each line.
I tried the below code
Code:
awk -F ',' '{print NF-1}'
This returns me the result as 5 instead of 4.
Hi friends,
i have a file which contains all words(including comma) in different line.
for example:
more file.txt
HTML Code:
select
column1
from
table1
,
table2
join
table3
0n
condition
i just want to get table2 if there is a comma after table1(as shown in the above case) else dont fetch anything.
please help.
thanks in advance.