<div>
<div class="content wysiwyg-content">
Having exported data from an MS Access database to csv format I have now realised that the currency fields are in format ...,£1234.56,...<br />
<br />
Once the csv file is shifted onto Linux and the command &quot;head --lines=10 file.csv&quot; is run the system seems incapable of reading the £ sign and it looks like a blank space. &nbsp;However when I try and copy and paste any part of the output which contains the 'space' it will not function (any other part of the output can be copied and pasted).<br />
<br />
Is there some way sed can strip this unknown character out of the csv, or is there alternatively some way to make Linux recognise this character correctly?<br />
<br />
By the way, changing the fields to not be currency in MS Access is not an option.<br />
<br />
Thanks in advance
</div>
</div>


Having exported data from an MS Access database to csv format I have now realised that the currency fields are in format ...,£1234.56,...

Once the csv file is shifted onto Linux and the command "head --lines=10 file.csv" is run the system seems incapable of reading the £ sign and it looks like a blank space.  However when I try and copy and paste any part of the output which contains the 'space' it will not function (any other part of the output can be copied and pasted).

Is there some way sed can strip this unknown character out of the csv, or is there alternatively some way to make Linux recognise this character correctly?

By the way, changing the fields to not be currency in MS Access is not an option.

Thanks in advance

using sed to select csv field and remove first (leading) character

A Linux distribution is an operating system made as a software collection based on the Linux kernel and, often, on a package management system and are available for a variety of systems. A typical Linux distribution comprises a Linux kernel, GNU tools and libraries, additional software, documentation, a window system (the most common being the X Window System), a window manager, and a desktop environment. Most Linux systems are open-source software made available both as compiled binaries and in source code form, allowing modifications to the original software. Over three hundred distributions are in active development, including commercially backed distributions (such as Fedora, openSUSE and Ubuntu) and community-driven distributions (such as Debian, Slackware, Gentoo and Arch Linux).

Linux Distributions

Kernel programming for Linux operating systems can be done with many different languages; C, C++, Python, Perl and Java, which are some of the most common languages used.There are also many different varieties of Linux, such as Ubuntu, Fedora and OpenSUSE.