I have one more qn on the same as what if the data has double quotes(") as a field seperator?
What could be the description column position ,if the field seperator is double quotes(") ?
Thanks for the patience...
Just replace the field separators with a double quote:
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
Hi, I have a problem..
1) I have a file that contains the lines as below :
VRF-TM_DummyLab/mse02.lab,mse02.lab,ge-2/0/7.222
VRF-EMS_HUAWEI_MSAN_208/mse01.lab,mse01.lab,xe-1/0/0.208
2) I need a method to read this file, line by line
from :... (5 Replies)
HI,
Please find the text below. I receive a .csv file on server. I need the comma(,) in the second column to be replaced by a semi-colon( ; ).
How to do it. Please help.
Sample text:
"1","lastname1,firstname1","xxxxxx","19/10/2009","23/10/2009","0","N","Leave"... (2 Replies)
Hello,
I need to read a csv file and I am trying to replace a comma with a text DSEE?DSEE.
Example
Input
"Chapter","NewTrains, "oldTrains","Delayed",10,"London"
"Chapter","Newbuses,oldbuses","On Time",20,"London"
Output
"Chapter","NewTrainsDSEE?DSEE... (5 Replies)
Hello
I have a csv file which I need to insert addtional commas into. The csv is of the format
field1,field2,field3,field4,...etc...,field13,field14
I need to add extra commas in each record so that the final output looks like
... (1 Reply)
Hello there,
I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process.
Input in the csv file is ,
1,234,"abc,12,gh","GH234TY",34
I need output like below,... (8 Replies)
Source 1
column1 column2 column 3 column4
1,ganesh,1,000,1
222,ram,2,000,5
222,ram,50,000,5
33,raju,5,000,7
33,raju,5,000,7
33,raju,5,000,8
33,raju,5,000,4
33,raju,5,000,1
In my .csv file, third column is having price value with comma (20,300), it has to be considered 1,000 as... (1 Reply)
Hi... I can't find my little red AWK book and it's been a long while since I've awk'd. But I need to take a CSV file and convert the first word of the fifth field to its own field by replacing a space with a comma.
This is for importing a spreadsheet of issues into JIRA...
Example:
a line... (9 Replies)
Hi have a comma separated file which has numeric and string columns. String columns are quoted and can have comma in between the quotes. How to identify the columns with FS =","
sample records"prabhat,kumar",19,2000,"bangalore,India"
In awk it should be$1 = prabhat,kumar
$2=19
$3=2000... (9 Replies)
Discussion started by: prabhat.diwaker
9 Replies
LEARN ABOUT CENTOS
gvfs-ls
GVFS-LS(1) User Commands GVFS-LS(1)NAME
gvfs-ls - List files
SYNOPSIS
gvfs-ls [OPTION...] [LOCATION...]
DESCRIPTION
gvfs-ls lists information about the given locations. If no location is given, it defaults to the current directory.
gvfs-ls is similar to the traditional ls utility, but using gvfs locations instead of local files: for example you can use something like
smb://server/resource/file.txt as location.
File attributes can be specified with their gvfs name, e.g. standard::icon, or just by namespace, e.g. unix, or by '*' which matches all
attributes. Several attributes or groups can be specified, separated by comma.
OPTIONS
The following options are understood:
-?, --help
Prints a short help text and exits.
-a, --attributes=ATTRIBUTES
The attributes to get, specified as a comma-separated list of gvfs file attribute names.
-h, --hidden
Show hidden files.
-l, --long
Use a long listing format.
-c, --show-completions=PREFIX
Show only filenames starting with PREFIX.
-n, --nofollow-symlinks
Don't follow symlinks.
EXIT STATUS
On success 0 is returned, a non-zero failure code otherwise.
SEE ALSO ls(1), gvfs-info(1)gvfsGVFS-LS(1)