<div>
<div class="content wysiwyg-content">
I have a CSV FILE as shown below and would like to convert Quantity column from scientific notation to Decimal format.<br />
<br />
&quot;Rate Set Date&quot;,&quot;Trader&quot;,&quot;Name&quot;,&quot;cle<wbr />ar_agent&quot;,<wbr />&quot;Tid&quot;,&quot;Qua<wbr />ntity&quot;,&quot;Fu<wbr />nd&quot;<br />
&quot;12/20/17&quot;,&quot;test&quot;,&quot;USD FRA 3.31875 3MLIB 2017-12-20 2018-03-21 LCH&quot;,&quot;CSOTCLR&quot;,423665,2.0E<wbr />9,&quot;SYN&quot;<br />
&quot;12/18/17&quot;,&quot;test11&quot;,&quot;USD FRA 3.31875 3MLIB 2017-12-20 2018-03-21&quot;,&quot;SYNGRN&quot;,36533<wbr />1,2.0E9,&quot;S<wbr />YN&quot;<br />
&quot;12/18/17&quot;,&quot;test&quot;,&quot;USD FRA 1.453 3MLIB 2017-12-20 2018-03-21 LCH&quot;,&quot;CITOTCLR&quot;,726073,1.8<wbr />E9,&quot;TT2&quot;<br />
<br />
Is it possible in PowerShell?
</div>
</div>


I have a CSV FILE as shown below and would like to convert Quantity column from scientific notation to Decimal format.

"Rate Set Date","Trader","Name","clear_agent","Tid","Quantity","Fund"
"12/20/17","test","USD FRA 3.31875 3MLIB 2017-12-20 2018-03-21 LCH","CSOTCLR",423665,2.0E9,"SYN"
"12/18/17","test11","USD FRA 3.31875 3MLIB 2017-12-20 2018-03-21","SYNGRN",365331,2.0E9,"SYN"
"12/18/17","test","USD FRA 1.453 3MLIB 2017-12-20 2018-03-21 LCH","CITOTCLR",726073,1.8E9,"TT2"

Is it possible in PowerShell?

Convert Scientific Notation column to Decimal in Powershell

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.