I would like to copy 2 parts of a csv file from Unix to an XL sheet. However to save time I do not want to format the column ever time I cut and paste into XL(Text2Column). I've used awk -F, '{Print $1, $2....}'. Is there a script or code that can automatically format the csv for XL columns?
... (3 Replies)
Dear All,
I have requirement like this:
I have 2 camma seperated files
file1:
1,aaa,bbb,ccc,
2,bbb,ccc,ddd,
3,ccc,ddd,eee,
file2:
1,aaa,bbb,ccc,
2,bbb,ddd,ddd,
3,ccc,ddd,eee,
my requirement is I should get message in the out put like:
There is a difference in 3 rd filed in... (2 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Hi All,
I am new to unix, my requirement is like need to find the files like DATA_FUNCTION* and put those... (1 Reply)
I am in the process of creating a BASH shell scripts for a project at work. So the scenario is as such:
I have a file with each line entry separated by ':'
... (3 Replies)
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)
Hi,
I have a large number of files which are written as csv (comma-separated values).
Does anyone know of simple sed/awk command do achieve this?
Thanks!
---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ----------
Guess I asked this too soon. Found the... (0 Replies)
Hi,
I want to change a file file1.txt:
1234
3456
2345
6789
3456
2333
4444
As, file2.txt in Linux:
'1234','3456','2345','6789','3456','2333','4444'
Could someone please help me. (Single liner sed, awk will be welcome!) (7 Replies)
Hi Everyone,
On my Linux box I have a text file having block of few lines and this block lines separated by one blank line. I would like to format and print these lines in such a way that this entire block of lines will come as single comma separated line & again next block of lines in next... (7 Replies)
Hi,
I have a list of tables in a file.txt
C_CLAIM
C_HLD
C_PROVIDER
I want the output to be
'C_CLAIM','C_HLD','C_PROVIDER'
Currently I'm usin awk and getting output which is almost correct but still has minor defects
awk -vORS="','" '{ print $1 }' file.txt
The output of... (4 Replies)
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
Discussion started by: as7951
3 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)